PY - Workflow for Additional Pay Queries

GENERAL DESCRIPTION:

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 XLM (Extensible Markup Language) format.



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 status of addl pay requests prior to first prelim calc.

Navigation: Reporting Tools > Query > Query Viewer
  1. In the begins with field enter all or part of the query name: UW_PY_WFAP_PENDING_APPROVALS.

  2. The Search Results will display.

  3. 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.

    https://kb.wisc.edu/images/group61/86904/approvalstatussearch.jpg

  4. Enter the Department ID, used the % as a wildcard.

  5. Click View Results.
https://kb.wisc.edu/images/group61/86904/approvalstatusresults1.jpg
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

Addl Pay Workflow Transaction History Query

This query will show all additional pay requests based upon the report parameters.
This query will be helpful to monitor status of addl pay requests prior to first prelim calc.

Navigation: Reporting Tools > Query > Query Viewer
  1. In the begins with field enter all or part of the query name: UW_PY_WFAP_TRANS_HIST.

  2. The Search Results will display.

  3. 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.

  4. 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.

  5. 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.
https://kb.wisc.edu/images/group61/86904/allstatusresults1.jpg
Column Information:
  • ID - Empl ID of the employee the request is for
  • 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
  • Name - name of the approver at that level


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
  1. In the begins with field enter all or part of the query name: UW_PY_WFAP_CURRENT_DEPT_APPROV.

  2. The Search Results will display.

  3. 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.

    https://kb.wisc.edu/images/group61/86904/currentapproverssearch.jpg

  4. Enter the Business Unit/Division/Department to see results for in the Deptid (Begins with) field.
    NOTE: Use the % as a wildcard.

  5. Click View Results.

    https://kb.wisc.edu/images/group61/86904/currentapproversresults.jpg


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
  1. In the begins with field enter all or part of the query name: UW_PY_INSUFFICIENT_APPROVERS.

  2. The Search Results will display.

  3. 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.

    https://kb.wisc.edu/images/group61/86904/INSUFFICIENTAPPROVERSEARCH.jpg

  4. Enter the Business Unit/Division/Department to see results for in the Deptid (Begins with) field.
    NOTE:
    Use the % as a wildcard.

  5. 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.
https://kb.wisc.edu/images/group61/86904/INSUFFICIENTAPPROVERresults.jpg




ADDITIONAL RESOURCES

Related KBs:

Related Links:
    • N/A



    Keywords:   Doc ID:86904
    Owner:Kate I.Group:Human Resource System (HRS)
    Created:2018-10-18 13:44 CSTUpdated:2018-11-09 10:02 CST
    Sites:Human Resource System (HRS)
    Feedback:  0   0