Crew Schedule

The main data tables for the crew and shift schedule are:

The main configuration tables for the crew and shift schedule are:

The Crew_Schedule table holds detailed records for each shift change. Instead of containing a pattern or formula for calculating crew and shift, it contains a time-stamped record for every shift change. This table is normally filled out by hand in Excel and imported for a defined amount of time determined by the plant actual crew schedule forecast.

Shift/Crew changes are related to other data through the PU_Id and time (for example, to determine what shift a production event is associated with, look for the shift change record that occurred within the same time frame and on the same unit).