The following table shows the field names, descriptions, positions, lengths, formats, data sources or valid values, and whether the field is required for the ORS-PSERS Retirement report’s footer record.
|
Field Name |
Description |
Position |
Length |
Format |
Data Source or Valid Values |
Required or Optional |
|---|---|---|---|---|---|---|
|
Section Identifier |
Identifies the type of section the record presents. |
1-4 |
4 |
X(4) |
The valid value is FOOT. |
Required |
|
Organization Code |
The five-digit organization number. The first four digits are the number assigned to the individual reporting unit. These should be followed by a zero except for Henry Ford Community College, which has a trailing 1. |
5-9 |
5 |
X(5) |
Retrieved from the TDP Reporting Unit Number field on the Human Resources Profile – State page. |
Required |
|
Organization Name |
The name of the reporting unit. |
10-39 |
30 |
X(30) |
Retrieved from the Client field on the Human Resources Profile page. |
Required |
|
Total Records |
The total number of detail records. |
40-47 |
8 |
9(8) |
The valid value is the count of detail records in the file. |
Required |
|
Total Retirement Hours |
The total retirement hours from all DTL2 records. |
48-59 |
12 |
9(10)v99 |
The valid value is the sum of the retirement hours from all DTL2 records. |
Required |
|
Total Reported Wages |
The total employee wages from all DTL2 records. |
60-71 |
12 |
9(10)v99 |
The valid value is the sum of the employee wages from all DTL2 records. |
Required |
|
Zero-Filled |
Fill with 12 zeros. |
72-83 |
12 |
9(10)v99 |
The valid value is 000000000000. |
Not required |
|
Total Exception Wages |
The total exception wages from all DTL2 records. |
84-95 |
12 |
9(10)v99 |
The valid value is the sum of the exception wages from all DTL2 records. |
Required |
|
Total Member Contributions |
The total member contributions from all DTL2 records. |
96-107 |
12 |
9(10)v99 |
The valid value is the sum of the member contributions from all DTL2 records. |
Required |
|
Total Employer Contributions |
The total employer contributions from all DTL2 records. |
108-119 |
12 |
9(10)v99 |
The valid value is the sum of the employer contributions from all DTL2 records. |
Required |
|
Zero-Filled |
Fill with 12 zeros. |
120-131 |
12 |
9(12) |
The valid value is 000000000000. |
Not required |
|
Total TDP Deductions |
The total TDP deductions from all DTL3 records. |
132-143 |
12 |
9(10)v99 |
The valid value is the sum of the TDP deductions from all DTL3 records. |
Required |
|
Total Member DC Contributions |
The total member DC contributions from all DTL4 records. |
144-155 |
12 |
9(10)v99 |
The valid value is the sum of the member DC contributions from all DTL4 records. |
Required |
|
Total Employer DC Contributions |
The total employer DC contributions from all DTL4 records. |
156-167 |
12 |
9(10)v99 |
The valid value is the sum of the employer DC contributions from all DTL4 records. |
Required |
|
Total Member PHF Contributions |
The total member PHF contributions from all DTL4 records. |
168-179 |
12 |
9(10)v99 |
The valid value is the sum of the member PHF contributions from all DTL4 records. |
Required |
|
Total Employer PHF Contributions |
The total employer PHF contributions from all DTL4 records. |
180-191 |
12 |
9(10)v99 |
The valid value is the sum of the employer PHF contributions from all DTL4 records. |
Required |
|
Total Member DC Roth Contributions |
The total member DC Roth contributions from all DTL4 records. |
192-203 |
12 |
9(10)v99 |
The valid value is the sum of the member DC Roth contributions from all DTL4 records. |
Required |
|
Total Member PHF Roth Contributions |
The total member PHF Roth contributions from all DTL4 records. |
204-215 |
12 |
9(10)v99 |
The valid value is the sum of the member PHF Roth contributions from all DTL4 records. |
Required |
|
Filler |
Fill with blanks. |
216-380 |
165 |
X(165) |
spaces |
Not applicable |