Shift pattern search logic

The Shift Pattern Import Interface processes each record (entry in the data file) as follows:

  1. Searches the given shift pattern data record in the system.
  2. If all of these options are true for a particular shift pattern in the system, then a shift pattern is found (this particular shift pattern already exists in the system):
    • Shift Group Name is the same.
    • Contains the same number of shift pattern shifts (days), where each shift pattern shift (each record in SHIFT_PATTERN_SHIFTS):
      • Contains the same number of shifts (Shft_Id .. Shft_Id5)
      • Has the same start/end times (Shft_Start_Time, Shft_End_Time), break start/end times (Shftbrk_Start_Time, Shftbrk_End_Time), time code (Tcode_Id), and hour types (Htype_Id)

      If the Workforce Management registry setting SHIFT_PATTERN_LABOR_ENABLED is set to true and the shift pattern labor allocation is enabled, then this information must also be true:

    • Has the same number of shift pattern labor allocations (SHIFT_PATTERN_SHIFT_LABOR records) with identical attributes (attributes listed in the brackets next to the SHIFT_PATTERN_SHIFT_LABOR table).