TRA Retirement Report - Maintain Data - TRA Payroll Data

Use the Teacher Retirement Association Payroll Data form of the MN TRA Retirement Report page to view, manage, and edit TRA contribution records. This form displays the payroll data that will be reported to the Teachers Retirement Association, including member contributions, employer contributions, salary information, and pay period details for each employee.

If errors are encountered during the Load data process, you can correct the source data on the Teacher Retirement Association Payroll Data form of the MN TRA Retirement Report page. After corrections, you must purge and reload the data.

PowerSchool recommends that you correct the report’s source data that is retrieved from the Core application.

On the MN TRA Retirement Report page, filter records using the filter criteria. To enter filter criteria:
1. Select an option in the first field.
2. Select or enter a value.
3. Select Add if the button is enabled.
  Refer to Search for records for more information.
  - To add a record, select Add Record. Refer to the Field descriptions and enter valid information in the required fields. Select Save, and then Yes.
  - To edit a record, select the ellipsis in the Actions column and then select Edit. Update the information and select Save.
  - To delete a record, select the ellipsis in the Actions column, select Delete, and then select Yes.

Field descriptions

The following table describes the fields on the Teacher Retirement Association Payroll Data form of the MN TRA Retirement Report page.

Field	Description	Load logic - Data source and Valid values
Employee Number	The employee’s identification (ID) number. Select the Lookup icon to search for and select an employee number. This field is view-only and cannot be updated after saving the record. To list terminated employees using the Employee Search Tool: Select Include Terminated Employees from the first drop-down list. Select True from the second drop-down list.	The field value is retrieved from the Employee Number field on the Employee Information page.
Name	The employee’s name. The format is last name, first name, middle initial. This field is view-only.	The value is retrieved from the Last Name, First Name, and Middle Name fields on the Employee Information page.
Social Security	The employee's social security number. This field is view-only.	The field value is retrieved from the Social Security field on the Employee Information page.
Check Date	The date the employee's paycheck was issued. This field is view-only and cannot be updated after saving the record.	Populated during the data load process from check history records for the pay runs processed within the specified date range. The field value is retrieved from the Check Date field on the Check History page.
Batch Number	A system-generated unique identifier for grouping TRA submissions. For more information, refer to TRA Retirement Report - Maintain Data - Batch Numbers.	Calculated during the data load process. The calculated value represents a unique submission identifier generated based on the employee's pay frequency. The system generates batch numbers using the format [Frequency Code][Sequential Number]: W = Weekly (Pay Frequency "01") B = Bi-Weekly (Pay Frequency "02") S = Semi-Monthly (Pay Frequency "03") M = Monthly (Pay Frequency "04") The sequential number is padded to 10 digits (e.g., W0000000001, M0000000005). During the load process, the system: Retrieves the maximum existing batch number for each pay frequency. Increments by 1 to create new batch numbers. Assigns the appropriate batch based on the employee's pay frequency from their payroll record. Selects the Supplement Pay option on the TRA Batch Number Data form of the MN TRA Retirement Report - Batch Numbers page if Supplemental was selected on the MN TRA Retirement Report - Load page.
Start Date	The beginning date of the pay period for which contributions are being reported.	Calculated during the data load process. The calculated value represents the beginning date of the pay period for which TRA contributions are being reported. The Start Date is determined through the following logic: If Includes Summer Pay is selected on the MN TRA Retirement Report - Load page, the contract start date from the employee's pay rate record (payrate.cont_start) is used. Otherwise, the system looks up the start date from the MN Pay Groups table (mn_paygroups) based on: The pay run code. The deduction gross group value from the check history. If no match is found, it uses the default pay group (#). Fallback: If no match is found, it performs a lookup based on the employee's pay rate classification and pay code.
End Date	The ending date of the pay period for which contributions are being reported.	Calculated during the data load process. The calculated value represents the pay period's ending date for which TRA contributions are being reported. The End Date follows the same logic as the Start Date: If Includes Summer Pay is selected on the MN TRA Retirement Report - Load page, the contract end date from the employee's pay rate record (payrate.cont_end) is used. Otherwise, the system looks up the end date from the MN Pay Groups table (mn_paygroups) using the same matching criteria as for the Start Date.
Fiscal Year	The fiscal year to which the contribution is attributed.	Calculated during the data load process. The calculated value represents the fiscal year to which the contribution should be attributed for TRA reporting. The Fiscal Year is derived by comparing the Start Date and End Date against the district's fiscal calendar: Retrieves the fiscal start date and the fiscal end date from the Fiscal Year Start and Fiscal Year End fields on the Fund Accounting Profile page. Determines which fiscal year the contribution period falls within. For summer pay spanning fiscal years, it uses the contract dates to determine the appropriate fiscal year. Creates separate records when contributions span multiple fiscal years.
Position	The employee's TRA position classification.	Valid values: 01 - Teacher 02 - Administrator Populated during the data load process. The field value is retrieved from the TRA Position field on the Payroll Information - State Required page.
Plan ID	The TRA retirement plan type assigned to the employee.	Valid values: 01 - Basic 02 - Coordinated Populated during the data load process. The field value is retrieved from the Deduction Plan field on the MN Retirement Deduction Information form of the MN Retirement Deductions page.
Transaction Type	Indicates whether the record is a regular payment or a correction.	Valid values: 01 - Pay Record 02 - Adjustment Calculated during the data load process. The calculated value represents whether the record is a regular payment or an adjustment/correction. The Transaction Type is determined based on the source of the check record: 01 - Pay Record = Normal paycheck from regular check history 02 - Adjustment = Voided check or adjustment record from void/adjustment tables
TRA Pay Type	The type of earnings/activity being reported.	Valid values: 01 - Regular Contracted Licensed Activity 02 - Extracurricular & Other Non-Licensed Work 03 - Substitute & Other Licensed Work 04 - Grievance Pay 05 - Retroactive & Q-Comp 06 - Employer-paid Employer Share on Unearned Salary 07 - Member-paid Employer Share on Unearned Salary Calculated during the data load process. The calculated value represents the type of earnings/activity for which the contribution is being reported to TRA. The TRA Pay Type is determined from the MN Pay Table (mn_paytable) based on the deduction code and earnings type. The system: Looks up the deduction code from the check history. Matches it to the MN Pay Table mapping. Assigns the corresponding pay type code. For unearned contribution types (06, 07A, 07B), it uses the configuration from the MN Retirement Deductions page.
Eligible Salary	The total TRA-eligible earnings amount for the employee during the pay period.	Calculated during the data load process by summing earnings amounts from the employee's Check History records.
Member Contribution	The total amount of employee retirement contributions deducted from the employee's pay for the reporting period.	Calculated during the data load process. The calculated value represents the total amount of employee retirement contributions deducted from the employee's pay. The Member Contribution is calculated by: Summing all deduction amounts (checkhi2.amt) for TRA deduction codes within the date range. Grouping by Plan ID, Pay Type, Adjustment Flag, and Pay Period dates. For adjustments (voided checks), the amount is negated: -checkhi2.amt. For unearned contribution types: 07A (Pre-Tax Member-paid): Uses the full deduction amount as member contribution. 07B (Post-Tax Member-paid): Uses the deduction amount as the employer contribution instead. 06 (Employer-paid): Uses the deduction amount as the member contribution.
Employer Contribution	The total employer matching contribution amount for TRA retirement.	Calculated during the data load process. The calculated value represents the total employer matching contribution amount for TRA retirement. The Employer Contribution is calculated by: Summing all fringe benefit amounts (checkhi2.fringe) for TRA deduction codes within the date range. Grouping by Plan ID, Pay Type, Adjustment Flag, and Pay Period dates. For adjustments (voided checks), the amount is negated: -checkhi2.fringe. For unearned contribution types: 07A (Pre-Tax Member-paid): Employer contribution is $0.00. 07B (Post-Tax Member-paid): Uses deduction amount as employer contribution. 06 (Employer-paid): Uses fringe amount as employer contribution.