Charging Report - File Layout and Data Mapping

The default file names for the Charging report are:

Excel: team_chargingrpt<XXXX_XXXXX>.xlsx
PDF: team_charging_<XXXXX>.pdf
RPT: team_charging.rpt

The following table shows the columns, column names, descriptions, and data sources or valid values for the Charging report’s Excel file format.

Column	Column Name	Description	Data Source or Valid Values
A	EMPLOYEE NUMBER	The employee’s identification (ID) number.	Retrieved from the Employee Number field in the General section of the TX TEAM Report - Regular Payroll (RP20/RP25) page.
B	SOCIAL SECURITY	The employee's Social Security number or TRS member ID number.	Retrieved from the Social Security/TRS ID field in the Current Data section of the Member tab of the TX TEAM Report - Regular Payroll (RP20/RP25) page.
C	EMPLOYEE NAME	The employee’s name. The format is <last name>, <first name> <middle initial>.	Retrieved from the Last Name, First Name, and Middle Name fields in the Current Data section of the Member tab of the TX TEAM Report - Regular Payroll (RP20/RP25) page.
D	TRS GROSS	The employee's regular TRS-eligible compensation.	Retrieved from the Eligible TRS Gross field in the Current Data section of the Employee Share tab of the TX TEAM Report - Regular Payroll (RP20/RP25) page.
E	ADJUSTED STAT MIN	The current adjusted state minimum compensation.	Retrieved from the Adjusted State Minimum Compensation field in the Current Data section of the Employer Share tab of the TX TEAM Report - Regular Payroll (RP20/RP25) page.
F	OVER STAT MIN	The Over Statutory Minimum represents the amount of TRS-eligible compensation that exceeds the adjusted state minimum compensation threshold.	The valid value is calculated from the Eligible TRS Gross field on the Employee Share tab of the TX TEAM Report - Regular Payroll (RP20/RP25) page, minus the Adjusted State Minimum Compensation field on the Employer Share tab of the TX TEAM Report - Regular Payroll (RP20/RP25) page.
G	STAT MIN CONTRIBUTION	The state's contribution on compensation paid above the adjusted state minimum.	Retrieved from the Statutory Minimum Contribution field in the Current Data section of the Employer Share tab of the TX TEAM Report - Regular Payroll (RP20/RP25) page.
H	TOTAL GROSS	The employee's total gross compensation.	Retrieved from the Total Gross field in the Current Data section of the Employee Share tab of the TX TEAM Report - Regular Payroll (RP20/RP25) page.
I	FEDERAL GROSS	The employee's paid compensation from federal funds or private grants.	Retrieved from the Federal Gross field in the Current Data section of the Employee Share tab of the TX TEAM Report - Regular Payroll (RP20/RP25) page.
J	FEDERAL TRS-CARE	The amount of the employee's member contribution to TRS-Care.	Retrieved from the Member TRS-Care Contribution field in the Current Data section of the Employee Share tab of the TX TEAM Report - Regular Payroll (RP20/RP25) page.
K	FEDERAL CONTRIBUTION	The employee's member contribution amount.	Retrieved from the Member Contribution field in the Current Data section of the Employee Share tab of the TX TEAM Report - Regular Payroll (RP20/RP25) page.
L	NON-OASDI CONTRIBUTION	The reporting entity's contribution for Non-OASDI (Old Age, Survivors, and Disability Insurance) member compensation.	Retrieved from the Non-OASDI Member Contribution field in the Current Data section of the Employer Share tab of the TX TEAM Report - Regular Payroll (RP20/RP25) page.
M	CHILD NUTRITION GROSS	The portion of the federal gross amount that applies to child nutrition.	Retrieved from the Child Nutrition Federal Gross field in the Current Data section of the Employer Share tab of the TX TEAM Report - Regular Payroll (RP20/RP25) page.
N	ADJUSTMENT MONTH/YEAR	Original report month and year for this adjustment.	Retrieved from the Original Report Month and Original Report Year fields in the Current Data section of the Member tab of the TX TEAM Report - Regular Payroll (RP20/RP25) page when the Record Code is RP25.