Work Detail Import Interface logic

This section describes how the standard Work Detail Import Interface converts work detail CSV data into the Workforce Management application. This section references field specifications in Work Detail Import Interface field specification.

Overrides

The data provided from the imported file is created as work detail and premium overrides in the Workforce Management application:

  • For work detail overrides, Ovrtyp_ID (column 2) must be between 100-199 (for pre-calc overrides) or 1200-1299 (for post-calc overrides).
  • For work premium overrides, Ovrtyp_ID (column 2) must be between 200-299 (for post-calc overrides) or 1300-1399 (for pre-calc overrides).
    Note: The WRKD Start_Time and End_Time columns cannot be supplied for work premium override types.
  • For LTA overrides, Ovrtyp_ID (column 2) must be between 500-599.
  • For standby overrides, Ovrtyp_ID (column 2) must be between 1400-1499.
  • For timesheet (elapsed time) overrides, Ovrtyp_ID (column 2) must be between 600-699. Optionally, you can also supply the Ovr_Order field in the Ovrtyp_ID column by adding a tilde (~) symbol after the override type. For example:

    600~1

    Ovr_Order determines the applied order of the timesheet override (the default Ovr_Order is 0).

    Note: WRKD End_Time cannot be supplied for elapsed time override types, as they are duration based.

All specified override types must exist in the Workforce Management application. If any of the required fields are not provided, no processing is done and the record is ignored. For UDFs and Flags, the ampersand (&) character has to be supplied to blank the fields.

The Work Detail Import Interface re-calculates the day if any overrides are inserted.