Running the Sexual Harassment Reference Check Compliance Query in HRS


How to run the UW_HR_HIRE_SHRC_STATUS Query Report to check the completion of Sexual Harassment Reference Checks for required employee types who are hired, rehired, and transferred. The query can be used as a tool to check for compliance for UW Administrative Policy 1275.

Process Considerations:

You may click on the links below to navigate directly to a section:


  1. Navigate to Reporting Tools > Query > Query Viewer.

  2. Enter the Query Name UW_HR_HIRE_SHRC_STATUS in the "begins with" field

  3. Click on the "Search" button

  4. Click on the Run to HTML link or the Run To Excel link

  5. Enter values into Business Unit, DeptID (optional) and a range of dates in From Hire Date and To Hire Date.

    Query Parameters

  6. Click on View results.

  7. The Action Descr and Eff Dt columns indicate the type of hire and the effective start date of the hire, respectively.

  8. The SHRC Status Date column indicates the date of the completed Sexual Harassment Reference Check.

  9. The SHRC Status column indicates the status of the Sexual Harassment Reference Check with either In Progress or Completed listed.

  10. If the last three columns are blank, then a reference check has not been requested and completed for that particular hire. Depending on the employee type, a Sexual Harassment Reference Check may need to be requested retroactively in order to be in compliance with UW Administrative Policy 1275. Please contact UW Shared Services (and submit a ticket) for next steps on retroactive SHRC Request.

Additional Resources

Related Links:

Related KBs:

Get Help

  • Click HERE to contact UW Shared Services - Service Operations Department or HERE for the UWSS IT HelpDesk if you have any issues with these instructions.