University of California, Riverside

Human Resources Data Warehouse



Index of Columns


A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

A

Account Number - Distribution tab, FAU section

Activity Code - Distribution tab, FAU section

AD&D Coverage Code - Benefits tab, Welfare section

AD&D Coverage Effective Date - Benefits tab, Welfare section

Address-Campus-Building - Personnel tab, Contact section

Address-Campus-Campus-Name - Personnel tab, Contact section

Address-Campus-Room - Personnel tab, Contact section

Address-Local/Foreign Code - Personal tab, Address Info section

Address-Permanent-City - Personal tab, Address Info section

Address-Permanent-Foreign Country Code - Personal tab, Address Info section

Address-Permanent-Foreign-Postal Code - Personal tab, Address Info section

Address-Permanent-Foreign Providence - Personal tab, Address Info section

Address-Permanent-Line One - Personal tab, Address Info section

Address-Permanent-Line Two - Personal tab, Address Info section

Address-Permanent-State - Personal tab, Address Info section

Address-Permanent-Zip - Personal tab, Address Info section

Age on January 1 - Personal tab, Personal Info section

Appointment Number - Appointment tab

Appointment Type Code - Appointment tab

Average Hours Worked Per Week - Hours tab

Top of Page

B

Begin Date - Appointment tab

Benefits Eligibility Date - Benefits tab, Eligibility section

Benefits Eligibility Level Indicator-Assigned - Benefits tab, Eligibility section

Benefits Eligibility Level Indicator-Derived - Benefits tab, Eligibility section

Bargaining Unit Code - Labor Relations tab

Top of Page

C

Campus Phone-One - Personnel tab, Contact section

Campus Phone-Two - Personnel tab, Contact section

Citizenship Status Code - Personnel tab, Citizenship section

Compensatory Time Hours Balance - Current - Hours tab

Corporate Card Status Effective Date - Personnel tab, Corporate Card section

Corporate Card Type Code - Personnel tab, Corporate Card section

Corporate Credit Card Status Code - Personnel tab, Corporate Card section

Cost Center - Distribution tab, FAU section

Country of Residency - Personnel tab, Citizenship section

Current Month Hours on Pay Status - Hours tab

Top of Page

D

Date of Birth - Personal tab, Personal Info section

DCP Plan Code - Benefits tab, Retirement/Tax Deferred section

Dental Care Provider - Benefits tab, Health section

Dental Plan Code - Benefits tab, Health section

Dental Plan Coverage Code -Benefits tab, Health section

Dental Plan Coverage Eff Date-Dependent - Benefits tab, Health section

Dental Plan Coverage Eff Date-Employee - Benefits tab, Health section

Department Code - Appointment tab

Dependent Date of Birth - Benefits tab, Dependent Data section

Dependent Disabled Code - Distribution tab, Payroll Distribution section

Dependent Life Coverage Effective Date - Distribution tab, Payroll Distribution section

Dependent Life Insurance Plan Code - Distribution tab, Payroll Distribution section

Dependent Name -Distribution tab, Payroll Distribution section

Dependent Number - Distribution tab, Payroll Distribution section

Dependent Relationship To Employee Code -Distribution tab, Payroll Distribution section

Dependent Sex Code -Distribution tab, Payroll Distribution section

Distribution Begin Date - Distribution tab, Payroll Distribution section

Distribution Department Code - Distribution tab, Payroll Distribution section

Distribution End Date -Distribution tab, Payroll Distribution section

Distribution Number -Distribution tab, Payroll Distribution section

Distribution Pay Rate -Distribution tab, Payroll Distribution section

Distribution Unit Code -Distribution tab, Payroll Distribution section

Distribution Percent -Distribution tab, Payroll Distribution section

Div Code - Distribution tab, Organization Info

DOS Code - Distribution tab, Payroll Distribution section

Duration of Appt. Code - Appointment tab

Top of Page

E

Employee ID - Employee tab, General section

Employment Status Code - Employee tab, General section

Employment Service Credit Months - Employee tab, Retirement section

Employment Service Credit Start Date - Employee tab, Retirement section

End Date - Appointment tab

Employee Paid Disability Coverage Eff Date - Benefits tab, Welfare section

Employee Paid Disability Salary Base - Benefits tab, Welfare section

Employee Paid Disability Waiting Period - Benefits tab, Welfare section

Employee DIstribution Unit - Labor Relations tab

Employee Relations Code - Labor Relations tab

Employee Representation Code - Labor Relations tab

Employee Special Handling Code - Labor Relations tab

Employee Unit Code - Labor Relations tab

Ethnic Origin Code - Personal tab, Personal Info section

Top of Page

F

Federal Withholding Tax Gross YTD - Payroll tab

FICA Eligibility Code - Employee tab, Retirement section

