7.04.05: Using the Download Detail Link

The Download Detail link on your View Report Totals screen opens your submitted retirement detail report in a spreadsheet format. It can be viewed from both posted and unposted payroll reports. This tool helps to find discrepancies in Defined Benefit (DB and Defined Contribution (DC)) member and employer contribution amounts, which allows you to reconcile your records.

Note: The totals on a 100% posted report can never be changed.

1. Click on the Work on Reports link from the left navigation bar.
 

Screenshot of the Employer Website highlighting the Work on Reports link

2.

For an unposted report click on the View Totals/Accept link under the View Totals column. For a posted report click on the View Totals link in the View Totals column.

 

Screenshot of the Work on Retirement Details Report screen with the Edit column hi

3.

There are download detail links for each of four sections on the View Report Totals page. The download detail will display only data based on the section title: Posted W&C (Wage and Contribution) Information, W&C Not Yet Posted, Total Adjustments (Posted and Not Posted), and Report Totals for Regular and Adjustments. Click on the Download Detail link for the section for which you require data to open the spreadsheet.

 

Screenshot of the View Report Totals screen, highlighting the Download Detail link

4.

The spreadsheet has columns for each of the fields on the DTL2 and DTL4 records submitted.

Columns A through E:

A – SSN

B – Name

C – Benefit Plan – lists the member retirement benefit plan or displays Retiree if the employee has retired from MPSERS and is returned to work. (See chapter 6: Member Benefit Plans and Contributions for specific plan information)

D – Healthcare Contribution % – this is displayed for DTL2 records only. 3 indicates the employee has the Premium Subsidy health care, 3% of their reported wages will be applied to that fund. 0 indicates that the employee has a different healthcare option, see column E.

E – Health Choice – this is displayed for DTL2 records only. The field is blank for those who have Premium Subsidy (see column D), the field shows PHF if the employee has the Personal Healthcare Fund.

 

Columns F through M:

F – Record Begin Date – the pay period begin date on the DTL2.

G – Record End Date – the pay period end date on the DTL2.

H – Section Code – indicated the record type – DTL1-Demographics, DTL2-Wage and Service, DTL3-TDP Deductions, DTL4-DC Contributions.

I – Wage Code – wage code on DTL2 record. (See chapter 13.03: Detail 2 Wage Codes for specific codes.)

J – Class Code – class code used to report wages on the DTL2. (See chapter 13.03: Detail 2 Wage Codes for specific codes.)

K – Employer Reported Wages – dollar amount of wages reported on the DTL2 for employees reported with an active class code.

L – Employer Reported Wages (Retirees) – dollar amount of wages reported on the DTL2 for employees reported with a retiree class code.

M – Exception Wages – wages as they appear in the Exception Wages field on the DTL2. Exception wages are reported only for Professional Services Leave or Released Time and with class code 9001. (See chapter 7.17.01: How to Report Professional Services Leave/Professional Services Released Time for more information.)

 

Columns N through Q:

N – Member Contributions Reported – DB contribution dollar amount reported on the DTL2 record.

O – Member Contributions Calculated – DB contribution dollar amount calculated by ORS.

P – Member Contribution Discrepancy – Dollar amount difference between contributions reported and contributions calculated by ORS.

Q – Member UAAL Contribution – For future use, per Public Act (PA) 92 of 2017, as the need arises.

 

Columns R-V:

R – Employer Contributions Reported – DB contribution dollar amount reported on the DTL2 record.

S – Employer Contributions Calculated – DB contribution dollar amount calculated by ORS.

T – Employer Contributions Discrepancy – the difference between the reported and calculated employer DB contribution.

U – Hours – number of service hours reported on the DTL2 record.

V – Pay Rate – pay rate reported on the DTL2 record.

 

Columns W-Z:

W – Agreement # – Tax-Deferred Payment (TDP) Agreement number.

X – Invoice # – Tax-Deferred Payment (TDP) Agreement invoice number.

Y – TDP Period End Date – Effective pay period end date of TDP payment on the DTL3 record.

Z – TDP Deduction Amount – dollar amount of employee TDP payment on the DTL3 record.

 

Columns AA-AG:

AA – DC Record Type – DTL4 record type: 1-Regular, 5-Positive Adjustment, 6-Negative Adjustment

AB – Gross Wages – amount of wages reported on the DTL4 record.

AC –  Reported Member DC Contributions – dollar amount of member DC contributions reported on the DTL4 record.

AD –  Calculated Member DC Contributions – dollar amount of member DC contributions calculated by ORS.

AE –  Member DC Contribution Discrepancy – the difference between the member DC contributions reported and calculated.

AF –  Reported Member DC % – percentage of member DC contributions reported on the DTL4 record.

AG –  Calculated Member DC % – percentage of member DC contributions calculated by ORS.

 

Columns AH-AL:

AH –  Reported Employer DC Contributions – dollar amount of employer DC mandatory/DC match contributions reported on the DTL4 record.

AI –  Calculated Employer DC Contributions – dollar amount of employer DC contributions calculated by ORS.

AJ –  Employer DC Contribution Discrepancy –  the difference between the employer DC contributions reported and calculated.

AK –  Reported Employer DC Match % –  percentage of employer DC contributions reported on the DTL4 record.

AL –  Calculated Employer DC Match %  –  percentage of employer DC contributions calculated by ORS.

 

Columns AM-AN:

AM –  Status Change Date – for use only if employee is terminating service with the employer. (Must also populate Status Change Reason Code field. DTL4 will suspend if only one of the two fields are populated.)

AN –  Status Change Reason Code – for use only if employee is terminating service with employer. (Must also populate Status Change Date field. DTL4 will suspend if only one of the two fields are populated.)

 

Columns AO-AS:

AO –  Reported Member PHF Contributions –  dollar amount of member PHF contributions reported on the DTL4 record.

AP –  Calculated Member PHF Contributions –  dollar amount of member PHF contributions calculated by ORS.

AQ –  Member PHF Contribution Discrepancy –  the difference between the member PHF contributions reported and calculated.

AR –  Reported Member PHF % –  percentage of member PHF contributions reported on the DTL4 record.

AS –  Calculated Member PHF % –  percentage of member PHF contributions calculated by ORS.

 

Columns AT-AX:

AT –  Reported Employer PHF Contributions –  dollar amount of employer PHF contributions reported on the DTL4 record.

AU –  Calculated Employer PHF Contributions –  dollar amount of employer PHF contributions calculated by ORS

AV –  Employer PHF Contribution Discrepancy –  the difference between the employer PHF contributions reported and calculated.

AW –  Reported Employer PHF % –  percentage of employer PHF contributions reported on the DTL4 record.

AX –  Calculated Employer PHF % –  percentage of member PHF contributions calculated by ORS.

 

Columns AY-AZ:

AY –  Transfer Status – If the DTL4 record has been transferred to Third Party Administer (TPA) the column will display Transferred. If the DTL4 record has not been transferred to TPA the column will display Not Transferred.

AZ –  IRS Limit Reach – If the employee has reached the calendar year contribution limit at TPA the column will display Yes. If the employee has not reached the calendar year contribution limit at TPA it will display No.

 

Last updated: 06/19/2019