Topics Map > Human Resource System (HRS) > HRS Human Resources Administration
Running the Telework Agreement Queries 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
- 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 the query name
- 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.
List of UW Telework / Remote Work Agreement Queries:
-
- UW_HR_SYSTW_ACTIVE_AGREEMENTS query (UW System) or UW_HR_MSNREMOTEWORK_AGREEMENTS query (UW Madison) provides the full list of active agreements for active employees and includes all data from the agreement forms.
- UW_HR_ALL_SYSTW_W_RWA_INDIC query (UW System) or UW_HR_ALL_UWMSN_W_RWA_INDIC query (UW Madison) provides a list of all active employees with a Y (Yes) or N (No) to indicate whether the employee has or does not have an agreement.
- UW_HR_SYS_TWA_APPROVERS query (UW System) or UW_HR_MSN_RWA_APPROVERS query (UW Madison) provides agreement status for forms other than Executed, remote schedule, and approver information.
- UW_HR_ACT_UWSYS_RWA_SCHED_SUMM query (UW System) or UW_HR_ACT_UWMSN_RWA_SCHED_SUMM query (UW Madison) provides a summary of employee’s remote work schedule.