University of California, Riverside

Human Resources Data Warehouse



Headcount of Career Staff by Ethnicity and Gender


This report will show a Headcount of staff employees (non academic) by Ethnicity Groups of White, Black, Hispanic (Latino, Mexican and Other Spanish), Asian (Chinese, Japanese, Filipino, Pakistani, Other Asian), American Indian and Unknown.) The report will also show a headcount by gender (Male, Female) and by ethnicity gender (White Males, Minority Males, Unknown Males, White Females, Minority Females, Unknown Females)

Both section of the report will also show a percentage of each ethnicity, gender and ethnicity gender. Counts from both parts can be shown by campus, organization within the campus, division within the organization, and department within division.

Using the Report Return to Top
In this report, the latest Fiscal Year and Accounting Period are selected by default.

Users may change the Fiscal Year Accounting Period and then further select Organization, Division, Department and Activity by clicking on the hour glass symbol next to each item.

Users may then click on OK and the report is generated on the web below. If users 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 ethnic code of the employee. Go to screen IAPP to check the personnel pgm type to determine what type of employee (PSS, MSP, SMG), add up FTE% for this employee and add that to an FTE count by PSS, MSP, SMG, and ethnic code, add 1 to a head count by PSS, MSP, SMG and ethnic code.

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

Query Builder - Section 1a
To reproduce Career Staff Workforce 1a - 1c in the Query Builder select from the following in the Criteria and the Columns tabs:

for the first (Ethnicity) section 1a Return to Top
Criteria Tab

Fiscal/Year section
- Fiscal Year
- Accounting Period

Scope section - Organization, Division, Department, Activity, and Employee

Employee Info section
- Employment Status Code equal to A, N or P

Appointment/Distribution section
- Under Title Code deselect Primary Title and select Appt. Title Code check box
- Appointment Type Code equal to 2, 7

Personal/Personnel Info section
- Ethnic Origin Code equal to F for White
- Ethnic Origin Code equal to A for Black
- Ethnic Origin Code equal to 5, E, or W for Hispanic
- Ethnic Origin Code equal to 2, B, L, R or X for Asian
- Ethnic Origin Code equal to C for American Indian
- Ethnic Origin Code equal to U for Unknown

Columns Tab

Employee section
- Check Primary Title Code (to be used to ID. Personnel Pgm in conjunction with Personnel Pgm Code)

Appointment section
- Check Title Code
- Select Personnel Pgm Code (to be used to ID. Personnel Pgm in conjunction with Primary Title Code)

Personal Info section
- Check Ethnic Origin Code

-Export the results of the query into Excel
-DROP rows where the Primary Title Code DOES not match the Title Code

-Use the table provided below to ID Personnel Pgm by Personnel Pgm. Code and Primary Title Code

for the second (Gender) section of 1b Return to Top
Criteria Tab

Fiscal/Year section
- Fiscal Year
- Accounting Period

Scope section
- Organization, Division, Department, Activity, and Employee

Employee Info section
- Employment Status Code equal to A, N or P

Appointment Distribution section
- Under Title Code deselect Primary Title and select Appt. Title Code check box
- Appointment Type Code equal to 2, 7

Personal/Personnel Info section
- Gender is equal to M for Male
- Gender is equal to F for Female

Columns Tab

Employee section
- Check Primary Title Code (to be used to ID. Personnel Pgm in conjunction with Personnel Pgm Code)

Appointment section
- Check Title Code
- Check Personnel Pgm Code (to be used to ID. Personnel Pgm in conjunction with Primary Title Code)

Personal Info section
- Check Sex Code

-Export the results of the query into Excel
-DROP rows where the Primary Title Code DOES not match the Title Code
-Use the table provided below to ID Personnel Pgm by Personnel Pgm. Code and Primary Title Code

for the third and final (Ethnicity/Gender) section of 1c Return to Top
Criteria Tab

Fiscal/Year section
- Fiscal Year
- Accounting Period

Scope section
- Organization, Division, Department

Employee Info section
- Employment Status Code equal to A, N or P

Appointment Distribution section
- Under Title Code deselect Primary Title and select Appt. Title Code check box
- Appointment Type Code equal to 2, 7

