Footer Record
The following table lists the footer record field names, format, position, and description.
Field Name | Format | Position | Description |
|---|---|---|---|
Section ID | X(4) | 1-4 | Always set to “FOOT.” |
Organization Code | X(5) | 5-9 | Five-digit field consisting of the defined reporting unit number. The first four digits are the number assigned to the individual reporting unit followed by a zero except for Henry Ford Community College, which has a trailing 1. |
Organization Name | X(30) | 10-39 | The name of the reporting unit. |
Total Records | 9(8) | 40-47 | The total number of records. |
Total Retirement Hours | 9(10)v99 | 48-59 | The total retirement hours from all DTL2 records. |
Total Reported Wages | 9(10)v99 | 60-71 | The total employee wages from all DTL2 records. |
Zero Filled | 9(10)v99 | 72-83 | Always set to “0000000000.” |
Total Exception Wages | 9(10)v99 | 84-95 | The total exception wages from all DTL2 records. |
Total Member Contributions | 9(10)v99 | 96-107 | The total member contributions from all DTL2 records. |
Total Employer Contributions | 9(10)v99 | 108-119 | The total employer contributions from all DTL2 records. |
Zero Filled | 9(12) | 120-131 | Always set to “000000000000.” |
Total TDP Deductions | 9(10)v99 | 132-143 | The total TDP deductions from all DTL3 records. |
Total Member DC Contributions | 9(10)v99 | 144-155 | The total member DC contributions from all DTL4 records. |
Total Employer DC Contributions | 9(10)v99 | 156-167 | The total employer DC contributions from all DTL4 records. |
Filler | X(237) | 168-380 | NA |