Skip to main content
Skip table of contents

Detail 1 Record - Member Demographics

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 DTL1 record.

Field Name

Description

Position

Length

Format

Data Source or Valid Values

Required for New Hires

Section Identifier

Identifies the type of section the record presents.

1-4

4

X(4)

The valid value is DTL1.

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

Old SSN

The employee's previous Social Security number. 

14-22

9

9(9)

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

Optional

Last Name

The employee's last name.

23-52

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.

53-72

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.

73-92

20

X(20)

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

Optional

Name Change Flag

Indicates whether the employee’s name changed.

This field is not required as of 12/15/2007.

93

1

X(1)

Vlaid values:

  • Y

  • N

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

Not Required

Address 1

The first line of the employee's address. 

94-123

30

X(30)

Retrieved from the Address field on the Employment tab of the Employee Information page.

Required

Address 2

The second line of the employee's address. 

124-153

30

X(30)

Retrieved from the Address field on the Employment tab of the Employee Information page.

Optional

Address 3

The third line of the employee's address. 

154-183

30

X(30)

Retrieved from the Address field on the Employment tab of the Employee Information page.

Optional

Filer

Fill with blanks.

184-213

30

X(30)

30 spaces

Required

City

The employee's city of residence. 

214-241

28

X(28)

Retrieved from the City field on the Employment tab of the Employee Information page.

Required

State

The employee's state of residence. 

242-243

2

X(2)

Retrieved from the State field on the Employment tab of the Employee Information page.

Required

Zip-1

The employee's zip code. 

244-248

5

X(5)

Retrieved from the Zip Code field on the Employment tab of the Employee Information page.

Required

Zip-2

The employee's zip code extension. 

249-252

4

X(4)

Retrieved from the Zip Code field on the Employment tab of the Employee Information page.

Optional

Province

The employee’s province, if the county code is not USA.

253-272

20

X(20)

Not applicable

Optional

Country Code

The employee's country of residence. 

273-302

30

X(30)

The valid value is USA.

Optional

Postal Code

The employee’s postal code, if the county code is not USA.

303-309

7

X(7)

Not applicable

Optional

Status Code

The Status code for the DTL1 record.

If the status date of the following status codes is before the Start Date on the MI ORS-PSERS Load page, these status codes are not reloaded and are only reported once:

  • Separation

  • New Hire

  • Rehire

  • Return from Leave

  • Off Workers Compensation

This field is not required as of 12/15/2007. The data will still be sent to the state; however, the state will ignore these codes.

310-311

2

X(2)

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

Not Required

Status Date

The date on which the member’s status code is effective.

This field is not required as of 12/15/2007. The data will still be sent to the state; however, the state will ignore these codes.

312-319

8

9(8)

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

Not Required

Date of Birth

The employee's date of birth. 

320-327

8

9(8)

Retrieved from the Birthdate field on the Employee Information page.

Required

Gender

The employee's gender. 

328

1

X(1)

Valid values:

  • F - Female

  • M - Male

Retrieved from the Sex at Birth field on the Employee Information page.

Required

Zero-Filled

Fill with seven zeros.

329-335

7

9(7)

The valid value is 0000000.

Required

Filler

Fill with blanks.

336-380

45

X(45)

spaces

Not applicable

JavaScript errors detected

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

If this problem persists, please contact our support.