Maintain Payroll RP20 Or RP25 Records - Employee Time tab

The Employee Time tab on the TX Team Report - Payroll (RP20/RP25) page consists of the following sections:

Current Data

You should only update fields in this section.

The following table describes the fields in the Current Data section of the Employee Time tab of the TX Team Report - Payroll (RP20/RP25) page when the Record Code selected in the General section is RP20 or RP25.

Field	Description	Load logic - Data source and Valid values
Hours Worked	The actual number of hours worked by the employee. If Actual Hours have been uploaded for this employee, the field will display that number.	Calculated during the data load process. The calculated value represents the total compensated hours for the employee during the reporting period, derived primarily from the payroll check history and adjusted for position distributions, pay methods, and attendance policies. The field value is stored in the tx_team_pay.actual_hours field.
Hours Scheduled	The number of hours the employee is scheduled to work in a week.	Calculated during the data load process. The calculated value represents the weekly scheduled hours for the employee's position, derived primarily from employee-specific FTE configurations and position definitions, and adjusted for employee type classifications, position FTE percentages, and special employment categories such as substitutes or part-time workers. The field value is stored in the tx_team_pay.sched_hours field.
Days Worked	The actual number of days worked by the employee. Includes paid leave. If this field value is 0, you must select a value in the Zero Days Reason Code field.	Calculated during the data load process. The calculated value represents the total compensated days for the employee during the reporting period, derived primarily from the payroll timecard history and adjusted for attendance policies, docking events, and position distributions. The field value is stored in the tx_team_pay.days_worked field.
Zero Days Reason Code	The reason for the value 0 in the Days Worked field.	Valid values: A - Accrued pay/not terminated C - Less than 12 month pay schedule F - Final pay/terminated L - Leave without pay Calculated during the data load process. The calculated value represents a standardized reason code that explains why an employee has zero days worked during the reporting period, derived from employee termination status, pay schedule type, gross pay amounts, and attendance docking records. The field value is stored in the tx_team_pay.zero_days_code field.

Previously Reported to TEAM

The following table describes the fields in the Previously Reported to TEAM section of the Employee Time tab on the TX Team Report - Payroll (RP20/RP25) page when the Record Code selected in the General section is RP25.

Field	Description	Load logic - Data source and Valid values
Hours Worked	The previously reported actual number of hours worked.	The field value is retrieved from the tx_team_pay.actual_hours field of the previously submitted RP20/RP25 record.
Hours Scheduled	The previously reported number of hours the employee is scheduled to work in a week.	The field value is retrieved from the tx_team_pay.r_tx_team_pay.sched_hours field of the previously submitted RP20/RP25 record.
Days Worked	The previously reported actual number of days worked or on paid leave.	The field value is retrieved from the tx_team_pay.days_worked field of the previously submitted RP20/RP25 record.

Net Adjustment

The Net Adjustment section displays the difference between the Current Data and the Previously Reported to TEAM fields.

The following table describes the fields in the Net Adjustment section of the Employee Time tab on the TX Team Report - Payroll (RP20/RP25) page when the Record Code selected in the General section is RP25.

Field	Description	Load logic - Data source and Valid values
Hours Worked	The difference between the current and previously reported actual number of hours worked.	The valid value is the difference between the current and previously reported actual number of hours worked.
Hours Scheduled	The difference between the current and previously reported number of hours the employee is scheduled to work in a week.	The valid value is the difference between the current and previously reported number of hours the employee is scheduled to work in a week.
Days Worked	The difference between the current and previously reported actual number of days worked or on paid leave.	The valid value is the difference between the current and previously reported actual number of days worked or on paid leave.