Topics Map > Human Resource System (HRS) > Payroll > PY Learning Path
Running the Additional Pay Queries in HRS
Overview
Provide information about the reports developed to support the Workflow for Additional Pay process.Process Considerations:
- You can run the query in one of three formats: HTML (HyperText Markup Language) format, Excel spreadsheet format, or XML (Extensible Markup Language) format.
You may click on the links below to navigate directly to a section:
Instructions for Running the Pending Approvals Query
This query will only show additional pay requests that are in the approval process, not anything that is fully approved or denied.
This query will be helpful to monitor the status of addl pay requests prior to paysheets being created.
Navigation: Reporting Tools > Query > Query Viewer
- In the begins with field enter all or part of the query name: UW_PY_WFAP_PENDING_APPROVALS.
- The Search Results will display.
- Locate the query UW_PY_WFAP_PENDING_APPROVALS, and click either the HTML link or the Excel link to run the query results in a new browser window/tab.
NOTE: If you choose the HTML format, there is an option to download the query results to an Excel spreadsheet or CSV (comma separated value) text file.
- Enter the Department ID, use the % as a wildcard.
- Click View Results.
Column Information:
- Dept ID - employee's department ID that the addl pay request is for
- Empl Name - employee's name
- ID - employee's empl ID
- Empl Record - employee's empl record number
- Empl Class - requested employee's empl class
- Enterer - empl ID of the employee who submitted the addl pay request
- Step - what level the request is pending at (1 of 2 - first approver; 2 of 2 - second approver, etc)
- List - empl ID and name of individuals able to request at the current level
- Earn Code - earnings code the request was submitted for
- Eff Date - effective date of the addl pay request
- Wf ID - workflow approval ID
- Comments - information in the description field of the addl pay request
Instructions for Running the Addl Pay Workflow Transaction History Query
This query will show the step-by-step history of additional pay requests based upon the report parameters.
This query will be helpful to monitor the status of addl pay requests prior to paysheets being created.
Navigation: Reporting Tools > Query > Query Viewer
- In the begins with field enter all or part of the query name: UW_PY_WFAP_TRANS_HIST.
- The Search Results will display.
- Locate the query UW_PY_WFAP_TRANS_HIST, and click either the HTML link or the Excel link to run the query results in a new browser window/tab.
NOTE: If you choose the HTML format, there is an option to download the query results to an Excel spreadsheet or CSV (comma separated value) text file. - Enter the Search Parameters.
- Thread Status (optional) - Completed = Loaded; Pending = In Approval Process; Denied = Denied; Approved = Approved; Suspending/Pending Denial = Error.
- From Date (required) - first day of records to view, based upon the effective date of the Workflow Additional Pay request.
- Through Date (required) - last day of records to view, based upon the effective date of the Workflow Additional Pay request.
- Workflow Dept (required) - some or all of the department to be searched, use the % as a wildcard.
- Click View Results.
NOTE: Each completed step on a request will appear on its own line. For example - if two approvals have been completed on a request each approval will appear as its own line on the report.
Column Information:
- ID - Empl ID of the employee the request is for
- Name - Name of the employee the request is for
- Comment - Description entered on the Workflow Addl Pay Create page for the payment
- Enterer OperID - empl ID of employee who entered the request
- Step - Where the request is in the approval chain
- Dept ID - the workflow used to assign approvers
- Approver Name - name of the approver at that level
This query will show approvers set up at levels 2-5 for a specific business unit/division/department
Navigation: Reporting Tools > Query > Query Viewer
- In the begins with field enter all or part of the query name: UW_PY_WFAP_CURRENT_DEPT_APPROV.
- The Search Results will display.
- Locate the query UW_PY_WFAP_CURRENT_DEPT_APPROV, and click either the HTML link or the Excel link to run the query results in a new browser window/tab.
NOTE: If you choose the HTML format, there is an option to download the query results to an Excel spreadsheet or CSV (comma separated value) text file.
- Enter the Business Unit/Division/Department to see results for in the Deptid (Begins with) field.
NOTE: Use the % as a wildcard. - Click View Results.
Instructions for Running the Insufficient Approvers Query
This query will show employees with no level one approvers able to approve additional pay requests, it will also show individuals with only one unique level one approver.
Navigation: Reporting Tools > Query > Query Viewer
- In the begins with field enter all or part of the query name: UW_PY_INSUFFICIENT_APPROVERS.
- The Search Results will display.
- Locate the query UW_PY_INSUFFICIENT_APPROVERS (WfAP not enough approvers), and click either the HTML link or the Excel link to run the query results in a new browser window/tab.
NOTE: If you choose the HTML format, there is an option to download the query results to an Excel spreadsheet or CSV (comma separated value) text file.
- Enter the Business Unit/Division/Department to see results for in the Deptid (Begins with) field.
NOTE: Use the % as a wildcard. - Click View Results.
NOTE: UW Approver is an empl ID but the Reports to field is a position number, if the employee currently in the reports to position number is the same person as the UW Approver the employee will appear on the list as one unique approver.
Additional Resources
Related KBs:
- Entering Additional Pay in HRS
- Running the Additional Pay Mass Upload Process in HRS
- Workflow for Additional Pay Approver Maintenance Page in HRS
- Creating and Maintaining Time and Labor Security in HRS