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

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)