OAR Reports - WED and Queries in HRS
OverviewHR Managers and Administrators can access reports in HRS to assist them in approving Outside Activity Reports (OARs). UW_HR_OAR_NEED_APRVL is a WED error report created to find list of employees that has submitted the Outside Activity form for a given calendar year with reported outside activity that needs a reviewer to approve. There are also three queries that can be viewed in Excel format to view employee progress on OARs.
- This WED is available for credentialed users ONLY and is based on current security roles; queries will be viewable only if users have ability to fix them.
- For general WED information, see TE - WED - Workflow Exception Dashboard
- When working from the WED, employees will not automatically fall off the report once a user approves and submits the OAR. A WED process will run overnight and then the employee(s) who has(have) been approved will drop off of the report.
- On the other hand, the queries described below update instantly and do not require an overnight process to refresh. However, unlike the WED Report, there is no direct link to the employee's OAR.
Instructions for OAR WED Report
- Log in to HRS. Workflow Exception Dashboard (WED) Error Queries appear on the right. Error Queries appear based on your current security and whether there are errors to fix.
- To filter the results of the Error Query list further, options appear below.
Module = Cast net by specific functional group queries
Priority = All queries by default are sorted High, Medium, Low
Business Unit = Filter by campus
Dept ID = Filter by specific Dept ID (must enter full alpha + six digit code)
DeptID (like) = Filter by particular Dept ID to capture larger net at the division level or multiple departments
- Click the UW_HR_OAR_NEED_APRVL query link.
Note: Once you see the query results, there are filters above the list: Business Unit, DeptID (1), DeptID - Like (2), Show Claimed, Show Completed.
- Click the "Check to Claim" check box. Your name will appear in the Claimed by section with the Date and Time noted.
- For the employee you have claimed, click the UW_HR_OAR_FORM_MGR link in the Link to Correct column.
- A new browser tab opens with the employee's OAR form.
- Once in the employee form, review it, and scroll to the bottom of it to the "Review Approval Information" section.
- When "Approved by Reviewer" is checked, it will automatically fill Reviewed Date Time Stamp and Reviewer ID. Update "Reviewer Comments" Section and click Submit.
- Close the browser tab that has the employee's OAR.
- (This is an optional step that can be used by a group of HR Administrators so that they know who has completed which employee's OAR in an effort to prevent having two HR Administrators work on the same employee's OAR at the same time.)
Back on the UW_HR_OAR_NEED_APRVL Query page, click the "Completed" check box. Your name will appear in the Completed by column and the date and time will be noted in the Completed Date/Time column.
- You can continue to work on the OARs you find on the UW_HR_OAR_NEED_APPRVL Query page.
- To return to the main WED page, you can either click the Home link or the Return to Dashboard link, which is available on every page.
Running an OAR Query
Another option for HR Administrators wishing to find information about employee progress on Outside Activity Report completion is to run queries in HRS. These are three queries that are available:
UW_HR_OAR_FORM_DATA - lists employees who have submitted the OAR and have listed outside activities
UW_HR_OAR_FORM_NOT_SBMT - lists employees who have not submitted the OAR, including those that have clicked Save for Later
UW_HR_OAR_FORM_NO_ACTVTY - lists employees who submitted the OAR and checked "No outside activity"
Here are the steps to run an OAR query:
- Log in to HRS.
- Navigate to Query Viewer from the home page by clicking the NavBar icon and choosing Reporting Tools > Query > Query Viewer.
- Enter UW_HR_OAR in the "begins with" field and click Search.
- The queries listed above will appear. You can view the results in a few different formats, with the Excel format being the most common. To view the format in Excel format, click the Excel link in the Run to Excel column.
- On the new tab that appears, you can determine the business unit(s) and department(s) you want to view.
NOTE: Enter the % symbol in the "Business Unit" and/or "Department fields" to see all that you can access, or enter the first couple of numbers common to the business unit or department followed by the % symbol to see multiple business units or departments.
- An Excel spreadsheet displaying the results of the query appears.
- With the employees listed in the resulting spreadsheet, go to the HR Manager OAR Form Review in HRS and search for the employees listed.
- TL - Time and Labor Queries (contains "How to Run a Query")
- UWSC Support - Personalize HRS Content and Layout (contains "How to add Workflow Exception Dashboard")