CHRS Knowledge Base

Run Master Payroll Certification (MPC) Reports

Updated on

Overview

This job aid shows payroll personnel how to run Master Payroll Certification (MPC) reports.

Background

The State Controller’s Office (SCO) requires attendance verification. Payroll must run the MPC reports to correct discrepancies in employee information between PeopleSoft and the SCO.

MPC Process

Flow Diagram of the MPC Report Process:Start with MPC Initial Run Open.Decide whether the data are good or bad.If the data are bad, run MPC initial run cancel, then correct the data, then repeat MPC Initial run open.If the data are good, move on to MPC Initial run closed, then complete MPC Final Run open.Run the Reconciliation report between CIRS data and MPC Final Run Open report data.Review the Reconciliation report. Decide if corrections are needed.If corrections are needed, go to MPC Final Run Cancel, then correct the data, then repeat MPC Final Run Open.If no corrections are needed, go to MPC Final Run Closed.End.

Run the MPC Process

Back to top

The MPC Process loads data into the MPC Report.

Step 1: Navigate to CSU Run MPC Process.

  • Menu > Time and Labor > CSU Time & Labor > CSU Run MPC Process.
Navbar button

Step 2: Search for and select a Run Control ID.

  • If you have no Run Control ID, open the Add a New Value tab to create one.
Run control ID search

Step 3: Configure the MPC Run Parameters:

  1. Enter your Business Unit.
  2. Enter the Pay Run ID.  Optional: enter ACD Run ID.
  3. Select a Run Type.

Guidelines

  • ACD Run ID: If this field is populated, results for any ACD employees must use the date range described by this calendar. If this is not populated, all results must use the MST calendar.
CSU Run MPC Process page, showing the MPC run parameters.

Run Types:

  • Initial Run Open: Opens the initial run for the above pay calendar.
  • Initial Run Closed: Closes the initial run for the above pay calendar and finalizes the report data to the MPC tables.
  • Initial Run Cancel: Clears all MPC tables of initial run data for the defined periods.
  • Final Run Open: Opens the final run for the above pay calendar. Final Run Open is only available after Initial Run is closed.
  • Final Run Closed: Closes the final run for the above pay calendar and finalizes the report data to the MPC tables.
  • Final Run Cancel: Clears all MPC tables of final run data for the defined periods.

Step 4: Click Run.

  • The Process Scheduler Request opens.
Run button

Step 5: On the Process Scheduler Request:

  1. Select the active server (PSUNX).
  2. Select the process to run if it is not selected already.
  3. Click OK.
Process Scheduler Request

Step 6: Wait for the process to complete.

If you have access to the Process Monitor, you can refresh the page until the Distribution Status is Posted.

Process monitor link
Refresh button. Distribution status posted.

Review the MPC Report

Back to top

After you run the MPC report process, you can view or download the MPC report. The report is not available from the Report Manager link when you run the report: you must go to a separate page to review MPC Reports.

Step 1: Navigate to CSU MPC Report.

  • Menu > Time and Labor > CSU Time & Labor > CSU MPC Report.
Navbar button

Step 2: Enter criteria to search for the report.

  • Business Unit
  • Pay Run ID
  • ACD Run ID
  • Pay Begin Date
  • Pay End Date
  • Initial Run Open
  • Initial Run Closed
  • Final Run Open
  • Final Run Closed
  • Pay Period Begin Date
  • Pay Period End Date

IMPORTANT: Select the RUN check box (indicated by the arrow) that corresponds to the run type that you are searching.

CSU TL MPC Report search page. An arrow points to the Initial Run Open check box.

Step 3: Click Search.

  • The search returns MPC Detail Data.
Search button

Step 4: Select a report to view.

Report links

Step 5: Review the data.

  • Review the hours and days worked as needed.
  • Confirm that either the NLT or Absence Submitted column is Y. If both are N, (as in this example), the row shows an error.
  • IMPORTANT: Errors must be corrected before the final run.
  • Optional: Click Comp Link to open the Job Data for that employee.
Report data columns:Last nameFirst nameEmpl IDEmpl RecordJob data Effective dateActionReason code
Report data columns:UnitDept IDJob CodeJob DescriptionFTE FractionStandard PayDays WorkedHours worked
Report data columnsNLT SubmittedAbsence TakenWarrant CountComp link

Step 6 Optional: Filter the data:

  1. Enter filter values.
    • Dept ID
    • Unit
    • Job Code
    • Empl ID
  2. Click Filter.
  • Use filters to focus and reduce the total number of rows to process.
A: Filter optionsB: Filter button

Step 7 Optional: Download the report as an Excel file.

  1. Click the Grid icon
  2. Select Download MPC Detail Data Table to Excel.

