Table Name:
|
ls_hist_base
|
|
|
|
|
|
|
|
|
|
|
Full Name:
|
Labor History
|
|
|
|
|
|
|
|
|
|
|
Table Type:
|
Production and Job Parameter
|
|
|
|
|
|
|
|
|
|
|
Description:
|
Labor summary for logged off employees
|
|
|
|
|
|
|
|
|
|
|
Record Frequency:
|
1 per login per child
|
|
|
|
|
|
|
|
|
|
|
Updated By:
|
Shop floor daemon
|
|
|
|
|
|
|
|
|
|
|
Primary Keys:
|
mach_seq, ls_mseq, child_idx
|
|
|
|
|
|
|
|
|
|
|
Fields:
|
mach_seq, ls_mseq, child_idx, family_seq, employee_id, cat_idx, start_time, start_ev, end_time, end_ev, host_lock, gross_pieces, net_pieces, idle_time, up_time, total_down_time, total_assist_time, total_reject, logged_time, ss_mseq, jts_mseq, job_seq, employee_name, labcat, mach_name, shift_id, job, product, tool, family_count, labor_cost
|
|
|
|
|
|
|
|
|
|
|