7.01.08: Using the Download Detail link

The Download Detail link on your View Report Totals screen opens your submitted report in a spreadsheet format. Download detail files are available for 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 Work on Reports on the Things To Do menu. For an unposted report click the View Totals/Accept link under the View Totals column. For a posted report click the View Totals link in the View Totals column.
  2. The link for the Report Totals for Regular and Adjustments download detail is near the bottom of the View Report Totals screen. There are also download detail links for three other sections: Posted W&C (Wage and Contribution) Information, W&C Not Yet Posted, and Total Adjustments (Posted and Not Posted) which show only the data for that section. Click the Download Detail link for the section for which you require data.

 

Reading a Download Details file

A Download Details spreadsheet has columns for each of the fields on all four record types.

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 % - displays data for DTL2 records only. A 3 indicates the employee has the Premium Subsidy healthcare benefit and 3% of their reported wages will be applied to that fund. A 0 indicates that the employee has a different healthcare option, see column E.

E - Health Choice - displays 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 record (mmddyyyy).

G - Record End Date - the pay period end date on the DTL2 record (mmddyyyy).

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

I - Wage Code - wage code on DTL2 record. (See section 13.02.02: Detail 2 records - wage codes for specific codes.)

J - Class Code - class code used to report wages on the DTL2. (See section 13.02.01 Detail 2 records - employment class codes and definitions for specific codes.)

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

L - Employer Reported Wages (Retirees) - dollar amount of wages reported on the DTL2 record 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 section 7.03.06: Reporting professional services leave/professional services released time on a DTL2 record 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: