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 |