Topics Map > Human Resource System (HRS) > Time and Labor
Running the TA Status and Earliest Change Date Query in HRS
Overview
The Time Reporter Status consists of the TA_STATUS and the Earliest Change Date (ECD). Time Administration (TA) uses the TA_STATUS and ECD to determine which Time Reporters to process. The most common reason an employee is not selected by TA for processing is because the TA_STATUS and/or the ECD is not set correctly. In order to be processed by TA, the TA_STATUS must be set to 'Y' and the ECD must be less than or equal to the process date on the Time Admin Process page.Process Considerations:
- The TA_STATUS and Earliest Change date can be viewed on the Time Reporters Status page. There is an option to view the status of one employee at a time by Emplid or you can view the status for multiple employees using the Group_ID.
Instructions
- Navigate to the Time Reporter Status page: Time and Labor > View Time > Time Reporters Status.
- To retrieve the status of one employee at a time, enter the Empl_ID.
- Click GET Employees button.
- To retrieve the status for multiple employees in a group, use the Group_ID field.
- Enter a Group_ID.
- Click the GET Employees button.
The Earliest Change Date: The earliest addition or update to time related data for a time reporter since the last Time Admin run.
TA Status:
- Not Up For Processing: The time reporter is not ready for processing by the Time Admin job.
- Up For Processing: The time reporter is ready for processing by the Time Admin job.
- In Process: The time reporter is being processed by the Time Admin job.
Time Reporter Status Maintenance: Timesheet and Time Administration
Timesheet
The Time Reporter Status is set by the timesheet when time is reported or changed. Its also set by the Time Admin process. Both applications maintain the Time Reporter Status based on the employee type. At the UW there are two types of employees: exception and positive pay.
- The first type of employee is the Exception Time Reporter. Exception Time Reporter's hours are created automatically by the system based on the employee's schedule. Exception Time Reporters only have to report exceptions to their schedule time. (Examples of exceptions are SICK, VAC, JURY DUTY, etc.) For the Exception Time Reporter, the TA_STATUS is always set to 'Up For Processing'. The ECD is initially set to the date of the next time period and is updated to the earliest dated time change if any time transactions are modified.
- The second type of employee is the Positive Pay Time Reporter. Positive Pay Time Reporters are employees who are required to report and enter hours worked into the system. Positive Time Reporters must report their time in order to receive pay. For these employees, the TA_STATUS is initially set to 'Not Up For Processing' and is set to 'Up For Processing' when time is reported or changed. The ECD is initially set to the date of the next time period and is updated to the earliest dated time change if any time transactions are modified.
An example of how the Time Reporter Status would be updated: Time is changed for employee 12345678 on 10/01/2010, 10/10/2010 and 11/01/2010. The Time Reporter Status would be set to TA_STATUS = 'Up For Processing', ECD = '10/01/2010'.
Time Administration (Time Admin)
When Time Admin starts processing Reported Time, it changes the TA_STATUS to 'In Process'. The Time Admin process can be run by more than one person at a time. This setting makes sure that Reported Time transactions are processed by one Time Admin process at a time. Once the TA_STATUS is set to 'In Process', other instances of Time Admin will not try to process the same employee.
At the end of the processing cycle, Time Admin initializes both the TA_STATUS and ECD depending on the type of employee.
If the reported time is processed successfully, the TA_STATUS is reset to 'Not Up For Processing' for Positive Pay Time Reporters. For the Exception Time Reporter, the TA_STATUS is not changed. It remains set to 'Up For Processing'. For both types of Time Reporters, the ECD to set to the beginning of the next time period.
If an exception is generated for Reported Time, the TA_STATUS is set to 'Up For Processing' and the ECD remains the same. This ensures the exception is reprocessed each time Time Admin runs and allows the Time Admin process to check to see if modifications to the Reported Time will clear the exception.