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

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

None.

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

None.

Filler

X(45)

45

336 – 380

N

None.