Charging Variance Report - File Layout and Data Mapping

The default file names for the Charging Variance report are:

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

The following table shows the columns, column names, descriptions, and data sources or valid values for the Charging Variance 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 tx_team_pay.empl_no field.
B	SOCIAL SECURITY	The employee's Social Security number or TRS member ID number.	Retrieved from the tx_team_pay.ssn field.
C	EMPLOYEE NAME	The employee’s name. The format is <last name>, <first name> <middle initial>.	Retrieved from the following fields: employee.l_name employee.f_name employee.m_name
D	CONTRIBUTION/SALARY TYPES	The specific pay or deduction code that identifies different types of compensation and contribution categories.	Retrieved from the detdist.code field.
E	TRS GROSS	The employee's regular TRS-eligible compensation.	Retrieved from the tx_team_pay.trs_gross field.
F	TOTAL GROSS	The employee's total gross compensation.	Retrieved from the tx_team_pay.total_gross field.
G	FEDERAL GROSS	The employee's paid compensation from federal funds or private grants.	Retrieved from the tx_team_pay.federal_gross field.
H	CHILD NUTRITION GROSS	The portion of the federal gross amount that applies to child nutrition.	Retrieved from the tx_team_pay.fed_cn_gross field.
I	ADJUST MONTH/YEAR	Original report month and year for this adjustment.	Retrieved from the following fields: tx_team_pay.adj_month tx_team_pay.adj_year
J	FEDERAL TRS-CARE	The amount of the employee's member contribution to TRS-Care.	Retrieved from the tx_team_pay.fed_care_cont field.
K	NON-OASDI CONTRIBUTION	The reporting entity's contribution for Non-OASDI (Old Age, Survivors, and Disability Insurance) member compensation.	Retrieved from the tx_team_pay.non_oasdi_cont field.
L	STAT MIN CONTRIBUTION	The state's contribution on compensation paid above the adjusted state minimum.	Retrieved from the tx_team_pay.stat_min_cont field.
M	FEDERAL CONTRIBUTION	The employee's member contribution amount.	Retrieved from the tx_team_pay.fed_contrib field.
N	PAY DATE	The date when the payroll payment was issued.	Retrieved from the detdist.pay_date field.
O	PAY OR DEDUCTION CODE	The specific code identifying the type of payment or deduction (e.g., salary, benefits, contributions).	Retrieved from the detdist.code field.
P	BUDGET UNIT OR PROJECT	The organizational unit or project code that identifies the funding source for the payment.	Retrieved from the detdist.orgn_proj field.
Q	PAY DISTRIBUTION ACCOUNT	The general ledger account code where the payment amount is distributed for accounting purposes.	Retrieved from the detdist.acct field.
R	CHECK NUMBER	The unique identifier for the payroll check or electronic payment.	Retrieved from the detdist.check_no field.
S	PAY RUN	The payroll processing run identifier that groups payments processed together.	Retrieved from the detdist.pay_run field.
T	DISTRIBUTION DOLLAR AMOUNT	The monetary amount of the payment or deduction being distributed.	Retrieved from the detdist.amount field.
U	MANUAL/VOID CHECK FLAG	Indicates whether the check was manually processed or voided.	Retrieved from the detdist.void_man field.
V	DISTRIBUTION TYPE	The classification of how the payment is distributed (redistributed, original, etc.).	Valid values: F = Fringe Benefits R = Fringe Benefits (Project) O = Gross Wages (Regular) P = Gross Wages (Project) D = Deductions/Taxes W = Workers' Compensation A = Texas Accrual Records Retrieved from the detdist.redist field.
W	STAT MIN FLAG	Indicates if the payment includes statutory minimum contributions required by TRS.	Valid values: Y N Retrieved from the detdist.classify field.
X	NON-OASDI FLAG	Indicates if the payment includes non-OASDI (non-Social Security) contributions.	Valid values: Y N Retrieved from the detdist.classify field.
Y	TRS ELIGIBLE FLAG	Indicates if the employee is eligible for TRS (Teacher Retirement System) benefits.	Valid values: Y N Retrieved from the detdist.classify field.
Z	FEDERAL FLAG	Indicates if the payment includes federal fund contributions.	Valid values: Y N Retrieved from the detdist.classify field.
AA	NEW MEMBER FLAG	Indicates if the employee is a new member of the retirement system.	Valid values: Y N Retrieved from the detdist.classify field.