Shift Pattern Import Interface logic

This section describes how the standard Shift Pattern Import Interface converts team CSV data into the Workforce Management application. This section references field specifications in Shift Pattern Import Interface field specification.

Processing logic

The Shift Pattern Import file is a CSV text file with columns enclosed in quotes if there are commas in the column field value. The records in the file are processed sequentially from top to bottom.

For each record (row) in the CSV file, the Shift Pattern Import Interface searches the Workforce Management database for existing shift patterns with similar data. If a shift pattern is found for the data that is provided and an employee is specified, the interface assigns the shift pattern to the employee by creating an employee shift pattern override. If the shift pattern data in the CSV file is not in the system, the interface creates the shift pattern and shifts.

These database tables and attributes are used to match the shift pattern data to an existing shift pattern in the Workforce Management database:

  • SHIFT_PATTERN (SHFTGRP_ID)
  • SHIFT_PATTERN_SHIFTS (SHFTPATSHFT_DAY, SHFT_ID, SHFT_ID2, SHFT_ID3, SHFT_ID4, SHFT_ID5)
  • SHIFT_PATTERN_SHIFT_LABOR (SPSLAB_START_TIME, SPSLAB_END_TIME, DOCK_ID, HTYPE_ID, JOB_ID, TCODE_ID, PROJ_ID, DEPT_ID, SPSLAB_FLAG[1-10], SPSLAB_UDF[1-10])
  • SHIFT (SHFT_START_TIME, SHFT_END_TIME)
  • SHIFT_BREAK (SHFTBRK_START_TIME, SHFTBRK_END_TIME, TCODE_ID, HTYPE_ID)

These tables are referenced in the processing logic: