Skip to main content

14.01.02: Detail 1 - Member Demographics (DTL1) file layout

14.01.02: Detail 1 - Member Demographics (DTL1) file layout

Detail 1 File Layout

Field Name Format Length Position Mandatory For New Hires Explanation

Section Identifier - DTL1

X(4)

4

1-4

Y

This field is used to identify the type of section the record represents. For the Member Demographics section, DTL1 should be used.

SSN

9(9)

9

5-13

Y

The member's current social security number. This field will also be used to report a corrected SSN for a member whose SSN has changed.

Old SSN

9(9)

9

14-22

N

The member's previous SSN. When using this field, a new SSN must be reported in the SSN field.

Last Name

X(30)

30

23-52

Y

The member's last name.

First Name

X(20)

20

53-72

Y

The member's first name.

Middle Name

X(20)

20

73-92

N

The member's middle name or initial.

Name Change Indicator

X

1

93

Not required

The name change indicator is no longer required. This field can continue to be filled with a Y or an N. If you do not use a Y or an N, it must be filled with a space.

Address - 1

X(30)

30

94-123

Y

The first line of the member's mailing address.

Address - 2

X(30)

30

124-153

N

The second line of the member's mailing address.

Address - 3

X(30)

30

154-183

N

The third line of the member's mailing address.

Not Used - Report as 30 spaces

X(30)

30

184-213

N

 

City

X(28)

28

214-241

Y

The city in which the member lives.

State

X(2)

2

242-243

Y

The two-character abbreviation for the state in which the member lives.

Zip - 1

X(5)

5

244-248

Y

The 5-digit zip code of the member.

Zip - 2

X(4)

4

249-252

N

The 4-digit postal code of the member.

Province

X(20)

20

253-272

N

The province in which a member lives.

Note: This field is required if the country code is not "USA."

Country Code

X(30)

30

273-302

N

The country code, if available, in which the member lives. Possible values are available in section 13.06: Country Codes.

Postal Code

X(7)

7

303-309

N

The postal code for this member.

Note:This field is required if the country code is not "USA."

Status Code

X(2)

2

310-311

Not Required

Status codes are no longer required. This field can be filled with either numbers or zeros but cannot be left blank.

Status Date

9(8)

8

312-319

Not Required

The status date is no longer required. This field can be filled with either numbers or zeros but cannot be left blank.

Date of Birth

9(8)

8

320-327

Y

The member's date of birth. It should be formatted as MMDDYYYY.

Gender

X(1)

1

328

Y

The member's gender. M for male or F for female.

Not Used - Report as all zeros "0000000"

9(7)

7

329-335

N

 

Filler

X(45)

45

336-380

N

 


Last updated: 04/13/2012