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
Click on the links below to skip directly to a section:

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
      Run to Excel
    5. When prompted you can choose to limit results by Dept ID, 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

  • Forms in Saved status: date requester saved the form
  • Forms in Pending status: same as Approver Status Date
  • Forms in Executed status: 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
  • Forms in Withdrawn status: date requester withdrew form
  • Forms in Recycled status: 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



Keywordsreport, home, remote   Doc ID114150
OwnerJessica R.GroupUW–Shared Services
Created2021-10-07 06:59:40Updated2023-08-15 10:23:46
SitesUW–Shared Services
Feedback  0   0