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

1. Navigate to:  Reporting Tools > Query > Query Viewer
2. Enter the query name
3. Click Search
4. Click the Run to Excel hyperlink
5. 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:

1. 1. 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.
   2. 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.
   3. 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.
   4. 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.

Additional Resources

Related KBs:

• Maintain Telework Data in HRS 

Related Links:

• UW System Telecommuting Policy
• UW Madison Telecommuting Policy

• UW-Shared Services (UWSS)
• Office of Technology Services (OTS) Helpdesk