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
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
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)