Financial Aid Fiscal Year - Student tab, Work Study section

First Name - Employee tab, General section

Fiscal Year - Employee tab, Fiscal Year/Period section

Fixed/Variable Indicator - Appointment tab

Function - Distribution tab, FAU section

Fund Number - Distribution tab, FAU section

Top of Page

G

Top of Page

H

Hire Date-Most Recent - Employee tab, General section

Hire Date-Original - Employee tab, General section

Home Department Code-Alternate - Employee tab, General section

Home Department Code - Employee tab, General section

Home Phone Number - Personal tab, Personal Info section

Hours Towards Benefits Eligibility - Hours tab

Hours Towards Career Eligibility - Hours tab

Top of Page

I

Top of Page

J

Job Group Identifier - Employee tab, General section

Top of Page

K

Top of Page

L

Last Name - Employee tab, General Section

Last Sabbatical Credit Balance - Personnel tab, Sabbatical section

Layoff Seniority Credit Prior Balance Hours - Personnel tab, Layoff section

Layoff Seniority Credit Regular Hours - Personnel tab, Layoff section

Layoff Seniority Credit Title Code - Personnel tab, Layoff section

Layoff Seniority Credit Title Unit Code - Personnel tab, Layoff section

Layoff Title Code - Personnel tab, Layoff section

Layoff Unit Code - Personnel tab, Layoff section

Leave Accrual Code - Leave tab, Leave section

Leave of Absence Code-Current - Leave tab, Leave of Absence section

Leave of Absence Type Code - Leave tab, Leave of Absence section

Leave of Absence-Begin Date - Leave tab, Leave of Absence section

Leave of Absence-Return Date - Leave tab, Leave of Absence section

Legal Plan Code - Benefits tab, Welfare section

Legal Plan Coverage Code - Benefits tab, Welfare section

Legal Plan Coverage Eff Date-Dependent - Benefits tab, Welfare section

Legal Plan Coverage Eff Date-Employee -Benefits tab, Welfare section

Legal Plan Coverage Effective Date - Benefits tab, Welfare section

License/Certificate Code - Personnel tab, Corporate Card section

License/Certificate Renewal Date - Personnel tab, Corporate Card section

Life Insurance Coverage Effective Date - Benefits tab, Welfare section

Life Insurance Coverage-UC Paid - Benefits tab, Welfare section

Life Insurance Plan Code - Benefits tab, Welfare section

Life Insurance Salary Base - Benefits tab, Welfare section

Top of Page

M

Medical Care Provider - Benefits tab, Health section

Medical Plan Code - Benefits tab, Health section

Medical Plan Coverage Code - Benefits tab, Health section

Medical Plan Coverage Eff Date-Dependent - Benefits tab, Health section

Medical Plan Coverage Eff Date-Employee - Benefits tab, Health section

Medicare Gross-YTD - Payroll tab

Merit Percent - Personnel tab, Salary section

Top of Page

N

Name-Employee - Employee tab, General section

Name-Employee-Prior - Employee tab, General section

Next Salary Review Date - Personnel tab, Salary section

Next Salary Review Typecode -Personnel tab, Salary section

Non-Resident Alien Tax Form Indicator - Personnel tab, Citizenship section

Number of Registered UC Student Units - Student Tab, Student section

Top of Page

O

Oasdi Gross-YTD - Payroll tab

Off/Above Scale Indicator - Distribution tab, Payroll Distribution section

Org Code - Distribution tab, Organization Info section

Other State With. Tax-Calif Residency Code - Personnel tab, Citizenship section

Top of Page

P

Paid Time off Hours Balance-Current - Leave tab, Leave section

Pay Basis-Paid Over Months - Appointment tab

Pay Basis-Service Months - Appointment tab

Pay Disposition Code - Employee tab, General section

Pay Rate - Appointment tab

Pay Schedule Code - Appointment tab

Percent Fulltime - Appointment tab

Preferential Rehire Period Begin Date - Personnel tab, Layoff section

Preferential Rehire Period End Date - Personnel tab, Layoff section

Preferential Rehire Rights-Suspension End Date - Personnel tab, Layoff section

Preferential Rehire Rights-Term./Suspend Date - Personnel tab, Layoff section

Preferential Rehire Susp./Termination Reason - Personnel tab, Layoff section

Perquisite Type Code - Distribution tab, Payroll Distribution section

Period - Employee tab, Fiscal Year/Period

Personnel Program Code - Appointment Code

Primary Beli Status Qualification Code - Benefits tab, Eligibility section

Primary Beli Status Qualification Eff Date - Benefits tab, Eligibility section

Primary Title Code - Employee tab, General section

Prior Service Code - Employee tab, General section

Prior Service Months - Employee tab, General section

Project Code - Distribution tab, FAU section

