University of California, Riverside

Human Resources Data Warehouse



HRDW Reports


Understanding HRDW Reports

HRDW contains several pre-defined reports created at the direction of Human Resources. These reports are designed to answer many of the questions commonly asked by UCR departments and organizations wishing to better understand the characteristics and attributes of their workforce. Below is a brief summary of each of the reports currently within HRDW. Please click on the links on the left for a more detailed description of the various reports, as well as information on the PPS data used to generate the report. Also included are instructions on how to reproduce the report using the Query Builder.

Headcount/FTE by Appointment Type This report provides a count of employees (staff and academic) by headcount and full time equivalent (FTE), for each appointment type and personnel program.  

Headcount/FTE by Bargaining Unit  This report provides a count of employees (staff and academic) by headcount and full time equivalent (FTE), for each appointment type and bargaining unit.  

Headcount of Career Staff by Ethnicity and Gender This report provides a count of career employees (staff employees only) by ethnicity, gender, personnel category and occupational groups.

Personnel List Summed by Appointment Percentage This report generates a list of employees (staff and academic) with an appointment matching the organization, division, or department selected.  All appointment types are included and the appointments are reported based on the sum of the appointment percentage.

This report calculates a count of career staff employees and the average salary by Appointment Type, Age,  Gender, and Ethnicity.

Personnel List Summed by Distribution Percent  This report generates a list of employees (staff and academic) with an appointment matching the organization, division, or department selected.  This report differs from the Personnel List summed by Appointment Percent in that Distribution Percent, Distribution Pay Rate, Distribution DOS, and Distribution Number fields are included in this report.  

This report calculates a count of career staff employees and the average salary by Appointment Type, Age,  Gender, and Ethnicity.

Separation Counts of Career Staff by Personnel Program and Org Unit  This report provides a count of career separations (staff employees only) for a single month or a 12 month cumulative period. 

Separation Counts of Career Staff by Bargaining Unit  This report provides a count of career separations (staff employees only) for a single month or a 12 month cumulative period by bargaining unit.  For a 12 month cumulative period, the report will show a turnover ratio for each bargaining unit.

Separation List of Career Staff by Title Unit Code  This report provides a list of career employees who have separated (staff employees only) for a single month period or a 12 month cumulative period for the selected Title Unit Code (also referred to as bargaining unit). 

Separation Counts of Career Staff by Organization and Ethnic Code    This report provides a count of career separations (staff employees only) for a single month or a 12 month cumulative period by ethnic code and organizational unit.  For a 12 month cumulative period, the report will show a turnover ratio for each ethnic code.

Personnel List of Career Staff by Org/Division/Dept  This report provides a list of career employees (staff employees only) within the selected organization/division/department.  Employee-related data elements such as home department, title code description, hire date, service credit, UCR Net Id, email address, supervisor name, and working title are reported.

 

More Information 

General Campus Information

University of California, Riverside
900 University Ave.
Riverside, CA 92521
Tel: (951) 827-1012

Department Information

Computing & Communications
Computing & Communications Bldg.

Tel: (951) 827-3555
Fax: (951) 827-4541
E-mail: helpdesk@ucr.edu

Footer