Detail 1 Record - Member Demographics
The following table lists the Detail 1 record field names, format, position, and description. Data is from the retirement work file unless indicated.
Field Name | Format | Position | Description |
---|---|---|---|
Section ID | X(4) | 1-4 | Always "DTL1" |
SSN | 9(9) | 5-13 | The member's current social security number. |
Old SSN | 9(9) | 14-22 | The member's previously reported social security number, if different from the current social security number in the SSN field. |
Last Name | X(30) | 23-52 | The member's last name. |
First Name | X(20) | 53-72 | The member's first name. |
Middle Name | X(20) | 73-92 | The member's middle name. |
Name Change Flag | X(1) | 93 | This field is no longer used. |
Address 1 | X(30) | 94-123 | The first line of the member's address. |
Address 2 | X(30) | 124-153 | The second line of the member's address. |
Address 3 | X(30) | 154-183 | The third line of the member's address. |
Blank | X(30) | 184-213 | This field is no longer used. |
City | X(28) | 214-241 | The city in which a member resides. |
State | X(2) | 242-243 | The state in which a member resides. |
Zip-1 | X(5) | 244-248 | The member's five-digit zip code. |
Zip-2 | X(4) | 249-252 | The member's four-digit postal code. |
Province | X(20) | 253-272 | The province in which a member resides (if the county code is not USA). |
Country Code | X(30) | 273-302 | The county code in which a member resides, if available. |
Postal Code | X(7) | 303-309 | The postal code of the member (if the county code is not USA). |
Status Code | X(2) | 310-311 | This field is no longer used. |
Status Date | 9(8) | 312-319 | This field is no longer used. |
Date of Birth | 9(8) | 320-327 | The member's birthday. |
Gender | X(1) | 328 | The member's gender |
Zero Filled | 9(7) | 329-335 | Always "0000000" |
Filler | X(45) | 336-380 | NA |