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
- Navigate to: Reporting Tools > Query > Query Viewer
- Enter UW_HR_SYS_TWA_APPROVERS for UW System OR UW_HR_MSN_RWA_APPROVERS for UW Madison
- Click Search
- Click the Run to Excel hyperlink
- 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
- 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:
