The web Browser you are currently using is unsupported, and some features of this site may not work as intended. Please update to a modern browser such as Chrome, Firefox or Edge to experience all features Michigan.gov has to offer.
14.01.06: Footer file layout
| Field Name | Format | Length | Position | Required Field | Explanation |
| Section Identifier – FOOT | X(4) | 4 | 1 – 4 | Yes | This field is used to identify the type of section the record represents. For the footer section "FOOT" should be used. |
| Organization Code | 9(5) | 5 | 5 – 9 | Yes | The five-digit reporting unit (RU) number. The first four digits are the number assigned to the individual RU. These should be followed by a zero. |
| Organization Name | X(30) | 30 | 10 – 39 | Yes | Name of the RU. |
| Total Records | 9(8) | 8 | 40 – 47 | Yes | The total number of detail records. |
| Total Retirement Hours | 9(10)v99 | 12 | 48 – 59 | Yes | The total retirement hours from all DTL2 records. |
| Total Reported Wages | 9(10)v99 | 12 | 60 – 71 | Yes | The total employer reported wages from DTL2 records (not including DTL4 wages). |
| Not Used – Report as all zeros "000" | 9(10)v99 | 12 | 72 – 83 | No | N/A |
| Total Exception Wages | 9(10)v99 | 12 | 84 – 95 | Yes | The total exception wages from DTL2 records. |
| Total Member Contributions | 9(10)v99 | 12 | 96 – 107 | Yes | The total member contributions from all DTL2 records. |
| Total Employer Contributions | 9(10)v99 | 12 | 108 – 119 | Yes | The total employer contributions from all DTL2 records. |
| Not Used – Report as all zeros "000" | 9(10)v99 | 12 | 120 – 131 | No | N/A |
| Total TDP Deductions | 9(10)v99 | 12 | 132 – 143 | Yes | The total TDP deductions amount from all DTL3 records. |
| Total Member DC Contributions | 9(10)v99 | 12 | 144 – 155 | Yes | The total member DC contributions from all DTL4 records. |
| Total Employer DC Contributions | 9(10)v99 | 12 | 156 – 167 | Yes | The total employer DC contributions from all DTL4 records. |
| Total Member PHF Contributions | 9(10)v99 | 12 | 168 – 179 | Yes | The total member PHF contributions from all DTL4 records. |
| Total Employer PHF Contributions | 9(10)v99 | 12 | 180 – 191 | Yes | The total employer PHF contributions from all DTL4 records. |
| Total Member DC Roth Contributions | 9(10)v99 | 12 | 192 – 203 | Yes | The total member DC Roth contributions from all DTL4 records.
|
| Total Member PHF Roth Contributions | 9(10)v99 | 12 | 204 – 215 | Yes | The total member PHF Roth contributions from all DTL4 records. |
| Filler | X(213) | 165 | 216 – 380 | No | N/A |
Last updated on 9/19/2025