Understanding the Time Administration Control Table (TL_TR_STATUS)

TL_TR_STATUS is a control table in Time and Labor that is regularly updated by Time Administration and other processes. It is important to understand how and when this record gets created and updated, since it essentially controls the behavior of Time Administration.

When time reporters are enrolled in Time and Labor, the system creates a TL_TR_STATUS control record for each distinct time reporter. This control table is updated when certain changes are made to time related data. Specifically, there are two fields that tell Time Administration how much data to process for each time reporter:

  • TA_STATUS

  • EARLIEST_CHGDT

For exception and positive time reporters, TA_STATUS is initially set to Y and EARLIEST_CHGDT is set to the Time and Labor enrollment date.

When changes are made to reported time, EARLIEST_CHGDT gets updated if EARLIEST_CHGDT is later than the change date and TA_STATUS is set to Y.

Time Administration selects records with TA_STATUS = Y or X and EARLIEST_CHGDT is earlier or equal to the Process Date specified on the run control to be processed.

At the beginning of Time Administration (TL_TA000300), TA_STATUS gets set to X to indicate to other processes that it is being processed.

At the end of Time Administration (TL_TA001300), TA_STATUS and EARLIEST_CHGDT get updated as follows:

  • For positive time reporters without exceptions, TA_STATUS gets set to N and EARLIEST_CHGDT gets set to the latest date of payable time. If no changes are made to reported time, positive time reporters will not be selected for processing in subsequent Time Administration runs.

  • For exception time reporters without exceptions, TA_STATUS gets set to Y and EARLIEST_CHGDT gets set to the first day of the next time period (specified on work group). Exception time reporters will always be selected for processing in subsequent Time Administration.

  • For all time reporters with exceptions, TA_STATUS gets set toY and EARLIEST_CHGDT gets set to the first day of the exception. This way, exceptions will be processed and resolved.

Note:

The Earliest Change Date (ECD) will be reset to the effective date upon rehiring or when reactivating a time reporter. ECD will not be reset if there are previous pending rows to be processed.