The following table lists the field names, descriptions, positions, lengths, formats, and data sources or valid values for the Demographic report’s Detail (Type 02) 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 02. |
|
Social Security Number |
The employee's Social Security number. |
3-11 |
9 |
Numeric, no hyphens |
Retrieved from the Social Security field on the Member tab of the Employee Information form on the MN TRA Retirement Report - Demographic page. |
|
Employee ID |
The employee’s identification (ID) number. |
12-22 |
11 |
Right-justified |
Retrieved from the Employee Number field on the Teacher Retirement Association Payroll Data form of the MN TRA Retirement Report page. |
|
TRA Number |
The six-digit numeric identifier assigned to the member by TRA. |
23-28 |
6 |
Right-justified, zero-filled |
Retrieved from the TRA Number field on the Employment tab of the Employee Information form on the MN TRA Retirement Report - Demographic page. |
|
Position Code |
The employee's TRA position classification. |
29-30 |
2 |
Left-justified |
Retrieved from the Position field on the Teacher Retirement Association Payroll Data form of the MN TRA Retirement Report page. |
|
Earnings |
The total TRA-eligible earnings amount for the employee during the pay period (×100). |
31-39 |
9 |
Right-justified, signed |
Retrieved from the Eligible Salary field on the Teacher Retirement Association Payroll Data form of the MN TRA Retirement Report page. |
|
Member Contribution |
The total amount of employee retirement contributions deducted from the employee's pay for the reporting period (×100). |
40-47 |
8 |
Right-justified, signed |
Retrieved from the Member Contribution field on the Teacher Retirement Association Payroll Data form of the MN TRA Retirement Report page. |
|
Transaction Type |
Indicates whether the record is a regular payment or a correction. |
48-49 |
2 |
Left-justified |
Retrieved from the Transaction Type field on the Teacher Retirement Association Payroll Data form of the MN TRA Retirement Report page. |
|
Wage Code |
TRA pay type code |
50-56 |
7 |
Left-justified |
Retrieved from the TRA Pay Type field on the Teacher Retirement Association Payroll Data form of the MN TRA Retirement Report page. |
|
Fiscal Year |
2-digit fiscal year |
57-58 |
2 |
Left-justified |
Retrieved from the Fiscal Year field on the Teacher Retirement Association Payroll Data form of the MN TRA Retirement Report page. |
|
Start Date |
Pay period start date |
59-66 |
8 |
YYYYMMDD |
Retrieved from the Start Date field on the Teacher Retirement Association Payroll Data form of the MN TRA Retirement Report page. |
|
End Date |
Pay period end date |
67-74 |
8 |
YYYYMMDD |
Retrieved from the End Date field on the Teacher Retirement Association Payroll Data form of the MN TRA Retirement Report page. |
|
Check Date |
Payroll check date |
75-82 |
8 |
YYYYMMDD |
Retrieved from the Check Date field on the Teacher Retirement Association Payroll Data form of the MN TRA Retirement Report page. |
|
Employer Contribution |
Employer contribution amount (×100) |
83-90 |
8 |
Right-justified, signed |
Retrieved from the Employer Contribution field on the Teacher Retirement Association Payroll Data form of the MN TRA Retirement Report page. |
|
Filler |
Fill with spaces. |
91-276 |
186 |
spaces |
Not applicable |