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:
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:
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:
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 |
