Scheduled hours

The Scheduled column (TS_SCHEDULED_HOURS) shows the total number of hours the employee is scheduled to work each day. For example, if the employee is scheduled to work from 17:00 to 01:00, 08:00 is displayed for that day. If the employee is not scheduled to work on a day, then the scheduled hours value is blank.

Not all schedule details are included in the scheduled hours calculation. By default, a schedule detail is included in the calculation if both of these conditions are met:

  • The time code is not an LTA (Is LTA flag not selected).
  • The time code is not a scheduled break. See below for break definitions.

You can change the default behavior by configuring these localization parameters in config mode:

  • includeLTA

    Determines whether details with LTA time codes are included in the summary calculation. Specify one of these values:

    • true: All details with LTA time codes are included in the calculation.
    • false: All details with LTA time codes are excluded from the calculation. This is the default.
  • includeBreaks

    Determines whether scheduled breaks are included in the summary calculation. A break is defined as either:

    • A schedule detail with a time code that has the Is BRK flag selected.
    • A schedule detail with a defined Schedule Optimization activity that has the Paid Activity attribute set to No.

    Specify one of these values:

    • true: All scheduled break details are included in the calculation.
    • false: All scheduled break details are excluded from the calculation. This is the default.
  • decimalMinutes

    Determines whether the scheduled hours value is displayed in time or decimal format. Specify one of these values:

    • true: The value is displayed in decimal format (for example, 8.50).
    • false: The value is displayed in time format (for example, 8:30). This is the default.

To calculate the scheduled hours, the schedule details are retrieved from the EMPLOYEE_SCHEDULE and EMPLOYEE_SCHED_DTL tables. The minutes are then summed up considering the includeLTA and includeBreaks configuration parameters.