Maintain Payroll RP20 Or RP25 Records - Employee Share tab
The Employee Share 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 Share tab on 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 |
|---|---|---|
Eligible TRS Gross | The employee's current regular TRS-eligible compensation. | Calculated during the data load process. The calculated value represents the sum of all TRS-eligible compensation amounts from the salary distribution for the employee and position for the reporting month/year, excluding performance pay and amounts exempt from retirement contributions. The field value is stored in the tx_team_pay.trs_gross field. |
Performance Pay Gross | The current amount for the employee's pay performance. | Calculated during the data load process. The calculated value represents the sum of all performance pay amounts from the salary distribution for the employee and position for the reporting month/year, identified by specific pay codes designated as performance pay. The field value is stored in the tx_team_pay.perf_pay_gross field. |
Total Gross | The employee's current total gross compensation. | Calculated during the data load process. The calculated value represents the sum of all gross compensation amounts from the salary distribution for the employee and position for the reporting month/year, including both regular TRS-eligible compensation and performance pay. The field value is stored in the tx_team_pay.total_gross field. |
Member Contribution | The employee's current member contribution amount. | The field value is retrieved from deduction codes configured with type "10 - Retirement Deduction" or type "42 - Performance Pay Deduction" on the TX TEAM Report - Deduction Code Crosswalk page. The amounts are summed from employee deductions in the check history. The field value is stored in the tx_team_pay.memb_cont field. |
Member TRS-Care Contribution | The current amount of the employee's TRS-Care member contribution. | The field value is retrieved from deduction codes configured with type "12 - Insurance Deduction" or type "43 - Care Performance Deduction" on the TX TEAM Report - Deduction Code Crosswalk page. The amounts are summed from employee deductions in the check history. The field value is stored in the tx_team_pay.memb_care_cont field. |
Federal Gross | The employee's current paid compensation from federal funds or private grants. | Calculated during the data load process. The calculated value represents the sum of all compensation amounts paid from federal funds or private grants, as reflected in the salary distribution for the employee and position for the reporting month/year, identified by specific budget or account codes designated as federal funding sources. The field value is stored in the tx_team_pay.federal_gross field. |
Service Credit Purchase Deduction | The employee's current purchasing credit deduction amount. | The field value is retrieved from deduction codes configured with type "19 - Service Credit Purchase Deduction" on the TX TEAM Report - Deduction Code Crosswalk page. The amounts are summed from employee deductions in the check history. The field value is stored in the tx_team_pay.serv_cred_pur field. |
Service Credit Tax Shelter Flag | Indicates the current type of payroll deduction for service credit. | Valid values:
Calculated during the data load process. This field is automatically set to "A" (After tax) when the Service Credit Purchase Deduction amount is greater than 0. The field value is stored in the tx_team_pay.serv_cred_flg field. |
Previously Reported to TEAM
The following table describes the fields in the Previously Reported to TEAM section of the Employee Share 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 |
|---|---|---|
Eligible TRS Gross | The employee's previously reported regular TRS-eligible compensation. | The field value is retrieved from the tx_team_pay.orig_trs_gross field of the previously submitted RP20/RP25 record. |
Performance Pay Gross | The previously reported amount for the employee's pay performance. | The field value is retrieved from the tx_team_pay.orig_perf_pay_gross field of the previously submitted RP20/RP25 record. |
Total Gross | The employee's previously reported total gross compensation. | The field value is retrieved from the tx_team_pay.orig_total_gross field of the previously submitted RP20/RP25 record. |
Member Contribution | The employee's previously reported member contribution amount. | The field value is retrieved from the tx_team_pay.orig_memb_cont field of the previously submitted RP20/RP25 record. |
Member TRS-Care Contribution | The previously reported amount of the employee's TRS-Care member contribution. | The field value is retrieved from the tx_team_pay.orig_memb_care_cont field of the previously submitted RP20/RP25 record. |
Federal Gross | The employee's previously reported paid compensation from federal funds or private grants. | The field value is retrieved from the tx_team_pay.orig_federal_gross field of the previously submitted RP20/RP25 record. |
Service Credit Purchase Deduction | The employee's previously reported purchasing credit deduction amount. | The field value is retrieved from the tx_team_pay.orig_serv_cred_pur field of the previously submitted RP20/RP25 record. |
Service Credit Tax Shelter Flag | Indicates the previously reported type of payroll deduction for service credit. This field does not display in the Net Adjustment section. | Valid values:
The field value is retrieved from the tx_team_pay.orig_serv_cred_flg 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 Share 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 |
|---|---|---|
Eligible TRS Gross | The difference between the employee’s current and previously reported regular TRS-eligible compensation. | The valid value is the difference between the employee’s current and previously reported regular TRS-eligible compensation. |
Performance Pay Gross | The difference between the current and previously reported amount for the employee's pay performance. | The valid value is the difference between the current and previously reported amount for the employee's pay performance. |
Total Gross | The difference between the employee’s current and previously reported total gross compensation. | The valid value is the difference between the employee’s current and previously reported total gross compensation. |
Member Contribution | The difference between the employee’s current and previously reported member contribution amount. | The valid value is the difference between the current and previously reported employee's member contribution amount. |
Member TRS-Care Contribution | The difference between the employee’s current and previously reported TRS-Care member contribution amounts. | The valid value is the difference between the employee’s current and previously reported amount of the member contribution to TRS-Care. |
Federal Gross | The difference between the employee’s current and previously reported paid compensation from federal funds or private grants. | The valid value is the difference between the employee’s current and previously reported paid compensation from federal funds or private grants. |
Service Credit Purchase Deduction | The difference between the employee’s current and previously reported purchasing credit deduction amount. | The valid value is the difference between the employee’s current and previously reported purchasing credit deduction amount. |