This article lists the public EPM queries and descriptions for this topic. Please review available public queries below before making a new query.
EPM public query names and descriptions for Payroll
- Acctcd Pay Discrepancies (DOCX) - This query to identify account codes discrepancies between payroll and position data by deptid and pay end date. (Nick Visone)
- Additional Pay Audit (DOCX) - This query returns additional pay entries; prompts on employee id, department and earnings code
- All Pay & Hours (DOCX) - 10/09/04 - query returns all total hours, pay, amounts by employee, erncd, etc. information. This query prompts on Deptid like (%) and Pay End Date.
- Detailed Payroll for Year End (DOCX) - This query was created by the Core Team to assist with analysis of Payroll Detail. If questions or concerns arise a help ticket should be logged and forwarded to the EPM Team.
- Employee payroll deductions (DOCX) - This query produces all deductions for each employee prompted by pay period end date and department i.d.
- EE furlough hours and amount (DOCX) - This query returns furlough hours and amounts by department and pay period.
- Vacation in Lieu of Furlough (DOCX) - This query returns hours and amounts coded to the earn code RFD, to be used when employee has taken a voluntary leave reduction day within the proscribed time frame and is granted a paid vacation day in lieu of a mandatory furlough day by department and pay period.
- Pay Summ & GL Reconciliation (DOCX) - This query is used to facilitate reconciliation to Payroll Summary and GL Trial Balance by Fund, Clss Fld, Account, CT DEPTID CF and Fiscal Year. For PR Reconciliation Job Aid.
More resources