HR Report List for HRS

Overview

This job aid contains a list of Human Resources (HR) reports and queries, a brief description and a hyperlink to the reports KnowledgeBase document.

Process Considerations:

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


HR Reports / Queries

These reports can be run ad hoc, are delivered via Cypress, and/or are found on the WED. The report name links to that KB.

Adhoc
Cypress
WED
Report
Report Description

X

Lists employees that have been identified as having invalid Home or Mail addresses in HRS. Employees appearing on this query need to have this information updated via Modify a Person.


X
Lists employees with a missing Business address. Employees appearing on this query need to have this information updated via Modify a Person.


X
Lists employees with a missing Home address. Employees appearing on this query need to have this information updated via Modify a Person.


X
Lists WRS eligible employees missing an Adjusted Continuous Service Date.


X
Lists employees with Date of Birth data errors. Employees appearing on this query need to have this information updated via Modify a Person.


X
Lists employees with missing or incorrect Primary National ID information. Employees appearing on this query need to have this information updated via Modify a Person.


X
Lists AS employees without a correctly assigned work schedule.
X


Identify employees who have been identified in a Position of Trust and when the last background check was done. Includes steps to record all jobs identified as Position of Trust in Job Data on the UW Custom tab.
X


Lists employees who have visas that expire for the Dept ID, Empl Class and From/To Date parameters selected.


X
Lists employees who have blank values in their WRS Previous State or Local Service fields or who have Benefit Primary Flag issues.
X
X

Lists cumulative hours for each active LTE Job within the most recent twelve months from the job anniversary date. Only includes HRS hours.
X
X

Lists employees with multiple active jobs that total more than 1.0 FTE.
X


Lists active FA/AS/LI employees whose job FLSA status is Exempt and whose Pay Basis is Hourly.
X


Lists employees who experienced an Employee Class (Empl Class) change between the selected date range.
X


Lists employees on an unpaid leave of absence; Empl Status of "L".
X


Accumulates and totals an employees worked hours and leave hours to help determine eligibility for leave covered by FMLA/WFMLA.
X


Lists employees with multiple jobs and Primary Job Indicator discrepancies.
X
X

Lists University Staff Ongoing employees who are at the three-month and the five-month probation points in the probationary period.
X
X

[Link for document 28763 is unavailable at this time.] 
Lists employees that should receive pay rate increases for pay progression.


X
Lists employees with Comp Rates above the Maximum or below the Minimum when the appropriate Over Max or Under Min flag (indicating approval) is not checked. Employees appearing on this query need to have this information updated via Job Data.
X
X

Lists employees for whom the batch process will insert a termination row.

X

Lists Student Help employees that have not been paid for several months and have been automatically terminated.
X


Lists terminated employees within a specific date range.
X


Lists information on each active position including the Effective Date, Action Reason, Title and Location.
X


Lists vacant positions for the selected parameters.
X


Lists current position-related data for positions that meet the selected parameters, including Position Status.
X


The Exception report lists positions where the incumbent job and position data is out of sync.
The Override report lists positions where automatic cross updating has been prevented from occurring.
X


Lists POSITION_DATA records that have had Employee Class changes within a specified date range.


X
Lists users who have created HRS entries which could have a potential Separation of Duties (SOD) conflict.


X
Lists potential Separation of Duty (SOD) conflicts that are now considered overdue.
X


List of employee status of courses that all UW employees are required to take as a condition of employment.


X
List of employees assigned to Job Codes ineligible for pay while being assigned to a Pay Basis with compensation.


X
List of employees assigned to Positions that do not have assigned Reports To values.


X
List of employees whose Reports To value on Job Data does not match the Reports To value assigned to their Position.



X

List of employees assigned to Positions with a Reports To value equal to the employee's own Position Number. 


X

List of employees assigned to Positions where the Reports To value points to a vacant Position.
X

X

Lists employees that have submitted the Outside Activity form for a given calendar year, reported outside activity and needs reviewer to approve the activity reported.
X



Lists employees who have submitted the Outside Activity Report OAR and have not listed outside activities.
X



Lists employees who have not submitted the Outside Activity Report OAR, including those that have clicked Save for Later

X


Lists employees who have submitted the Outside Activity Report OAR and checked "No outside activity".

X


Lists employees who have associated Person Assignment Checklist(s) recording: Background Check (CBC) date, Sexual Harassment Reference Check (SHRC) date, Position of Trust type (POT), Campus Seniority Date.
X


Running Query UW_HR_CHECKLIST_BY_ID
Shows all current checklists by a specific EMPLID + EMPL_RCD (optional) for both Person Checklist and Person Assignment Checklist
X


Running Query UW_HR_CHECKLIST_BY_DT
Lists employees along with job data information as well as the following checklist data - Criminal Background Check (CBC) Date, Position of Trust (POT) Type and Date, Sexual Harassment Reference Check (SHRC) Date and Campus Seniority Date.


X
Processing the WED Report for Incorrectly Assigned Person Assignment Checklists

Lists employees who have incorrectly assigned Person Assignment Checklists - UWDATE is the only Checklist Code to be used in Person Assignment Checklist page. Not UWPREC and others.


X
Processing the WED Report for Incorrectly Assigned Person Checklists
Lists employees who have incorrectly assigned Person Checklists - UWSNDT and UWPOI are the only checklist codes used in Person Checklist currently.
X



Lists employees who could potentially require a change to their FLSA Status from Exempt to Non-Exempt.
X



Lists employees who have a single active HR status, with an FLSA Status of Exempt, and who are under the FLSA threshold.
X


Lists employees who potentially need a change in their FLSA Status from Exempt to Non-Exempt, with Exceptions for due to job duties such as Doctor, Teacher, Lawyer, Camp Counselor or Academic Administrator.


X
Lists employees who have numerous active job records with varying FLSA statuses.

Additional Resources

Related KBs:Related Links: 

Get Help

  • Click HERE to contact UW Shared Services or HERE for the Office of Technology Services (OTS) Helpdesk if you have any issues with these instructions.
To the top