This job aid contains a list of Human Resources (HR) reports and queries, a brief description and a hyperlink to the reports KnowledgeBase document..
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 - 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 - 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 - 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 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 Audit 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 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 - 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.