Product/Grade Changes
The main data tables for product/grade changes are:
| Table Name | Description |
|---|---|
| Production_Starts | Product/Grade changes |
The main configuration tables for product/grade changes are:
| Table Name | Description |
|---|---|
| Prod_Units | Production units |
| Products | Products |
Product changes are stored in the Production_Starts table and the logical key is on PU_Id, Start_Time and End_Time. Product change records are in a continuous sequence and cannot overlap (i.e. the Start_Time of a record must be the same as the End_Time for the previous record). There must also be a record for every PU_Id and sequence has to start at ‘1970-01-01 00:00:00.000’ (for example, the first record in the sequence must have a Start_Time of ‘1970-01-01 00:00:00.000’). The End_Time of the current product change record will be NULL.
Product changes are related to other data through the PU_Id and time (for example, to determine what product a production event is associated with, look for the product change record that occurred within the same time frame and on the same unit).