Skip to main content
Skip table of contents

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.