Shifts
Detailed information about a shift is recorded in the ShiftSum table. Associated information is stored in the following view:
- V_ShiftLog
V_ShiftLog
The V_ShiftLog view stores a history of the shifts that have occurred:
| Column | Description |
|---|---|
| Period_Shift | Description of the shift. For example: Production Day Shift Friday, August 29, 2008. |
| Period_Year | The year in which the shift occurred: 2008 |
| Period_Month | The month in which the shift occurred: Aug-2008 |
| Period_Day | The day of the shift: 29-Aug-2008 |
| ShiftCode | A key to identify the current shift. This column is not used for Micromine Pitram 3. |
| LastShift_Shift | Obsolete column. |
| Shift_Key | A key used to identify the shift. This key links with the SHKey in the ShiftSum view. Shift_keys have the following format: |
| yyyymmdd[1 character roster code][1 character shift number] | |
| Period_Month_Code | The month in which this shift occurred. The format is [year][month] = 200808 |
| Period_Year_Code | The year in which this shift occurred. For example: 2008 |
| Period_Day_Code | The day that the shift occurred. The format is [year][month][day] = 20080812 |
| Period_Shift_Code | A copy of the Shift_Key. |
| Period_All | A column generated by the system. This value is used when defining a report in the Pitram Reporting service—one of the Summary Levels of a report definition has an All option. |
| Period_Add_Code | A column generated by the system. This is a copy of the Period_All column. |
| Period_Week | A column generated by the system. Some sites work on production periods which are site defined periods that best suit site target periods. Production periods, for example, may complement the work on site with the Pitram Targets service. |
| The format is [year]Week [week number]. Week number, for example, may not be equal to the calendar week number. | |
| Period_Week_Code | A column generated by the system. The format is [year] [week number] |
| Period_ProductionPeriod | If the site is : |
| • Working with production periods. The value will be the defined production period. For example, JAN_FEB 2011. | |
| • Not working with production periods. The value will be NULL. | |
| Period_ProductionPeriod_Code | This is a copy of the Period_ProductionPeriod. |
| PeriodProductionPeriod_SortCode | If the site is : |
| • Working with production periods. This will be a unique code generated by the system to identify the particular production period. | |
| • Not working with production periods. The value will be NULL. |