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

Running the Telework Agreement Query in HRS


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


  1. Navigate to:  Reporting Tools > Query > Query Viewer
  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

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 05:59 CSTUpdated:2021-10-13 14:19 CST
Sites:UW–Shared Services
Feedback:  0   0