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

To the top

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

To the top

Instructions for Running the Current Approvers Query

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.

To the top

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.