HR - HR Report List

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

Procedure At-a-Glance

Category: HR Reports and Audits Inventory
Audience: Service Center and HR Professionals
Overarching Process: Maintain work force.
Navigation: see below
Jump to Procedure Steps (below)
Jump to Related Policies/Job Aids (below)

General Description

This Job Aid is a listing of HR Reports and Queries, their respective navigation paths, and a description of the report as well as schedule.

Process Inputs

Process Inputs will vary by each Query or Report being run. Examples include Department ID, Job Code, Employee Status, Employee Class, Emplid, Position Number and Business Unit - this is not an all inclusive listing of report process inputs.

Process Outputs

Process Outputs will vary by each Query or Report being run. Examples of fields include Emplid, Person Name, Department ID, Job Code/Job Title, Location, Business Unit, Employee Class, Annual Salary, Hourly Salary, Employee Status and Address - this is not an all inclusive listing of all fields that could be on the output.

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.

Exceptions (including first-year considerations)

It should be noted that the reports listed below may or may not contain all information requested due to the conversion of data from Legacy IADS into HRS (this will pertain to EPM reporting). There may be gaps of information.


HR Reports/Queries

Service Center - Audit Queries

These queries and reports (found in HRS) are run at the Service Center for audit purposes. The Service Center will then contact campuses, if additional information or correction is necessary. Campuses can also run these queries adhoc for their own campuses.

Report Query/Report Location Report Description Delivery Frequency
HR - Unclass Hourly FLSA Exempt (Query Report)
HRS Main Menu > Reporting Tools > Query Viewer > UW_HR_UNCLS_HOURLY_EXMPT_AUDIT Provides a list of unclassified jobs with Pay Basis = H (Hourly) and FLSA Status = E (Exempt). Nightly Query Sunday-Thursday
Document 17424 is unavailable at this time.
HRS Main Menu > Reporting Tools > Query Viewer > UW_HR_UNCLS_HRLY_STD_HRS_GT_01 Provides a list of unclassified jobs with Pay Basis = H (Hourly) and Standard Hours > .01 Nightly Query Sunday-Thursday
Empl Class Change Audits (HR - Posn Empl Class Change Audit (Query Report) and HR - Job Empl Class Change Audit (Query Report) ) HRS Main Menu > Reporting Tools > Query Viewer > UW_HR_POSN_EMPL_CLASS_AUDIT
or UW_HR_JOB_EMPL_CLASS_AUDIT
Audit Position Data or Job Data where Empl Class was changed. Nightly Query Sunday-Thursday
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. Weekly Query - Tuesday nights
HR - Primary Job Audit (SQR Report)
HRS Main Menu > Workforce Administration > Workforce Reports > Primary Job Audit List discrepancies in the primary job designation for employees with multiple jobs: Multiple Primary Jobs, Terminated Primary Jobs, and No Primary Job. Nightly Sunday-Thursday
 HR - Min/Max by Jobcd (Query Report) HRS Main Menu > Reporting Tools > Query Viewer > UW_HR_JOBCD_MIN_MAX Lists the minimum and maximum compensation rates for a specific job code.  

HR - Cypress Delivered Reports

These reports will be delivered to an HR Administrator's Cypress inbox. They can also be run adhoc.

Report Query/Report Location Report Description Delivery Frequency
Expected Job End Date (EJED) Termination Report   N/A Lists all those 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
Document 17467 is unavailable at this time.
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 - Adhoc

These reports can be run adhoc at campuses.

Report Query/Report Location Report Description Delivery Frequency
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.
Document 17456 is unavailable at this time.
HRS Main Menu > Workforce Administration > Personal Information > Biographical > Mailing Labels Report Produces a three-across set of mailing labels for employees with the selected parameters. This is a Crystal report, and the server name of PSUNX should be selected for Crystal reports.
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.
Document 18017 is unavailable at this time.
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.
Document 17467 is unavailable at this time.
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 - 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.
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.
Document 17438 is unavailable at this time.
HRS Main Menu > Reporting Tools > Query Viewer > UW_HR_ACTIVE_INACTIVE_LIST Lists the current position-related data for active positions, inactive positions, or both, depending on which parameter(s) you select to run the report.
Document 17467 is unavailable at this time.
HRS Main Menu > Reporting Tools > Query Viewer > UW_HR_JOBCD_MIN_MAX Displays the minimum and maximum of a pay range for a Job Code. For unclassified titles, the first digit of the Salary Plan identifies the campus and the fourth digit of the Salary Plan identifies "A" or "C" basis; the first digit of the Grade identifies a System (S), Institution (I) or Extraordinary (0) range. The user may enter a wildcard % value in the prompt.
HRS HR - New Job List (Query Report)  HRS Main Menu > Reporting Tools > Query Viewer > UW_HR_849_NJL_SEN List of hire, rehire, or transferred jobs within selected period. Including gender and heritage.  
HRS HR- Termed Employee(Query Report)  HRS Main Menu > Reporting Tools > Query Viewer > UW_HR_TER_EMPL  Records of terminated employees through the auto-termination process.  

HR - External to Service Center

These reports meet federal reporting requirements.

Report Query/Report Location Report Description Delivery Frequency
Document 17448 is unavailable at this time.
HRS Main Menu > Workforce Monitoring > Meet Regulatory Reqmts > Regulatory Reports > PRWORA-New Hire Provides the information required by the State Department of Workforce Development when a new employee begins work or an existing employee who has been off the payroll for 90 days or more returns to work. Tuesday nights for pay dates in the current week (Sunday-Saturday)

HR - Internal to Service Center

These reports will be run and maintained by the Service Center. Theses reports are Service Center roles/security.

Report Query/Report Location Report Description Delivery Frequency
Locate Duplicate Employees Report EPM Main Menu > EPM Reports > HR Reports/Locate Duplicate Employees Rep Lists possible duplicate employee records. Nightly Sunday-Thursday
Cypress
HR - Position Exception or Override Report (SQR Report) (audit Position and Job data mismatches) HRS Main Menu > Organizational Development > Position Management > Position Reports > Exception/Override Audits the data within fields that match in the Position Data and the current incumbent Job Data. The Exception report will list instances where the position data and incumbent job are out of sync. The Override report will list incumbent data that was not automatically cross-updated. Weekly Tuesday nights
Process Manager
Document 17434 is unavailable at this time.
HRS Main Menu > Reporting Tools > Query Viewer > UW_HR_NID_AUDIT Checks that the primary ID indicator is not all 9s, UWRPT and ITIN are valid formats,PR (SSN) is not 9s/not blank and not primary, National ID is not blank. Nightly Sunday-Thursday
Process Manager

Related Policies

  • N/A

Related Jobaids




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 18:00 CSTUpdated:2016-12-19 14:13 CST
Sites:Human Resource System (HRS)
Feedback:  0   4