HR - HR Report List
This job aid contains a list of Human Resources (HR) reports and queries, a brief description and a hyperlink to the reports KnowledgeBase document..
- 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 TE - WED - Workflow Exception Dashboard 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.
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 HR - Address Cleansing Exception Report (SQR Report) 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 HR - Missing Address Report (EPM) Lists employees with a missing address. Employees appearing on this query need to have this information updated via Modify a Person. X HR - WED - UW_HR_MISSING_BUSINESS_ADDRESSES Lists employees with a missing Business address. Employees appearing on this query need to have this information updated via Modify a Person. X HR - WED - UW_HR_MISSING_HOME_ADDRESSES Lists employees with a missing Home address. Employees appearing on this query need to have this information updated via Modify a Person. X HR - Search for Existing Person in EPM Displays basic person and job information when a search by EmplID, Name, Date of Birth, or Social Security Number is done. UW Person Lookup includes Social Security Number. X HR - WED - UW_HR_MISSING_ADJ_CONTINUOUS_SVC_DT Lists WRS eligible employees missing an Adjusted Continuous Service Date. X HR - WED - UW_HR_MISSING OR INCORRECT_DATE_OF_BIRTH Lists employees with Date of Birth data errors. Employees appearing on this query need to have this information updated via Modify a Person. X HR - 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 HR - WED - UW_HR_UNC_NO_DEFAULT_SCHED Lists AS employees without a correctly assigned work schedule. X HR - Criminal Background Check - Position of Trust (includes report) 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 HR - Passport/Visa Exp Report (SQR Report) Lists employees who have visas that expire for the Dept ID, Empl Class and From/To Date parameters selected. X HR - Union Membership (SQR Report) Lists all employees with jobs in the union codes for the selected parameters. It does not reflect that they are dues paying members. X HR - WED - UW New Hire Hold Report Lists employees who have blank values in their WRS Previous State or Local Service fields or who have Benefit Primary Flag issues. X HR - Project Employee Report (EPM) Lists active University Staff Project - FT Finite (classified project) employees with their hire date and expected end date for the selected as of date and department/division/campus. X X HR - University Staff Temporary (LTE) Hours Report 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 HR - FTE Monitoring Report Lists employees with multiple active jobs that total more than 1.0 FTE. X HR - FA/AS/LI Hourly FLSA Exempt (Query Report) Lists active FA/AS/LI employees whose job FLSA status is Exempt and whose Pay Basis is Hourly. X HR - Job Empl Class Change Audit (Query Report) Lists employees who experienced an Employee Class (Empl Class) change between the selected date range. X HR - Employees on Leave of Absence Without Pay Report Lists employees on an unpaid leave of absence; Empl Status of "L". X HR - FMLA/WFMLA Eligibility Report Accumulates and totals an employees worked hours and leave hours to help determine eligibility for leave covered by FMLA/WFMLA. X HR - Primary Job Audit (SQR Report) Lists employees with multiple jobs and Primary Job Indicator discrepancies. X X HR - UW Probation Report (SQR Report) Lists University Staff Ongoing (classified permanent) employees who are at the three-month and the five-month probation points in the probationary period. X X HR - Pay Progression Report Lists employees that should receive pay rate increases for pay progression. X HR - WED - UW_HR_OVERMAX_UNDERMIN Query 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 HR - HRS vs Budget Compare Report Compare HRS and Budget information. X X HR - Expected Job End Date (EJED) Query Lists employees for whom the batch process will insert a termination row. X HR - Student Help Payroll Inactivity Recap Report (UWHRR001) Lists Student Help employees that have not been paid for several months and have been automatically terminated. X HR - Terminated Employee Report (Query Report) Lists terminated employees within a specific date range. X HR - Job List by Department Report (EPM) Lists employees with active jobs for the selected parameters. X HR - Active Position History Report Lists information on each active position including the Effective Date, Action Reason, Title and Location. X HR - Vacant Position Report Lists vacant positions for the selected parameters. X HR - Position Status Report Lists current position-related data for positions that meet the selected parameters, including Position Status. X HR - Position Exception or Override Report (SQR Report) 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 HR - Posn Empl Class Change Audit (Query Report) Lists POSITION_DATA records that have had Employee Class changes within a specified date range. X HR - WED - UW_HR_SOD Reports Lists users who have created HRS entries which could have a potential Separation of Duties (SOD) conflict. X HR - WED - UW_HR_SOD_OVERDUE - SOD Overdue Reports and Oversight Lists potential Separation of Duty (SOD) conflicts that are now considered overdue.
- FN - Finance Report List
- HR - Organizational Department Additions and Changes
- PD - Setting Up Run Control IDs
- PD - Viewing the Process Monitor
- TAM - Report List
- TE - WED - Workflow Exception Dashboard
- UWSC Support - Get help from the UW Service Center Support Team