Navigate to Reporting Tools > Query > Query Viewer.

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

Click on the "Search" button

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

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

Click on View results.

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

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

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

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.

Missing SHRC dates on the query are also the result of initiating the SHRC request directly in BP Logix and not manually adding the completion date in HRS in the Person Assignment Checklist. For the SHRC completion date to be automatically entered in HRS, the SHRC request must have been done through the Applicant Checklist and the hire through Manage Hires.

Some institutions request SHRCs for non-required employee types, so all employee types are included in the query. If the query is downloaded in Excel, it may be sorted by Empl Class to aid in identifying the employees who are required to have the Sexual Harassment Reference Check.