HR Report List for HRS

GENERAL DESCRIPTION:

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:

Some Reports and or Queries are scheduled while others are expected to be run on an Ad hoc basis.
A number of HRS reports are delivered to campuses via the Cypress Report Distribution System.
- Please contact the HRS Support Center to request access to Cypress.
The The Workflow Exception Dashboard in HRS is available for credentialed users ONLY and is based on current security roles.
- WED queries will be viewable only if users have the ability to fix them.
Corrective action may be required as a result of information presented on any of these reports.

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

Running the Address Cleansing Exception Report in HRS 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
Processing the WED Missing Business Addresses Report in HRS Lists employees with a missing Business address. Employees appearing on this query need to have this information updated via Modify a Person.

X
Processing the WED Missing Home Addresses Report in HRS Lists employees with a missing Home address. Employees appearing on this query need to have this information updated via Modify a Person.

X
Processing the WED Missing Adjusted Continuous Service Date Report in HRS Lists WRS eligible employees missing an Adjusted Continuous Service Date.

X
Process the WED Missing or Incorrect Date of Birth Report in HRS Lists employees with Date of Birth data errors. Employees appearing on this query need to have this information updated via Modify a Person.

X
Processing the Missing SSNHR - WED - UW_HR_MISSING_SSN 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
Processing the Missing Default Schedule Report (Academic Staff) in HRS Lists AS employees without a correctly assigned work schedule.
X

Using the Person Assignment Checklist to record Criminal Background Check, Position of Trust and Sexual Harassment Reference Check in HRS 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

Running the Passport/Visa Exp Report (SQR Report) in HRS Lists employees who have visas that expire for the Dept ID, Empl Class and From/To Date parameters selected.

X
Processing the WED New Hire Hold Report in HRS Lists employees who have blank values in their WRS Previous State or Local Service fields or who have Benefit Primary Flag issues.
X
X

Running the University Staff Temporary (LTE) Hours Report in HRS 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

Running the FTE Monitoring Report in HRS Lists employees with multiple active jobs that total more than 1.0 FTE.
X

Running the FA/AS/LI Hourly FLSA Exempt Audit Report in HRS Lists active FA/AS/LI employees whose job FLSA status is Exempt and whose Pay Basis is Hourly.
X

Running the Job Empl Class Change Audit (Query Report) in HRS Lists employees who experienced an Employee Class (Empl Class) change between the selected date range.
X

Running the Employees on Leave of Absence Without Pay Report in HRS Lists employees on an unpaid leave of absence; Empl Status of "L".
X

Accessing the FMLA/WFMLA Eligibility Report in HRS Accumulates and totals an employees worked hours and leave hours to help determine eligibility for leave covered by FMLA/WFMLA.
X

Running the Primary Job Audit Report in HRS Lists employees with multiple jobs and Primary Job Indicator discrepancies.
X
X

Running the UW Probation Report in HRS 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
Processing the WED Overmax Undermin Report in HRS 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

Running the Expected Job End Date (EJED) Query in HRS Lists employees for whom the batch process will insert a termination row.

X

Running the Student Help Payroll Inactivity Recap Report in HRS Lists Student Help employees that have not been paid for several months and have been automatically terminated.
X

Running the Terminated Employee Report in HRS Lists terminated employees within a specific date range.
X

Running the Active Position History Report in HRS Lists information on each active position including the Effective Date, Action Reason, Title and Location.
X

Running the Vacant Position Report in HRS Lists vacant positions for the selected parameters.
X

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

Running the Position Exception or Override Report (SQR Report) in HRS 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

Running the Position Empl Class Change Audit (Query Report) in HRS Lists POSITION_DATA records that have had Employee Class changes within a specified date range.

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

X
[Link for document 55605 is unavailable at this time.]
Lists potential Separation of Duty (SOD) conflicts that are now considered overdue.
X

