Skip to main content
Skip table of contents

Detail 4 Record - DC Contributions

The following table lists the Detail 4 record field names, format, position, and description. 

Field Name

Format

Position

Description

Section ID

X(4)

1-4

Always set to "DTL4."

SSN

9(9)

5-13

The member’s social security number.

Last Name

X(30)

14-43

The member’s last name.

First Name

X(20)

44-63

The member’s first name.

Middle Name

X(20)

64-83

The member’s middle name.

Begin Date

9(8)

84-91

The first day the member worked in the pay period being submitted.

End Date

9(8)

92-99

The last day the member worked in the pay period being submitted.

DC Record Type

9(2)

100-101

The record type of the Detail 4 record being reported. 

Valid values:

  • 01 – Regular wage

  • 05 – Positive adjustment

  • 06 – Negative adjustment

Gross Wage

9(7)v99

102-110

The member’s gross wages.

Member DC Contributions

9(9)v99

111-119

The member’s DC contribution amount (in dollars).

Member DC Percent (%)

9(3)v99

120-124

Percentage of member’s wages allocated as DC contributions.

Employer DC Contributions

9(7)v99

125-133

Employer’s DC contribution amount (in dollars).

Employer DC Match Percent (%)

9(3)v99

134-138

Percentage of the employer match allocated to member’s DC contributions.

Status Change Date

9(8)

139-146

Date of status change.

Must be populated if member status changes. If there is no status change, enter eight zeros.

Status Change Reason Code

9(2)

147-148

Transaction code for the status change.

Must be populated if the member status changes.

Valid values:

  • 01 – Retired

  • 02 – Terminated/Separated

  • 03 – Disability Retirement

  • 04 – Death

  • 05 – Laid off

  • 06 – Leave of absence

Filler

X(232)

149-380

NA

JavaScript errors detected

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

If this problem persists, please contact our support.