Project Code Corp (Not in Use) - Distribution tab, FAU section

Probationary Period End Date - Employee tab, General section

Top of Page

Q

Qtr/Sem As Teaching Assistant - Personnel tab, Sabbatical section

Qtr/Sem In Unit 18 - Personnel tab, Sabbatical section

Qtr/Sem/Mos In 8-Year Rule - Personnel tab, Sabbatical section

Overtime Hours Worked YTD - Hours tab

Top of Page

R

Rate Code - Appointment tab

Regular Hours Worked YTD - Hours tab

Representation Code - Appointment tab

Retirement System Code - Employee tab, Retirement section

Retirement/FICA Derivation Indicator - Employee tab, Retirement section

Retirement Gross YTD - Payroll tab

Top of Page

S

Sabbatical Credit Accrued - Personnel tab, Sabbatical section

Sabbatical Credit Accrued Through Date - Personnel tab, Sabbatical section

Sabbatical Credit Balance Total - Personnel tab, Sabbatical section

Sabbatical Credit Date - Personnel tab, Sabbatical section

Sabbatical Credit Used - Personnel tab, Sabbatical section

Safe Harbor Gross-YTD - Payroll tab

Salary Grade - Appointment tab

Salary Step - Distribution tab, Payroll Distribution section

Secondary Beli Status Qualification Code - Benefits tab, Eligibility section

Secondary Beli Status Qualification Eff Date - Benefits tab, Eligibility section

Separation Date - Employee tab, Separation section

Separation Destination Code - Employee tab, Separation section

Separation-Last Day on Pay Status - Employee tab, Separation section

Separation Reason Code - Employee tab, Separation section

Sex Code - Personal tab, Personal info section

Sick Leave Hours Balance-Current - Leave tab, Leave section

Sick Leave Maximum Hours-Normal - Leave tab, Leave section

Special Training Required Code - Personnel tab, Training section

Staff Salary Review Action - Personnel tab, Salary section

Staff Salary Review Date - Personnel tab, Salary section

Staff Salary review Status - Personnel tab, Salary section

State Withholding Tax Gros YTD - Payroll tab

Surepay Bank Table Key - Personal tab, Personal Info section

Top of Page

T

Tax Treaty Article Number - Personnel tab, Citizenship section

Tax Treaty End Date - Personnel tab, Citizenship section

Tax Treaty Gross YTD - Personnel tab, Citizenship section

Tax Treaty Gross YTD-Employee - Payroll tab

Tax Treaty Income Code - Personnel tab, Citizenship section

Tax Treaty Limit - Personnel tab, Citizenship section

Terminal Compensatory Time Period - Leave tab, Leave section

Terminal Sick Leave Balance - Leave tab, Leave section

Terminal Vacation Leave Paid - Leave tab, Leave section

Time Reporting Code - Appointment tab

Title Code - Appointment tab

Title Unit Code - Appointment tab

Total Gross YTD - Payroll tab

Total Hours On Pay Status YTD - Hours tab

Top of Page

U

UC Paid Life Insurance Coverage Effective Date - Benefits tab, Welfare section

UC Paid Temporary Disability Insurance Code - Benefits tab, Welfare section

UC Student Status Code - Student tab, Student section

UCRS Eligibility Date - Benefits tab, Retirement/Tax Deferred section

UCTD Insurance Plan Coverage Effective Date - Benefits tab, Retirement/Tax Deferred section

Top of Page

V

Vacation Leave Hours Balance-Current - Leave tab, Leave section

Vacation Leave Maximun Hours-Normal - Leave tab, Leave section

Veteran Disability Status Code - Personal tab, Personal Info section

Veteran Status Code - Personal tab, Personal Info section

Visa Type Code - Personnel tab, Citizenship section

Visa/Work Permit End Date - Personnel tab, Citizenship section

Vision Plan Code - Benefits tab, Health section

Vision Plan Coverade Code - Benefits tab, Health section

Vision Plan COverage Eff Date-Dependent - Benefits tab, Health section

Vision Plan COverae Eff Date-Employee - Benefits tab, Health section

Top of Page

W

Work Study Department Code - Student tab, Work Study section

Work Study Fiscal Year - Student tab, Work Study section

Work Study Fytd Gross - Student tab, Work Study section

Work Study Limit - Student tab, Work Study section

Work Study Limit-Last Change Date - Student tab, Work Stucy section

Work Study Limit-Prior - Student tab, Work Study section

Work Study Program Code-Distribution - Distribution tab, Payroll Distribution section

Work Study Program Code-Financial Aid - Student tab, Work Study section

Wtr/Sem/Mos Extension to 8-Year Rule - Personnel tab, Sabbatical section

Top of Page

X

Top of Page

Y

Top of Page

Z

Top of Page

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