Footer Record
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 |