Skip to main content

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