DTL2 Record

DTL2 records are created for retirement wages. All payments from pay codes that are not exempt from retirement deductions are included in the retirement wage. If an employee has payments under several job classes or wage codes, as defined in the ORS class code table, separate DTL2 records are created.

The DTL2 record data is loaded into the miorsdtl2 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	Key link to the miorsdtl1 table (DTL1 record data).
Start date	beg_date	User input during the data load process. If the hire date falls after the start date, the hire date is used. If the amount is from a retroactive pay run, report the start date entered for the retroactive pay.
End date	end_date	User input during the data load process. If the term date falls before the end date, the term date is used. If the amount is from a retroactive pay run, report the end date entered for the retroactive pay.
Retirement hours	hours	Salaried employee: If the hours in the check history record are greater than zero, then the sum of the working hours in the check history record is included in the DTL2 record (apportioned by class). If the hours in the check history record are blank or zero, the hours from the corresponding pay rate record are included in the DTL2 record (apportioned by class). If the employee is a teacher (class code stored in the retclass table) and the check date is not within the date range stored in the retclass table for the specified class, then zero hours are reported with a wage code 08. Hourly employee: Sum of the working hours from the check history records. For pay method D: The time units from the check history records are multiplied by the full day/half day hours in the retirement pay code records.
Reported Wage code	wage_cd	If the employee has reported wages, then the wage code is reported as one of the following: 07 – the member is retired and has no contribution amount, or the payment is for third-party insured Weekly Workers Compensation. 08 – the member is a teacher and does not have service hours during the summer. 04 – the wages are from a retroactive pay run. 06 – the wages are negative, or the wages are from a voided check from a previous pay run. If a wage code exists in the class code table for the class being reported, then the wage code is reported as one of the following: 09 – If the payment is for longevity paid separately from regular wages. 11 – If the wages are for a coach. 15 – If the payment is a positive longevity adjustment. 16 – If the payment is a negative longevity adjustment. 21 – If the wages are for a terminated or retired employee that was earned while active but are being paid after termination (No longer used). 28 – If the wages are for summer spread for a retired employee (No longer used). Otherwise, the wage code is 01. Wage codes for the following adjustments are not loaded automatically and need to be manually maintained: 25 – positive coach wages 26 – negative coach wages 45 – positive retro-wages 46 – negative retro-wages 75 – positive wages without contributions (WWC or post-retirement) 76 – negative wages without contributions (WWC or post-retirement) 85 – positive summer spread wages 86 – negative summer spread wages
Reported Wage	gross	The retirement deduction gross from check history for each class or wage code.
Exception wages	excpt	Special Exempt from the Michigan Retirement page (ftext1). If the special exempt amount is blank, wages for classes 9001 and 9002 are reported. Otherwise, zero is reported. This amount is only for primary DTL2 records. Exception wages are zero-filled for secondary DTL2 records.
Member Contributions	contrib	Fraction contributed by the employee to the retirement deduction (reported wage or total retirement wage for all classes).
Employer Contributions	benefit	Fraction contributed by the employer to the retirement deduction (reported wage/total retirement wage for all classes).
Pay Rate	pay_rate	Primary DTL2 Records: For hourly/daily employees, the pay rate is the reportable wages/hours. If the hours are zero, the employee’s primary rate is loaded. For salaried employees, if the Salary Calculation Code from the Human Resources Profile - State page is 1, then the annual salary from the employee’s primary rate is loaded. If the Salary Calculation Code is 2, then a sum of all salaries for active contracts is loaded. Secondary DTL2 Records: Reportable wages/hours. If the hours are zero for a wage code required to report hours, the employee’s primary rate is loaded.
Employment Class code	class_cd	Primary DTL2 Records: Class (Acct) from the Michigan Retirement page. If the field is blank, the ORS class code linked to the employee’s primary job class is loaded. If the ORS class code of the job class does not exist in the ORS class table, the job class code is loaded. Secondary DTL2 Records: ORS class code from the ORS class table.
Contract begin date	cont_beg	The contract start date from the employee’s primary pay rate for the employee’s primary ORS class code. Otherwise, the contract start date for the secondary pay rate is used. This field is blank if the employee is not a contract employee.
Contract end date	cont_end	The contract end date from the employee’s primary pay rate for the employee’s primary ORS class code. Otherwise, the contract end date for the secondary pay rate is used. The field is blank if the employee is not a contract employee.
Pay group	group_x	The pay group from the employee’s primary pay rate.
Frequency of Pay	pay_freq	The number of pays per year from the employee’s primary pay rate.
Report period	rpt_prid	User input during the data load process.