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
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, 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:
