|
Footer file layout |
|||||
|
Field Name |
Format |
Length |
Position |
Required Field |
Explanation |
|
Section Identifier - FOOT |
X(4) |
4 |
1-4 |
Y |
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 |
Y |
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 |
Y |
Name of the RU. |
|
Total Records |
9(8) |
8 |
40-47 |
Y |
The total number of detail records. |
|
Total Retirement Hours |
9(10)v99 |
12 |
48-59 |
Y |
The total retirement hours from all DTL2 records. |
|
Total Reported Wages |
9(10)v99 |
12 |
60-71 |
Y |
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 |
N |
|
|
Total Exception Wages |
9(10)v99 |
12 |
84-95 |
Y |
The total exception wages from DTL2 records. |
|
Total Member Contributions |
9(10)v99 |
12 |
96-107 |
Y |
The total member contributions from all DTL2 records. |
|
Total Employer Contributions |
9(10)v99 |
12 |
108-119 |
Y |
The total employer contributions from all DTL2 records. |
|
Not Used - Report as all zeros "000" |
9(10)v99 |
12 |
120-131 |
N |
|
|
Total TDP Deductions |
9(10)v99 |
12 |
132-143 |
Y |
The total TDP deductions amount from all DTL3 records. |
|
Total Member DC Contributions |
9(10)v99 |
12 |
144-155 |
Y |
The total member DC contributions from all DTL4 records. |
|
Total Employer DC Contributions |
9(10)v99 |
12 |
156-167 |
Y |
The total employer DC contributions from all DTL4 records. |
|
Total Member PHF Contributions |
9(10)v99 |
12 |
168-179 |
Y |
The total member PHF contributions from all DTL4 records. |
|
Total Employer PHF Contributions |
9(10)v99 |
12 |
180-191 |
Y |
The total employer PHF contributions from all DTL4 records. |
|
Total Member DC Roth Contributions |
9(10)v99 |
12 |
192-203 |
Y |
The total member DC Roth contributions from all DTL4 records. |
|
Total Member PHF Roth Contributions |
9(10)v99 |
12 |
204-215 |
Y |
The total member PHF Roth contributions from all DTL4 records. |
|
Filler |
X(213) |
165 |
216-380 |
Optional |
|
Last updated on 9/19/2025
