New Payroll Query – M_PY_RETIREES_WITH_EARNINGS

posted Mar 6, 2019, 7:21 AM by Barbara Thiss
New icon

The new M_PY_RETIREES_WITH_EARNINGS query will show earnings for the Pay Period(s) selected in the prompt for employees who are set as “Retiree” for their Employee Classification in Job Data. You may pull a single employee by adding their employee id, or have the option to use the “%“ and run a wildcard search. To query a single Pay Period End Date, use the same Pay Period for the “From” and “To” fields. To query across multiple Pay Period End Dates, add the appropriate “From” as the starting point, and “To” as the ending Pay Period End Date.

Job Data > Job Information Tab
Job Data Retiree dropdown and M_PY_RETIREES_WITH_EARNINGS query parameters