Reviewing Mandatory Employee Training in HRS
List of employee status of courses that all UW employees are required to take as a condition of employment.

Adhoc	Cypress	WED	Report	Report Description
	X		Running the Address Cleansing Exception Report in HRS	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	Processing the WED Missing Business Addresses Report in HRS	Lists employees with a missing Business address. Employees appearing on this query need to have this information updated via Modify a Person.
		X	Processing the WED Missing Home Addresses Report in HRS	Lists employees with a missing Home address. Employees appearing on this query need to have this information updated via Modify a Person.
		X	Processing the WED Missing Adjusted Continuous Service Date Report in HRS	Lists WRS eligible employees missing an Adjusted Continuous Service Date.
		X	Process the WED Missing or Incorrect Date of Birth Report in HRS	Lists employees with Date of Birth data errors. Employees appearing on this query need to have this information updated via Modify a Person.
		X	Processing the Missing SSNHR - WED - UW_HR_MISSING_SSN	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	Processing the Missing Default Schedule Report (Academic Staff) in HRS	Lists AS employees without a correctly assigned work schedule.
X			Using the Person Assignment Checklist to record Criminal Background Check, Position of Trust and Sexual Harassment Reference Check in HRS	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			Running the Passport/Visa Exp Report (SQR Report) in HRS	Lists employees who have visas that expire for the Dept ID, Empl Class and From/To Date parameters selected.
		X	Processing the WED New Hire Hold Report in HRS	Lists employees who have blank values in their WRS Previous State or Local Service fields or who have Benefit Primary Flag issues.
X	X		Running the University Staff Temporary (LTE) Hours Report in HRS	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		Running the FTE Monitoring Report in HRS	Lists employees with multiple active jobs that total more than 1.0 FTE.
X			Running the FA/AS/LI Hourly FLSA Exempt Audit Report in HRS	Lists active FA/AS/LI employees whose job FLSA status is Exempt and whose Pay Basis is Hourly.
X			Running the Job Empl Class Change Audit (Query Report) in HRS	Lists employees who experienced an Employee Class (Empl Class) change between the selected date range.
X			Running the Employees on Leave of Absence Without Pay Report in HRS	Lists employees on an unpaid leave of absence; Empl Status of "L".
X			Accessing the FMLA/WFMLA Eligibility Report in HRS	Accumulates and totals an employees worked hours and leave hours to help determine eligibility for leave covered by FMLA/WFMLA.
X			Running the Primary Job Audit Report in HRS	Lists employees with multiple jobs and Primary Job Indicator discrepancies.
X	X		Running the UW Probation Report in HRS	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	Processing the WED Overmax Undermin Report in HRS	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		Running the Expected Job End Date (EJED) Query in HRS	Lists employees for whom the batch process will insert a termination row.
	X		Running the Student Help Payroll Inactivity Recap Report in HRS	Lists Student Help employees that have not been paid for several months and have been automatically terminated.
X			Running the Terminated Employee Report in HRS	Lists terminated employees within a specific date range.
X			Running the Active Position History Report in HRS	Lists information on each active position including the Effective Date, Action Reason, Title and Location.
X			Running the Vacant Position Report in HRS	Lists vacant positions for the selected parameters.
X			Running the Position Status Report in HRS	Lists current position-related data for positions that meet the selected parameters, including Position Status.
X			Running the Position Exception or Override Report (SQR Report) in HRS	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			Running the Position Empl Class Change Audit (Query Report) in HRS	Lists POSITION_DATA records that have had Employee Class changes within a specified date range.
		X	Processing the WED SOD Reports in HRS	Lists users who have created HRS entries which could have a potential Separation of Duties (SOD) conflict.
		X	[Link for document 55605 is unavailable at this time.]	Lists potential Separation of Duty (SOD) conflicts that are now considered overdue.
X			Reviewing Mandatory Employee Training in HRS	List of employee status of courses that all UW employees are required to take as a condition of employment.

To the top

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