Topics Map > Human Resource System (HRS) > HRS Human Resources Administration
Running the Sexual Harassment Reference Check Compliance Query in HRS
OverviewHow 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.
- For this query, recent hires are compared to employees who are manually entered in the Person Assignment Checklist with a SHRC completion date or employees automatically entered when using the Prepare for Hire > Manage Hires process.
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. Students are not included in the employee types.
- Initiating a Criminal Background Check and Sexual Harassment Reference Check in TAM
- Hiring an Applicant in TAM
- Hiring a TAM Applicant from Manage Hires in HRS