Worked hours

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

Not all work details are included in the worked hours calculation. Hour types that are unpaid (Multiple attribute set to 0) are always excluded from the summary total. In addition, only details with summarizable hour types (Hour Type Summarize flag selected) are eligible to be included. Non-summarizable hour types are always excluded from the summary total.

By default, a time code is eligible to be included if all of these conditions are met:

  • The time code is summarizable (Time Code Summarize flag selected).
  • The time code is not an LTA (Is LTA flag not selected).
  • The time code is not a break code.

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

  • includeLTA

    Determines whether LTA time codes are eligible to be included in the summary calculation. Specify one of these values:

    • true: LTA time codes are eligible to be included in the calculation. Only those details with summarizable hour types that are paid (Multiple attribute not set to 0) are eligible.
    • false: LTA time codes are not eligible to be included in the calculation. This is the default.
  • includeBreaks

    Determines whether break time codes are eligible to be included in the summary calculation. Specify one of these values:

    • true: Break time codes are eligible to be included in the calculation. Only those details with summarizable hour types that are paid (Multiple attribute not set to 0) are eligible.
    • false: Break time codes are not eligible to be included in the calculation. This is the default.
  • forceIncludeTimeCodes

    Specifies a comma-separated list of time codes that are eligible to be included in the summary calculation regardless of the includeLTA, includeBreaks, and Time Code Summarize settings. Only those details with summarizable hour types that are paid (Multiple attribute not set to 0) are eligible. If a detail has a time code that is included in this list and a hour type with the Multiple attribute set to 0, the detail is not included in the calculation of the summary total.

  • forceExcludeTimeCodes

    Specifies a comma-separated list of time codes that are always excluded from the summary calculation. If a detail has a time code that is included in this list, the detail is not included in the calculation of the summary total.

  • varianceThreshold

    Determines the difference (in minutes) between the scheduled time and worked time that is required for the worked hours value to be highlighted. The difference must exceed (in either direction) the value that is specified. The default is 0.

    For example, assume the scheduled time is 8:00 and the threshold is set to 1. If the worked time is 8:01, the worked time would not be highlighted. If the worked time is 8:02, the worked time would be highlighted.

  • decimalMinutes

    Determines whether the worked 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.
  • includePremiums

    Determines whether premiums are eligible to be included in the summary calculation. Specify one of these values:

    • true: Premiums are eligible to be included in the calculation. This is the default.
    • false: Premiums are not eligible to be included in the calculation.

    The forceIncludeTimeCodes and forceExcludeTimeCodes parameters take precedence over this parameter on a per time code basis. This lets you make exceptions for specific situations in which some premiums reflect work time while other premiums do not.

    For example, you can include most premium records but exclude shift differential records (DIFF) from the Worked total using these settings:

    forceExcludeTimeCodes='DIFF' includePremiums='true'

    You can exclude most premium records but include guaranteed time (GUAR) in the Worked total using these settings:

    forceIncludeTimeCodes='GUAR' includePremiums='false'