Maintain Payroll RP20 Or RP25 Records

Use the TX TEAM Report - Payroll (RP20/RP25) page to create payroll records for salary and contribution amounts that were not created during the TEAM load process.

The ED40 is the initial record for each employee and their TRS Position code based on their defined pay rate distributions. The ED45 is a correction record.

The system creates ED40 records for employees paid on time cards for class/pay codes without a defined pay rate. These records have start and end dates matching the beginning and ending dates for the month but are otherwise identical to regular ED40 records. This happens for substitute, part-time, and extra duty hours worked. These positions would last for the report month, and the hours are reported in the Actual Hours Upload.

Menu Path

From the Human Resources menu, select State. From the State menu, select TX TEAM Report. From the TEAM Record Maintenance menu, select Maintain Payroll RP20/RP25 Records.

Change Processing

The TEAM load process checks the most recent record and compares it to the current data. If a correction needs to be made to adjust time or dollar amounts from a previous month, you can create an RP25 record. Once the adjustment month and year are entered, the previously reported data will display. Enter the new correct values in the Current Data section. After the record has been updated, you will see the amounts in the Net Adjustment section. These amounts are reported to TRS.

Maintain Data

On the TX Team Report - Payroll (RP20/RP25) page, specify Search Criteria and click Search.
To add a record, click Add new. Refer to Field Descriptions, fill out the information and click Accept.
To edit, double-click the record. Update the information and click Accept.
To delete a record, select the record and click Delete.

Field Descriptions

After saving the record, you cannot update these fields.

Field	Description
Record Code	Code identifying the type of payroll record. Select: RP20 RP25
Report Month	Month for the report.
Report Year	Year for the report.
Employee Number	Number identifying the employee. Click Lookup to display the Employee Lookup page and select a valid employee number. To create a new record, the employee must have a valid position (ED40/ED45) record.
TRS Position Code	TRS position code for the employee. Select: 00 - Missing Position 01 - Professional/Administrative 02 - Teacher or Full-time Librarian 03 - Support Staff 04 - Bus Driver 05 - Full-time Nurse/Counselor 06 - Peace Officer 07 - Support Staff-Food Service Worker 09 - Summer School Pay

Member Tab

Except for Original Report Month and Original Report Year, you cannot update the fields on the Member tab.

Field	Description
Identification Code	Type of identification to be used for the report.
Social Security/TRS ID	The TRS member ID number.
Last Name	The employee's last name.
First Name	The employee's first name.
Middle Name	The employee's middle name.
Suffix	Suffix, if any, on the employee's name. Select: I II III IV V VI VII VIII IX X XI JR SR
Birth Date	The employee's date of birth.
Gender	The employee's gender.
Original Report Month	Original report month for this adjustment. This displays only for an RP25 record.
Original Report Year	Original report year for this adjustment. This displays only for an RP25 record.

Employee Time Tab

Current Data Section

You should only update fields in this section.

Field	Description
Hours Worked	The actual number of hours worked by the employee. Integer/3 If Actual Hours have been uploaded for this employee, the field will display that number.
Hours Scheduled	The number of hours the employee is scheduled to work in a week. Integer/2
Days Worked	The actual number of days worked by the employee. Includes paid leave. Integer/2
Zero Days Reason Code	If the Days Worked is zero, select a reason: A - Accrued pay/not terminated C - Less than 12 month pay schedule F - Final pay/terminated L - Leave without pay

Previously Reported to TEAM Section

If the record code selected is RP25, this section displays. The Net Adjustment section displays the difference between the Current Data and Previously Reported to TEAM fields.

Field	Description
Hours Worked	Previously reported actual number of hours worked.
Hours Scheduled	Previously reported number of hours the employee is scheduled to work in a week.
Days Worked	Previously reported actual number of days worked or on paid leave.

Employee Share Tab

