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
Click on the links below to skip directly to a section:

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

Related Links:

Get Help



Keywordsreport, home, remote   Doc ID114150
OwnerJessica R.GroupUW–Shared Services
Created2021-10-07 06:59:40Updated2024-08-02 13:04:07
SitesUW–Shared Services
Feedback  0   0