Table Name:
|
jts_cur_base
|
|
Full Name:
|
Current Job Summary
|
|
Table Type:
|
Production
|
|
Description:
|
Production summary for current job
|
|
Record Frequency:
|
1 per machine per child
|
|
Updated By:
|
Monitor and work order import
|
|
Primary Keys:
|
mach_seq, child_idx
|
|
Fields:
|
mach_seq, child_idx, jts_mseq, family_seq, start_time, start_ev, end_time, end_ev, host_lock, total_cycles, up_cycles, slow_cycles, fast_cycles, gross_pieces, net_pieces, net_box_count, idle_time, up_time, total_down_time, total_assist_time, total_reject, total_down_count, total_assist_count, offline_state, offline_since, fast_state, fast_since, slow_state, slow_since, suspend_state, suspend_since, down_select, down_state, down_since, assist_state, assist_since, pvar_except_state, pvar_except_since, prod_except_state, prod_except_since, rio_state, rio_offline_since, cur_language, last_job_que_lock, last_hist_lock, last_cycle, last_log_idx, avg_cycle, master_mseq, pv_file_slot, current_pv_file, est_end_time, est_duration
|
|