DTL1 Record
The DTL1 record data is loaded into the miorsdtl1 table.
The following table lists the DTL1 record's field names, table fields, and the data source.
Field Name | Table field | Data source |
---|---|---|
Employee ID | empl_no | Employee Number field on the Employee Information page. |
SSN | ssn | Social Security field on the Employee Information page. |
Old SSN | o_ssn | If the SSN in the Social Security field on the Employee Information page is different from the most recently reported DTL1 record, then the SSN in the most recently reported DTL1 record is loaded. Otherwise, the field is left blank. |
Last Name | l_name | Last Name field on the Employee Information page. |
First Name | f_name | First Name field on the Employee Information page. |
Middle Name | m_name | Middle Name field on the Employee Information page. |
Name Change Flag | chg_flg | Valid values:
This field is no longer used. |
Status Code | sta_cd | Status Code from the Michigan Retirement page (ftext9). If Status Code is blank, then the following values are assigned:
Otherwise, the field is left blank. If the status code is 03, 11, 12, 13, or 15, the status date is only loaded if it falls after the report start date. This field is no longer used. |
Status Date | sta_date | Status Date from the Michigan Retirement page (ftext10). If Status Date is blank, but the status code is not blank, then the status date is set to:
This field is no longer used. |
Report Period | rpt_prid | User input during the data load process |
When the report is created, all other DTL1 information is retrieved from the employee, personnel, and state retirement records