Persona/Personnel Info section
- Combine Ethnicity and Gender for any given Ethnicty and Gender
For an example, to get the headcount of White Male select Gender equal to M and Ethnicity equal to F

Columns Tab

Employee section
- Check Primary Title Code (to be used to ID. Personnel Pgm in conjunction with Personnel Pgm Code)

Appointment section
- Check Title Code
- Check Personnel Pgm Code (to be used to ID. Personnel Pgm in conjunction with Primary Title Code)

Personal Info section
- Check Ethnic Origin Code
- Check Sex Code

-Export the results of the query into Excel
-DROP rows where the Primary Title Code DOES not match the Title Code

-Use the table provided below to ID Personnel Pgm by Personnel Pgm. Code and Primary Title Code

Query Builder - Section 2a
To reproduce Career Staff Workforce 2a - 2c in the Query Builder select from the following in the Criteria and the Columns tabs:

for the first (Ethnicity) section of 2a Return to Top
Criteria Tab

Fiscal/Year section
- Fiscal Year
- Accounting Period

Scope section
- Organization, Division, Department, Activity, and Employee

Employee Info section
- Employment Status Code equal to A, N or P

Appointment/Distribution section
- Under Title Code uncheck Primary Title and check Appt. Title Code check box
- Select Appointment Type Code equal to 2, 7
- Select Occupational Group (Level 1)
For an example, to get White Librarians select Occ Subgroup (Level1) equal to 6

Personal/Personnel Info section
- Ethnic Origin Code equal to F for White
- Ethnic Origin Code equal to A for Black
- Ethnic Origin Code equal to 5, E, or W for Hispanic
- Ethnic Origin Code equal to 2, B, L, R or X for Asian
- Ethnic Origin Code equal to C for American Indian
- Ethnic Origin Code equal to U for Unknown

Columns Tab

Employee section
- Primary Title Code

Appointment section
- Check Title Code

Personal Info section
- Check Ethnic Origin Code
Note: In order to avoid duplicates do not select Occ. Group

-Export the results of the query into Excel
-DROP rows where the Primary Title Code DOES not match the Title Code

for the second (Gender) section of 2b Return to Top
Criteria Tab

Fiscal/Year section
- Fiscal Year
- Accounting Period

Scope section
- Organization, Division, Department, Activity, and Employee

Employee Info section
- Employment Status Code equal to A, N or P

Appointment/Distribution section
- Under Title Code deselect Primary Title and select Appt. Title Code check box
- Select Appointment Type Code equal to 2, 7
- Select Occupational Group (Level 1)
For an example, to get Librarians select Occ Subgroup (Level1) equal to 6

Personal/Personnel Info section
- Check Ethnic Origin Code
- Check Sex Code

Columns Tab

Employee section
- Primary Title Code

Appointment section
- Check Title Code

Personal Info section
- Check Sex Code
Note: In order to avoid duplicates do not select Occ. Group

-Export the results of the query into Excel
-DROP rows where the Primary Title Code DOES not match the Title Code

for the third and final (Ethnicity/Gender) section of 2c Return to Top
Criteria Tab

Fiscal/Year section
- Fiscal Year
- Accounting Period

Scope section
- Organization, Division, Department, Activity, and Employee

Employee Info section
- Employment Status Code equal to A, N or P

Appointment/Distribution section
- Under Title Code deselect Primary Title and select Appt. Title Code check box
- Select Appointment Type Code equal to 2, 7
- Select Occupational Group (Level 1)
For an example to get White Librarians select Occ Group equal to 6

Personal/Personnel Info section
- Combine Gender and Ethnicity for any given Ethnicity/Gender

Columns Tab

Employee section
- Primary Title Code

Appointment section
- Check Title Code

Personal Info section
- Check Ethnic Origin Code
- Check Sex Code
Note: - In order to avoid duplicates do not select Occ. Group

-Export the results of the query into Excel
-DROP rows where the Primary Title Code DOES not match the Title Code

Appointment Type & Primary Title Code settings for Personnel Pgm Return to Top

 

Career
SMG Personnel Pgm = 2; Primary Title Code < 0200 (Title Code to be grouped in Excel)
MSP Personnel Pgm = 2; Primary Title Code > 0199 (Title Code to be grouped in Excel)
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