Table Name:
|
ss_cur_base
|
|
|
|
|
|
|
|
Full Name:
|
Current Shift Summary Base
|
|
|
|
|
|
|
|
Table Type:
|
Production
|
|
|
|
|
|
|
|
Description:
|
Production summary general information for current shift/job
|
|
|
|
|
|
|
|
Record Frequency:
|
1 per machine per child (new record starts on job change)
|
|
|
|
|
|
|
|
Updated By:
|
Shop floor daemon
|
|
|
|
|
|
|
|
Primary Keys:
|
mach_seq, child_idx
|
|
|
|
|
|
|
|
Fields:
|
mach_seq, child_idx, ss_mseq, family_seq, shift_id, 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
|
|
|
|
|
|
|
|