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 Retirement Payroll
- Retiree addresses (DOCX) - The Retirement Payroll Addresses query displays current address information for retirees.
- New retiree accounts (DOCX) - The purpose of this query is to list new retiree accounts added.
- Plan B age 62 retirement options (DOCX) - This query displays retirees in the Plan B, age 62 retirement option.
- Plan B Age 66 Retirement options (DOCX) - This query displays retirees in the Plan B, age 66 retirement option.
- Transaction amounts (DOCX) - This query returns summary retirement payroll transaction amounts.
- Prior and last names (DOCX):This query returns current and prior last names.
- AR by check (DOCX) - This query displays accounts receivable posted by check.
- AR goal amounts and balances (DOCX) - This query displays accounts receivable goal amounts and balances.
- 10 year cert ending in 3 months (DOCX) - This query displays 10 year cert ending in 3 months as of the date entered.
- 20 year cert ending in 3 months (DOCX) - This query displays 20 year cert ending in 3 months as of the date entered.
- Equity refunded (DOCX) - Lists equity refunded.
- CEUI union dates (DOCX) - This query displays union dues listing - CEUI.
- Credit union deductions (DOCX) - This query displays credit union deductions.
- A and R union dues (DOCX) - This query lists A & R union dues.
- CSEA union dues (DOCX) - This query lists CSEA union dues.
- AFSCME union dues (DOCX) - This query lists AFSCME union dues.
- QDRO COLA accounts (DOCX) - This query lists COLA audit QDRO accounts.
- Deceased retirees (DOCX) - This query returns a list of deceased retirees as entered on the custom Retirement page. Enter the last update (specifically formatted YYYY-MM-DD) to limit the output.
- Monthly rpt new retiree adds (DOCX) - This query lists monthly rpt-new retiree adds.
More resources