HR - HR Report List

GENERAL DESCRIPTION:

This job aid contains a list of 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

HR - 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 Reports  Lists employees with multiple jobs that total more than 1.0 FTE. Monthly on the night of the 1st

HR - Ad hoc

These reports can be run ad hoc at campuses.

Report Query/Report Location Report Description Notes
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 (SQR 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 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 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 Code & Rate History EPM Main Menu > Reporting Tools > Query Viewer > UW_HR_JOBCODE_RATEHIST Displays job code and rate history for every job a person has held in legacy and HRS. Similar to legacy APRH.
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 Query
HRS Main Menu > Reporting Tools > Query Viewer > UW_HR_EXPECTED_JOB_END_DATE Lists employees for whom the batch process will insert a termination row.
HR - Passport/Visa Exp Report (SQR Report)
HRS Main Menu > Workforce Administration > Personal Information > Citizenship > Report, 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. The Over Max/Under Min report is also available through the Workflow Exception Dashboard (WED). See HR - WED - UW_HR_OVERMAX_UNDERMIN Query.
HR - Missing Adj Cont Svc Dt Report (Query Report)
HRS Main Menu > Reporting Tools > Query Viewer > UW_HR_674_MACSDR Lists University Staff Ongoing (classified permanent) employees for whom the Adjusted Continuous Service Date is blank. This report is also available on the Workflow Exception Dashboard (WED). See HR - Missing Adj Cont Svc Dt Report (Query 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.
HRS HR- Termed Employee(Query Report)  HRS Main Menu > Reporting Tools > 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   Doc ID:16700
Owner:Tami E.Group:Human Resource System (HRS)
Created:2011-01-30 19:00 CDTUpdated:2017-02-24 16:07 CDT
Sites:Human Resource System (HRS)
Feedback:  0   5