Table Name:
|
jts_hist_base
|
Full Name:
|
Job History Base
|
Table Type:
|
Production and Job Parameter
|
Description:
|
General production history for completed jobs
|
Record Frequency:
|
1 per production run per child
|
Updated By:
|
Shop floor daemon
|
Primary Keys:
|
mach_seq, jts_mseq, child_idx
|
Fields:
|
mach_seq, jts_mseq, child_idx, family_seq, mach_name, 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, job_seq, job, prod_seq, product, tool, family_count, comments, mat_formula, user_text_1, user_text_2, user_text_3, user_text_4, tote_box_size, tote_reject, std_cycle, cycle_tol, cycle_window, down_thresh, refeed_runner, refeed_scrap, sched_now, sched_factory, pieces_required, std_rate_factor, weight, std_mult, act_mult, reject_thresh, reject_mult, net_mult, required_by, spc_n, spc_interval, std_shot_weight, act_shot_weight, std_setup_time
|