Topics Map > Human Resource System (HRS) > HRS Human Resources Administration

Running the Telework Agreement Query in HRS

Overview:

This query provides a method for monitoring UW Telework / Remote Work Agreement approvals and agreement statuses. Results of the query display the highest approval level the agreement has reached and the approvers at that level.

Process Considerations:

  • Security roles required to run this report include: UW_UNV_HR_REPORTS or UW_UNV_HR_QUERY_NS
  • This query will supplement the following queries:
    • UW System Approved Telecommuting Agreement query (UW_HR_SYSTW_ACTIVE_AGREEMENTS)
    • UW Madison Approved Telecommuting Agreement query (UW_HR_MSNREMOTEWORK_AGREEMENTS)
  • Query results will return result based on user's row level security
    • NOTE:  UW Madison query does not enforce row level security
  • User can limit results by Department ID or Form Status via optional prompts

Instructions

  1. Navigate to:  Reporting Tools > Query > Query Viewer
  2. Enter UW_HR_SYS_TWA_APPROVERS for UW System OR UW_HR_MSN_RWA_APPROVERS for UW Madison
  3. Click Search
  4. Click the Run to Excel hyperlink
  5. Run to Excel
  6. When prompted you can choose to limit results by Dept ID or Form Status or leave blank for all.

Field Explanations:

Approver Status Date
  • Date when form was routed to the approver
  • This field is blank for forms in "Saved" status
Last Date Time definition
  • Form Status is Saved = date requester saved the form
  • Form Status is Pending = same as Approver Status Date
  • Form Status is Executed = date specified approver’s status was assigned
    • Can be Approved or Bypassed
    • Can be used to determine timespan between approver assignment and when action was taken
  • Form Status is Withdrawn = date requester withdrew form
  • Form Status is Recycled = date an approver pushed form back to requester for changes (use View tab in Remote Work Agreement tool to see who entered the Pushback)

Sample Reports:

Pending Status
Example_Executed
Example_Recycled

Additional Resources

Related KBs: Related Links:

Get Help




Keywords:report, home, remote   Doc ID:114150
Owner:tami e.Group:UW–Shared Services
Created:2021-10-07 06:59 CDTUpdated:2021-10-13 15:19 CDT
Sites:UW–Shared Services
Feedback:  0   0