University of California, Riverside

Human Resources Data Warehouse

Personnel List of Career Staff by Org/Division/Dept

This report will list career staff employees by employee. The report will list name, ID, title code, grade, salary, department, hire date, months of service, months in title code.

Using the Report Return to Top
In this report, the user chooses an Organization, Division, Department and/or Title Code by clicking on the hour glass symbol next to each item.

Users may then click OK and the report is generated on the web below. If users with to export the generated report to Excel then please click the Excel icon below the report selection drop down box.

PPS Screens
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: Return to Top
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 get name, hire date.
Then go to screen IAPP to get title code, grade, department, salary. Go to screen IPER to get months of service.

Repeat this iteration for each employee.

Query Builder - Return to Top
To reproduce Career Equity in the Query Builder select from the following in the Criteria and Columns tabs:

Criteria Tab

Fiscal Year/Period section
- This section is ignored

Employee Info section
- Select Employment Status Code equal to A

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

Columns Tab

Employee section
-Select Employee ID
- Select Hire Date Most Recent
- Select Home Department Code/Description
- Select First Name, Last Name
- Select Primary Title Code/Description
- Select Prior Service Months
- Select Employment Service Credit Months
- Select Service Credit Start Date

Appointment section
- Select Begin Date
- Select Pay Rate
- Select Rate Code
- Select Salary Grade

Export to Excel
To determine the Current Service:
- Add 3 columns: Today, Months and Curr. Svc.
- Today: Current Date
- Months formula: (Year(TODAY)-Year(HIRE DATE))*12+Month(TODAY)-Mont(HIRE DATE)
- Curr. Svc. Months: Divide Month (results) by 12 to get Current Service
Compare to that in the Report.

To determine Current Title:
Add 3 columns: Today, Month, and Curr. Title
- Today Current Date
- Month formula: (Year(TODAY)-Year(BEGIN DATE))*12+Month(TODAY)-Month(BEGIN DATE)
- Curr. Title: Divide Month (results) by 12 to get Current Title.
Compare to that in the Report

To determine Monthly Rate:
- Add 3 columns: Salary A, Salary H and Salary B
- Salary A formula: =if(rate code="A", pay rate/12, 0)
- Salary H formula: =if(rate code="H", pay rate*174, 0)
- Salary B formula: =if(rate code+"B", pay rate, 0)
Compare the results with those in the Report Monthly Rate

The Report has a few extra columns than the Query Builder provided to verify the UCR Net ID, Emp phone, Emp E-mail and Emp Working Title  please reference the UCR Enterprise Directory.

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