Topics Map > DOCUMENT TYPE > Reference
Topics Map > FUNCTIONAL AREA > Human Resources (HR)

HR - HR Report List

GENERAL DESCRIPTION:

This job aid contains a list of Human Resources (HR) reports and queries, the menu path (navigation), description and frequency of production.

PROCESS CONSIDERATIONS:
  • Some Reports and or Queries are scheduled while others are expected to be run on an Ad hoc basis.
  • Corrective action may be required as a result of information presented on any of these reports.



HR Reports/Queries

Workflow Exception Dashboard (WED)

These reports are found on the WED. Where there is a corresponding KB, the report name links to that KB. The WED is available for credentialed users ONLY and is based on current security roles. Queries will be viewable only if users have the ability to fix them.

Report Report Description
 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.
 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.
 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.
 HR - WED - UW_HR_MISSING_ADJ_CONTINUOUS_SVC_DT Lists WRS eligible employees missing an Adjusted Continuous Service Date.
 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.
 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.
 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.
 HR - WED - UW_HR_SOD Reports
Lists employees who have created HRS entries which could have a potential Separation of Duties (SOD) conflict.
 HR - WED - UW_HR_SOD_OVERDUE - SOD Overdue Reports and Oversight
Lists employees with potential Separation of Duties (SOD) conflict that are considered overdue.
 HR - WED - UW_HR_UNC_NO_DEFAULT_SCHED
Lists AS employees without a correctly assigned work schedule.

Cypress Delivered Reports

These reports will be delivered to an HR Administrator's Cypress inbox. Where there is a corresponding KB, the report name links to that KB.

Report Query/Report Location Report Description Delivery Frequency
Expected Job End Date (EJED) Termination Report   N/A Lists all employees that have been terminated by the nightly or monthly EJED Termination process Nightly for all employee classes. The report is also scheduled as part of the monthly payroll process for all unclassified employee classes
HR - University Staff Temporary (LTE) Hours Report
HRS Main Menu > UW HR Reports > 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. After biweekly payroll confirm
HR - UW Probation Report (SQR Report)
HRS Main Menu > UW HR Reports > Probation Report Lists University Staff Ongoing (classified permanent) employees who are at the three-month and the five-month probation points in the probationary period. Monthly on the night of the 1st
Over Max/Under Min
HRS Main Menu > UW HR Reports > Over Max Under Min Report As delivered via Cypress, lists jobs with Comp Rates above the Maximum or below the Minimum when the appropriate Over Max or Under Min flag (indicating approval) is not checked. Other report options available ad hoc. Nightly, Sun-Thur
 HR - FTE Monitoring Report HRS Main Menu > UW HR Reports > FTE Monitoring  Lists employees with multiple jobs that total more than 1.0 FTE. Monthly on the night of the 1st

Ad Hoc Reports

These reports can be run Ad hoc at campuses. Where there is a corresponding KB, the report name links to that KB.

Report Query/Report Location Report Description
HR - Union Membership (SQR Report)

HRS Main Menu > UW HR Reports > Union Membership Report

Lists all employees with jobs in the union codes for the selected parameters. It does not reflect that they are dues paying members.
HR - Position Status Report
HRS Main Menu > UW HR Reports > Position Status Report Lists current position-related data for positions that meet the selected parameters, including Position Status.
Project Employee Report EPM Main Menu > Reporting Tools > Query > Query Viewer > UW_HR_838_PERPT 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.
Missing Address Report EPM Main Menu > Reporting Tools > Query > Query Viewer > UW_HR_840_MARPT Lists active employees whose Pay Basis is NOT equal to “N” (None-unpaid) and who do not have the selected address type (home or business).
Job List by Department EPM Main Menu > EPM Reports > HR Reports > Job List by Department Lists employees with active jobs for the selected parameters.
Person Lookup: HR - Search for Existing Person in EPM EPM Main Menu > EPM Reports > HR Reports > UW Person NS Lookup and UW Person Lookup 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.
HR - Expected Job End Date (EJED) Query
HRS Main Menu > Reporting Tools > Query > Query Viewer > UW_HR_EXPECTED_JOB_END_DATE Lists employees for whom the batch process will insert a termination row.
Document 17446 is unavailable at this time.
HRS Main Menu > Workforce Administration > Personal Information > Citizenship > Passport/Visa Exp Report Lists employees who have visas that expire for the Dept ID, Empl Class and From/To Date parameters selected.
HR - UW Probation Report (SQR Report)
HRS Main Menu > UW HR Reports > Probation Report Lists University Staff Ongoing (classified permanent) employees who are at the three-month and the five-month probation points in the probationary period. Also from Cypress the second of each month.
HR - University Staff Temporary (LTE) Hours Report
HRS Main Menu > UW HR Reports > 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. Also from Cypress after each classified confirm.
Over Max/Under Min
HRS Main Menu > UW HR Reports > Over Max Under Min Report Provides three options to compare the Comp Rate, the Min/Max and the Over Max and Under Min flags when Rate is: Over/Under and Flag not checked; within range and Flag is checked; Over/Under and Flag is checked. A Rate Over/Under with a Flag not checked is a nightly delivered report.
HR - FTE Monitoring Report
HRS Main Menu > UW HR Reports > FTE Monitoring Report Lists employees with multiple active jobs that total more than 1.0 FTE.
HR - Terminated Employee Report (Query Report)
HRS Main Menu > Reporting Tools > Query > Query Viewer > UW_HR_TER_EMPL  Records of terminated employees.


ADDITIONAL RESOURCES:

Related KBs: Related Links:
  • N/A



Keywords:find report EPM HCM Queries Query Reports HR Human Resources Audit Process Monitor Primary Job Audit Expected Job End Date EJED LTE Hours Report Overmax Undermin FTE Union Mailing Labels Query viewer Job List Department VISA New Hires Termed Terminations Term Duplicate Exception Override National ID Social Security ITIN UW Reporting ID WED Workflow Exception Dashboard   Doc ID:16700
Owner:Tami E.Group:Human Resource System (HRS)
Created:2011-01-30 18:00 CSTUpdated:2017-09-21 07:47 CST
Sites:Human Resource System (HRS)
Feedback:  0   5