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.