FOR PAYROLL: In preparation for the Final Calc, please run your audit queries and reports to ensure data integrity and, most importantly, that all your employees get paid

posted Jun 21, 2017, 8:53 AM by Peyri Herrera
Here is a list of queries to assist in your audit:

1. M_PY_CALC_ERROR_MSGS_BY_DIST. This query reflects all employees that had errors generated during the second pre-calc last night (6/20/17). These errors need to be resolved to ensure that your employees get paid. Here is a link to the job aid to resolve these issues: Payroll Error Messages (.xls). Once the Excel file opens, enable editing for cleaner format of the document.

2. M_DATAENTRY_AUDIT. This query identifies missing records, invalid data combinations, or inaccurate data. All errors identified by this query should be corrected prior to the final calc. Here is a link to the job aid to resolve these issues: Data Entry Audit Error Messages v1.1.pdf.

3. M_TL_PAYABLE_TIME_AUDIT. This query audits payable time and checks the status of time that is going to be loaded to payroll.

4. The queries above and also other suggested audit queries can be found in Monthly Payroll Queries and Reports v3.0.pdf.

For districts and organizations that do not pay or have deductions scheduled over 12 months, run the queries from the Summer Workshop. If June is a no pay or no deduct month, it is critical that you complete these audits. Here is a link to the list of summer month queries: Summer Month Queries v1.2.pdf (also called “Attachment B” from the Summer Months Workshop).