University of California, Riverside

Human Resources Data Warehouse



Separation Counts of Career Staff by Bargaining Unit


This report will show a count of career staff employees who have separated from UCR. The report will show A headcount of separated employees by bargaining Units, and the total of all bargaining units by organization unit.

The report will also show a turnover ratio which is the total number of employees who separated divided by the total number of career staff headcount employees for the organization unit.

*NOTE: If department is reorganized into a different Organizational Unit since separation then the separation/turnover count will be reflected in the new Organizational Unit.

Using the Report Return to Top
In this report, Report Type of 1 Month Snap Shot is selected by default.

You may change the Report Type to 12 Month Cumulative and then further enter the Report Date in the mm/dd/yyyy format.

Finally click on OK and the report is generated on the web below. If you wish to export the generated report to Excel then please click on the Excel Icon below the report selection drop down box.

PPS Screens Return to Top
The PPS screens are organized so that an individual employee's data can be obtained by entering the employee's name or ID. To verify the data on the data warehouse reports using the PPS screens, each employee's name or ID from a group of employees(by org code or department, or division or activity) must be entered and each PPS screen listed must be interrogated. A count must be kept for each employee in order to summarize the counts and compare the counts to the counts of each report.

PPS Screens:
IGEN - Shows ethnic codes, employee status, sex code, hire date, separation date and other general information
IAPP - Shows Appointment and Distribution Data, this screen has FTE %, appointment
Type, grade, personnel program type, FAU, home department, bargaining unit
IPER - Shows employment service credit months

To reproduce this report in PPS go to screen IGEN and enter the employee id or employee name to get the separation date. Go to screen IAPP to check the TUC (title unit code) to determine what bargaining unit the employee is in. Add 1 to the count by bargaining unit for each separated employee.

Repeat this iteration for each employee in the group of employees that you have selected.

Query Builder - Return to Top

To reproduce Career Staff Turnover by Bargaining Unit  in the Query Builder select from the following in the Criteria and the Columns tabs:
Criteria Tab

*Unable to reproduce 12 month results for FY 2006 Report does not go back that far.

Fiscal Year/Period section
- This section is ignored even if you specify a Fiscal Year and Accounting Period (only used for the headcount)
- The Separation Date specified is used instead

Scope section
- Specify an Organization Code

Employee Info section
- Select Employment Status Code equal to S
- Specify the separation date criteria

Appointment/Distribution section
- Select Appointment Type Code equal to 2,7

Columns Tab

Employee section
- Select Separation Date

Appointment section
- Select Title Unit Code

Repeat the steps for each Org Code

Query Builder - Headcount for 1 month snapshot Return to Top
To reproduce 1 month headcount in the Query Builder select from the following in the Criteria and the Columns tabs:

Criteria Tab

Fiscal Year/Period section

- Select the relevant FY and Accounting Period

Scope section
-Clear Organization Code

Employee Info section
- Select Employment Status Code equal to A, N, P
- Clear Separation Date Range

Appointment/Distribution section
- Select Appointment Type Code equal to 2, 7

Columns Tab

Appointment section
- Select Title Unit Code

Query Builder - Headcount for 12 month cumulative Return to Top
(Must be done on a month to month basis using AP in the query.)

Criteria Tab

Fiscal Year/Period section

- Select Fiscal Year
- Select Accounting Period
For example the Report Year is 05/01/2006-04/30/2007 (FY 2007 AP April). Start with April in the Query to get the headcount for Title Unit Code 87. Then go back a month to March and do the same thing.

Employment Info section
- Select Employment Status Code equal to A, N, P
- Clear Separation Date Range

Appointment/Distribution section
-Select Appointment Code equal to 2, 7

Columns Tab

Appointment section
- Select Title Unit Code

Add up the yearly headcount for that Title Unit Code and Divide it by 12 to get the 12 month cumulative headcount for that Title Unit Code. Match it to the Title Unit Code headcount in the Report to confirm.

Return to Top

 

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