Guidelines

  • In Excel format, you can filter the list as needed for your review requirements.
  • IMPORTANT: This file includes personal information. Never send this file through email.
Grid icon and Download to Excel link

Step 8: Determine your next step.

  • If the report shows no errors:
    1. Run MPC Initial Run Closed.
    2. Proceed to MPC Final Run Open.
    3. Run the Reconciliation Report.
  • If the information shows errors:
    1. Run MPC Initial Run Cancel.
    2. Correct the errors.
    3. Run MPC Initial Run Open.
    4. Review the MPC Report.

Run the Reconciliation report

Back to top

This report compares the export from Campus Information Retrieval System (CIRS) to data from the Final Open run of the MPC report.

Step 1: Navigate to CSU Run Reconciliation Report.

  • Menu > Time and Labor > CSU Time and Labor > CSU Run Reconciliation Report.
Navbar button

Step 2: Search for and select a Run Control ID.

  • If you have no Run Control ID, open the Add a New Value tab to create one.
CSU Run Recon Report search page

Step 3: Set the run parameters:

  1. Select the Pay Run ID.
  2. Select the Business Unit.
  3. Optional: Select Differences only.

Guidelines

  • The Pay Run ID must match the pay run of the most recent MPC Final Run Open.
  • Differences only: This option causes the report to return only rows where there is a difference between CIRS data and PeopleSoft data.
Reconciliation report run parametersA: Pay Run IDB: Business UnitC: Differences only check box

Step 4: Click Add Attachment.

  • The attachment is the B62 data (PIMS PDC1500-4) for this pay period and campus.
Add Attachment button

Step 5: Click Choose File then browse to and then select the current B62 data file.

File attachment window: no file chosen

Step 6: Click Upload.

File attachment window: B62K2005.txt

Step 7: Confirm the correct B62 data file is loaded.

File Path and Name/CSUFTPD/chr/chrftphdv/FLCMP/B62_-_Fullerton_-_22.01.31

Step 8: Optional: Select Department or Unit to limit the scope of the report.

Optional filters: Department and Units

Step 9: Click Run.

  • The Process Scheduler Request window opens.
Run button

Step 10: Confirm the active Server Name is selected.

Process Scheduler Request window with an arrow pointing to the server name field.

Step 11: Click OK.

OK button

Step 12: Wait for the process to complete.

  • If you have access to the Process Monitor, you can refresh the page until the Distribution Status is Posted.
Process Monitor
Refresh button. Distribution status posted.

Review the Reconciliation Report

Back to top

After you run the Reconciliation report process, you can view or download the Reconciliation report. The report is not available from the Report Manager link when you run the report: you must go to a separate page to review Reconciliation Reports.

Step 1: Navigate to CSU MPC Reconciliation.

  • Menu > Time and Labor > CSU Time and Labor > CSU MPC Reconciliation.
Navbar button

Step 2: Enter your business unit and then click Search.

CSU Recon Report page search

Step 3: Click the Business Unit link to open the report.

  • The Reconciliation Report opens.
Report search results

Step 4: Review the report.

  • If you selected the Differences Only option, the report shows only rows with data that need correction. The main focus should be on the differences between PS Pay and SCO Pay.
Reconciliation report columns:NameEmpl IDEmpl RcdSerialUnitDept IDJob CodeJob TitleFTEPS Fraction
  • PS Pay: Payment for that period in the PeopleSoft data
  • MPC Days Worked: Days worked from the PeopleSoft data. A blank value means that the employee worked the entire pay period
  • MPC Hours Worked: Hours worked from the PeopleSoft data. Only used for hourly employees
  • Hours Docked: Hours removed
  • SCO Fraction: The fraction of full-time equivalency (FTE) stored in SCO’s Personnel/Payroll Information Management System (PIMS).
  • SCO Pay: Payment from the CIRS data
  • SCO Days Worked: Days worked from the SCO data. The number 99 means that the employee worked the entire pay period
  • SCO Hours Worked: Hours worked from the SCO data. Only used for hourly employees
Reconciliation report columns:PS PayMPC Days WorkedMPC Hours workedHours DockedSCO FractionSCO PaySCO Days WorkedSCO Hours Worked

Step 5 Optional: Export the data

  1. Click the Grid icon to export the report to Microsoft Excel.
  2. Click the Search icon to search for a string
  3. Click Run PDF to export the report as a PDF file
Reconciliation report optional actions

Back to top

End of Article

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Previous Article Reroute Absence and Time Approvals Transactions
Next Article Run and Review Payroll Input Process (PIP)

Time & Labor - Absence Management (TLAM)

Job Aids: Step-by-Step Instructions 26
User Process Guides 12
Process Flows 16

Recently Updated Articles

More Recently Updated Articles