The following table lists the field names, descriptions, positions, lengths, formats, and data sources or valid values for the Demographic report’s Header (Type 01) record.
|
Field Name |
Description |
Position |
Length |
Format |
Data Source or Valid Values |
|---|---|---|---|---|---|
|
Record Type |
Identifies the type of record. |
1-2 |
2 |
Left-justified |
The valid value is 01. |
|
Employer Unit Number |
Identification number assigned to the employer by the Teachers Retirement Association (TRA). |
3-10 |
8 |
Right-justified, zero-filled |
Retrieved from the TRA Employer Number field on the Human Resources Profile - State page. |
|
Batch Number |
The unique batch identifier. |
11-21 |
11 |
Left-justified |
Retrieved from the Batch Number field on the MN TRA Retirement Report - Batch Numbers page. |
|
Pay Frequency |
The code specifying how often the employee receives pay. |
22-23 |
2 |
Left-justified |
Valid values:
Retrieved from the Pay Frequency field on the MN TRA Retirement Report - Batch Numbers page. |
|
Filler |
Fill with one space. |
24 |
1 |
space |
Not applicable |
|
Check Date |
The ending date up to which checks are included in the report. |
25-32 |
8 |
YYYYMMDD |
Retrieved from the Current Check Date field on the MN TRA Retirement Report - Load page. |
|
Supplemental Pay |
Indicates whether the load is for supplemental/extra pay (such as bonuses or additional compensation). |
33 |
1 |
Left-justified |
Valid values:
Retrieved from the Supplemental field on the MN TRA Retirement Report - Load page. |
|
Batch Date/Time |
Batch creation date and time. |
34-45 |
12 |
MMDDYYYYHHmm |
System-generated timestamp when the batch was created during the Load process. |
|
Coordinated Salary |
The total coordinated plan salary (×100). |
46-57 |
12 |
Right-justified, signed |
The valid value is the sum of all Salary amounts from detail records where the Plan ID field value is 02 - Coordinated on the Teacher Retirement Association Payroll Data form of the MN TRA Retirement Report page. |
|
Coordinated Member Deduction |
The total coordinated member contributions (×100). |
58-67 |
10 |
Right-justified, signed |
The valid value is the sum of all Member Contribution amounts from detail records where the Plan ID field value is 02 - Coordinated on the Teacher Retirement Association Payroll Data form of the MN TRA Retirement Report page. |
|
Coordinated Employer Deduction |
The total coordinated employer contributions (×100). |
68-77 |
10 |
Right-justified, signed |
The valid value is the sum of all Employer Contribution amounts from detail records where the Plan ID field value is 02 - Coordinated on the Teacher Retirement Association Payroll Data form of the MN TRA Retirement Report page. |
|
Basic Salary |
The total basic plan salary (×100). |
78-89 |
12 |
Right-justified, signed |
The valid value is the sum of all Salary amounts from detail records where the Plan ID field value is 01 - Basic on the Teacher Retirement Association Payroll Data form of the MN TRA Retirement Report page. |
|
Basic Member Deduction |
The total basic member contributions (×100). |
90-99 |
10 |
Right-justified, signed |
The valid value is the sum of all Member Contribution amounts from detail records where the Plan ID field value is 01 - Basic on the Teacher Retirement Association Payroll Data form of the MN TRA Retirement Report page. |
|
Basic Employer Deduction |
The total basic employer contributions (×100). |
100-109 |
10 |
Right-justified, signed |
The valid value is the sum of all Employer Contribution amounts from detail records where the Plan ID field value is 01 - Basic on the Teacher Retirement Association Payroll Data form of the MN TRA Retirement Report page. |
|
Record Count |
The total number of records in the file (including the header). |
110-115 |
6 |
Right-justified, zero-filled |
The valid value is the count of all detail records in the batch plus 1 (for the header record itself). |
|
Filler |
Fill with spaces. |
116-276 |
161 |
spaces |
Not applicable |