University of California, Riverside

Human Resources Data Warehouse



Separation Counts of Career Staff by Personnel Program and Org Unit


This report will show a count of career staff employees who have separated from UCR. The report will show the number of Senior Management (SMG), Management And Senior Professionals (MSP), and Professional and Support Staff (PSS) and the total of all three 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.
The report also has a second part that will show the same Information as above but it will show by department Within 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, Department, 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 personnel pgm type to determine what type of employee (PSS, MSP, or SMG). Add 1 to the count by PSS, MSP, or SMG for each separated employee.

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

Query Builder - Section 1a Return to Top
To reproduce Career Staff Personnel Program 1a in the Query Builder select from the following in the Criteria and the Columns tabs:

Criteria Tab

Fiscal/Year section
- This section is ignored even if you specify a Fiscal Year and Accounting Period
- The Separation Date specified is used instead

Scope section
- Specify 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
- Select Personnel Program Code according to the table provided below (MSP and SMG are trimmed according to the chart table below)

Columns Tab

Employee section
- Select Primary Title Code (to trim Personnel Pgm.)
- Select Separation Date

Appointment section
- Select Appointment Type Code/Description

Query Builder - Headcount for each ORG Return to Top
Criteria Tab

Fiscal Year/Period section
- Specify the relevant FY and Accounting Period

Scope section
- Specify an Organization Code

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

Appointment/Distribution Info section
- Select Appointment Type Code equal to 2, 7
- Clear Personnel Pgm Code

Headcount for 12 month cumulative must be done for each month in that year then divided by 12. For example the Report Year is 5/01/2006-04/30/2007 FY 2007 AP April. Get the headcount for April, then go back a month to March to get the headcount for that month. Be sure to stay within the Fiscal Year. Add up the 12 months then divide by 12 to get that ORG's headcount average.

Repeat the steps for each Org Code

Query Builder - Section 2b Return to Top
To reproduce Career Staff Personnel Program 2b in the Query Builder select from the following in the Criteria and the Columns tabs:

Criteria Tab

Fiscal/Year section
- This section is ignored in even if you specify a Fiscal Year and Accounting Period
- The Separation Date specified is used instead

Scope section
- Specify Organization Code
- Specify the Department Code

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

Appointment/Distribution section
- Select Appointment Type Code equal to 2,7
- Select Personnel Program Code according to the table provided below (MSP and SMG are trimmed according to the chart table below)

Columns Tab

Employee section
- Select Primary Title Code (for trimming Personnel Pgm. in Excel)
- Select Separation Date

Appointment section
- Select Appointment Type Code/Description

Repeat the steps for each Department in the Org

Query Builder - Headcount for each Dept in the ORG Return to Top
Criteria Tab

Fiscal Year/Period section
- Specify the relevant FY and Accounting Period

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

Appointment/Distribution Info section
- Select Appointment Type Code equal to 2, 7
- Clear Personnel Pgm Code

Headcount for 12 month cumulative must be done for each month in that year then divided by 12. For example the Report Year is 5/01/2006-04/30/2007 FY 2007 AP April. Get the headcount for April, then go back a month to March to get the headcount for that month. Be sure to stay within the Fiscal Year. Add up the 12 months then divide by 12 to get that ORG's headcount average.

Repeat the steps for each ORG/Dept Code

Return to Top

Personnel Program Code & Primary Title Code settings for Appointment/Distribution Info section

SMG Personnel Pgm = 2; Title Code <0200
MSP Personnel Pgm = 2; Title Code > 0199
PSS Personnel Pgm = 1

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