If the record code selected is RP25, the Previously Reported to TEAM and Net Adjustment sections display the following fields. The Net Adjustment section displays the difference between the Current Data and Previously Reported to TEAM fields.

Field	Description
Eligible TRS Gross	The employee's regular TRS eligible compensation. Decimal/9,2
Performance Pay Gross	The amount for the employee's pay performance. Decimal/9,2
Total Gross	The employee's total gross compensation. Decimal/9,2
Member Contribution	The employee's member contribution amount. Decimal/9,2
Member TRS-Care Contribution	The amount of employee's member contribution to TRS-Care. Decimal/9,2
Federal Gross	The employee's paid compensation from federal funds or private grants. Decimal/9,2
Service Credit Purchase Deduction	The employee's purchasing credit deduction amount. Decimal/9,2
Service Credit Tax Shelter Flag	Flag indicating the type of payroll deduction for service credit. Does not display in the Net Adjustment section. Select: A - After tax B - Before tax

Employer Share Tab

If the record code selected is RP25, the Previously Reported to TEAM and Net Adjustment sections display the following fields. The Net Adjustment section displays the difference between the Current Data and Previously Reported to TEAM fields.

Field	Description
RE TRS-Care Contribution	The reporting entity's contribution to TRS-Care. Decimal/9,2
Federal Contribution	The state's contribution for compensation paid from federal funds or private grants. Decimal/9,2
Federal TRS-Care Contribution	The state's TRS-Care contribution for compensation paid from federal funds or private grants. Decimal/9,2
New Member Contribution	The state's new TRS member contribution for compensation paid during the first ninety days. Decimal/9,2
Non-OASDI Member Contribution	The reporting entity's contribution for Non-OASDI (Old Age, Survivors, and Disability Insurance) member compensation. Decimal/9,2
Adjusted State Minimum Compensation	The current adjusted state minimum compensation. Decimal/9,2
Statutory Minimum Contribution	The state's contribution on compensation paid above the adjusted state minimum. Decimal/9,2
Child Nutrition Federal Gross	The portion of the federal gross amount that applies to child nutrition. Decimal/9,2 Displayed only in the Current Data section. For an RP25 that affects child nutrition, this field should be the gross amount that represents the net adjustment of the Federal TRS Care and Federal contributions. Example: If a net adjustment for TRS Care = $1.25 and TRS Care % = 1.25%, the Child Nutrition gross would be $100. This is required for the charging process to determine how much of the Federal Contributions and gross will be attributed to Child Nutrition.

Salary Distribution Tab

This tab displays the detailed distribution salary records for the pay runs included in that month's loaded data. In addition, flags are displayed indicating the charging to be done for that amount. Only the Statutory Minimum, Non OASDI, TRS Eligible, Federal, and New Member flags may be charged. Also, if an RP20 is added for an employee excluded from the load, Salary Distribution records are created to charge their fringe amounts correctly.

Field	Description
Budget Code	Displays the budget code. Display only.
Account	Displays the account code. Display only.
Position	Displays the position code. Display only.
Pay Code	Displays the pay code. Display only.
Amount	Displays the amount for the salary distribution. Display only.
Statutory Minimum	Select if the salary is subject to the statutory minimum.
Non-OASDI	Select if the salary is not subject to OASDI taxing.
TRS Eligible	Select if the salary is TRS eligible. This will not affect the information on the ED40 or payroll process charges.
Federal Flag	Select if the salary is paid from a federal fund.
New Member	Select if the salary is subject to new member benefits. This will not affect the information on the ED40 or payroll process charges.
Redistributed	Displays if the salary was redistributed. Otherwise, it is blank. Display only.
Check Number	Displays the salary check number. Display only.
Pay Run	Displays the pay run code for the employee's salary. Display only.
Pay Group	Displays the pay group the employee is assigned to. Display only.
Date Changed	Displays the date that the salary distribution was changed. Display only.
Change Type	Displays the type of change that was made. Display only.