Shift Totals
Shift Totals are summary information for a shift.Shift totals are stored in tables beginning with ss_ .
Shift totals can be for the currently running shift record (ss_cur_ ) or completed shifts (ss_hist_ ).
When a job changes, a set of ss_hist_ records are created for the portion of the shift that is associated with the completed job. A new set of ss_cur records are begun for the new job. In this case, there are ss_hist_ records that actually cover the current shift.
Also, if the current job runs for more than 1 shift, there can be Shift totals in history (ss_hist_ ) for the current job (current Job Totals, jts_cur).
Shift Total for the current shift are stored in:
ss_cur_base base summary information
ss_cur_dar down, assist, reject summary information
ss_cur_pvar process variable summary information
A graphic relationship of current shift totals is available.
Shift Total information for completed shifts are stored in:
ss_hist_base base summary and parameter information
ss_hist_dar down, assist, reject summary and parameter information
ss_hist_mat material component parameters
ss_hist_pvar process variable summary and parameter information
A graphic relationship of shift history totals is available.
An additional table of interest for shift histories is eos_hist. eos_hist contains start and end times of each shift. This is needed because more than one machine can be on the same shift schedule. When a machine is offline or disabled the shift schedule still needs to be applied to the shop floor.