Skip to main content
Skip table of contents

Detail 4 Record - DC Contributions

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 DTL4 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 DTL4.

Required

SSN

The employee's Social Security number. 

5-13

9

9(9)

Retrieved from the Social Security field on the Demographic tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Required

Last Name

The employee's last name.

14-43

30

X(30)

Retrieved from the Last Name field on the Demographic tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Required

First Name

The employee's first name.

44-63

20

X(20)

Retrieved from the First Name field on the Demographic tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Required

Middle Name

The employee’s middle name.

64-83

20

X(20)

Retrieved from the Middle Name field on the Demographic tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Optional

Begin Date

The beginning date of the reporting period (or the first day the member was paid for in the reporting period being submitted).

84-91

8

9(8)

Retrieved from the Start field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Required

End Date

The ending date of the reporting period (or the last day the member was paid for in the reporting period being submitted).

92-99

8

9(8)

Retrieved from the End field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Required

DC Record Type

The record type of the Detail 4 record being reported. 

100-101

2

9(2)

For a list of valid values, refer to 13.04: Detail 4 records - DC record type codes and status change reason codes.

Required

Gross Wage

The member's reportable wages paid during the reporting period.

102-110

9

9(7)v99

Retrieved from the Wages field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Required

Member DC Contributions

The dollar amount of the member's DC contributions.

111-119

9

9(9)v99

Retrieved from the Member Contribution field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Required

Member DC Percent (%)

The percentage of the member's wages allocated as DC contributions.

120-124

5

9(3)v99

Retrieved from the Member Percentage field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Required

Employer DC Contributions

The dollar amount of the employer's DC contributions.

125-133

9

9(7)v99

Retrieved from the Employer Contribution field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Required

Employer DC Match Percent (%)

The percentage of the employer match allocated to the member's DC contributions.

134-138

5

9(3)v99

Retrieved from the Employer Percentage field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Required

Status Change Date

The date of the status change.

Required if the member’s status has changed. If there is no status change, enter eight zeros.

139-146

8

9(8)

Retrieved from the Status Date field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Required

Status Change Reason Code

The transaction code for the status change.

Required if the member’s status has changed.

147-148

2

9(2)

For a list of valid values, refer to 13.04: Detail 4 records - DC record type codes and status change reason codes.

Required

Member PHF Contributions

The dollar amount of the member's DC PHF contributions.

149-157

9

9(7)v99

Retrieved from the Member PHF Contribution field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Required

Member PHF Percent (%)

The percentage of the member's wages allocated as DC PHF contributions.

158-162

5

9(3)v99

Retrieved from the Member PHF Percentage field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Required

Employer PHF Contributions

The dollar amount of the employer's match of the employee's DC PHF contributions.

163-171

9

9(7)v99

Retrieved from the Employer PHF Contribution field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Required

Employer PHF Match Percent (%)

The percentage of the employer's match of the employee's DC PHF contributions.

172-176

5

9(3)v99

Retrieved from the Employer PHF Percentage field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Required

Member DC Roth Contributions

The dollar amount of the member's DC Roth contributions.

177-185

9

9(7)v99

Retrieved from the Member DC Roth Contribution field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Required

Member DC Roth Percent (%)

The percentage of the member's wages allocated as DC Roth contributions.

186-190

5

9(3)v99

Retrieved from the Member DC Roth Percentage field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Required

Member PHF Roth Contributions

The dollar amount of the member's DC PHF Roth contributions.

191-199

9

9(7)v99

Retrieved from the Member PHF Roth Contribution field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Required

Member PHF Roth Percent (%)

The percentage of the member's wages allocated as DC PHF Roth contributions.

200-204

5

9(3)v99

Retrieved from the Member PHF Roth Percentage field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Required

Filler

Fill with blanks.

205-380

176

X(176)

spaces

Required

JavaScript errors detected

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

If this problem persists, please contact our support.