CPS Data Dictionary

System Number:

CPS0769

User Access Name:

CACAPTBAS

Name:

ACADEMIC APPOINTMENT BASIS CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating the period of appointment associated with the title code.

Code Interpretation:

' ' - Not applicable

'0' - Not appplicable

'1' - 9 month

'2' - 10 month

'3' - 12 month

'4' - 12 month/Health Science Compensation Plans

'5' - Summer session

Comments:

Source - UTCS

Level - Appointment

Summer Research = CACAPTBAS eq '1' and CACPAYPER eq '1'

Revision Date:

June 13, 2003

System Number:

CPS0770

User Access Name:

CACAPTTYP

Name:

ACADEMIC APPOINTMENT TYPE CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating the status of an academic appointment.

Code Interpretation:

' ' - Not applicable

'0' - Not applicable

'1' - Regular and Adjunct

'2' - Acting

'3' - Visiting

'4' - Recalled

'5' - Emeritus

Comments:

Source - UTCS

Level - Appointment

Revision Date:

System Number:

CPS0774

User Access Name:

CACPAYPER

Name:

ACADEMIC PAY PERIOD CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating the portion of the annual salary which is paid monthly.

Code Interpretation:

' ' - Not applicable

'0' - Not applicable

'1' - Monthly payment equals 1/9 annual salary

'2' - Monthly payment equals 1/12 annual salary

'3' - Monthly payment equals 1/10 annual salary

Comments:

Source - UTCS

Level - Appointment

Summer Research = CACAPTBAS eq '1' and CACPAYPER eq '1'

Revision Date:

April 8, 2014

System Number:

CPS0775 

User Access Name:

CACRANK

Name:

ACADEMIC RANK CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating the academic rank to which the title code is assigned.

Code Interpretation:

' ' - Not applicable

'0' - Not applicable

'1' - Maximum rank

'2' - Associate

'3' - Assistant

'4' - Instructor/Junior

Comments:

Source - UTCS

Level - Appointment

Revision Date:

System Number:

CPS0799A

User Access Name:

ACADSEN

Name:

Academic Senate Flag

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Flag indicating whether the title is an Academic Senate title.

Code Interpretation:

Y - Academic Senate membership

blank - no Academic Senate membership

Comments:

Source - Defined

Level - Appointment

Titles with a CCTOB code with "1' in the second position are Academic Senate titles. There are also 24 individual non-academic title codes which are also members of the Academic Senate, including 0001 - President, 0030 - Chancellor, 0040 - University Provost, etc.

Revision Date:

July 15, 2004

System Number:

CPS0807

User Access Name:

ACSVCLIM

Name:

ACADEMIC SERVICE LIMIT

Type:

NUMERIC

Length:

2

Format:

nn

General Description:

The maximum number of years that an individual can serve in a particular title.

Code Interpretation:

N/A

Comments:

Source - UTCS

Level - Appointment

For many titles, the service limit applies to service in a combination of titles, as well as to service in a single title. For the Professor in Residence series and Adjunct Professor series, the service limits apply only if state funding is used. For some titles, the service limit applies only to individuals appointed at greater than 50 percent time. (Campus procedures may be more restrictive with respect to service limitations than Systemwide policy.)

Revision Date:

System Number:

CPS0768

User Access Name:

ACSICKELIG

Name:

ACADEMIC SICK LEAVE ELIGIBILITY CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating whether an individual is eligible to accrue sick leave credit based on his/her appointment title.

Code Interpretation:

'Y' - Academic eligible to accrue sick leave credit

'N' - Academic not eligible to accrue sick leave credit

' ' - Not applicable

Comments:

Source - UTCS

Level - Appointment

Revision Date:

System Number:

CPS0161

User Access Name:

CADCVG

Name:

ACCIDENTAL DEATH & DISMEMBERMENT COVERAGE CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating the type of accidental death and dismemberment coverage selected by an employee.

Code Interpretation:

'S'           -  Self Coverage

'F'           -  Family Coverage               

'M'           -  Modified Family Plan

Comments:

Source - PPS

Level - Employee

Revision Date:

System Number:

CPS0162

User Access Name:

ADEFFDT

Name:

ACCIDENTAL DEATH & DISMEMBERMENT COVERAGE EFF DATE

Type:

ALPHANUMERIC

Length:

6

Format:

MM/DD/YY - Inquiry Only; MMDDYY - Entry/Update

General Description:

The effective date of coverage for accidental death and dismemberment (AD&D) insurance.

Code Interpretation:

N/A

Comments:

Source - PPS

Level - Employee

Revision Date:

System Number:

CPS0148

User Access Name:

ADPRINSUM

Name:

ACCIDENTAL DEATH & DISMEMBERMENT PRINCIPAL SUM

Type:

ALPHANUMERIC

Length:

3

Format:

N/A

General Description:

The amount of accidental death and dismemberment insurance coverage selected by the employee. This amount is expressed in thousands of dollars, e.g., $20,000 becomes '020'.

Code Interpretation:

'010'           -  $10,000               '070'-  $70,000

'015'           -  $15,000               '075'-  $75,000

'020'           -  $20,000               '080'-  $80,000

'025'           -  $25,000               '085'-  $85,000

'030'           -  $30,000               '090'-  $90,000

'035'           -  $35,000               '095'-  $95,000

'040'           -  $40,000               '100'- $100,000

'045'           -  $45,000               '125'- $125,000

'050'           -  $50,000               '150'- $150,000

'055'           -  $55,000               '175'- $175,000

'060'           -  $60,000               '200'- $200,000

'065'           -  $65,000               '300'- $300,000

'400'- $400,000

Comments:

Source - PPS

Level - Employee

Revision Date:

System Number:

CPS4301

User Access Name:

ACCTGROUP (also AGC)

Name:

ACCOUNT GROUP CODE

Type:

ALPHANUMERIC

Length:

6

Format:

N/A

General Description:

The number identifying the accounting structure category for a group of account numbers.

Code Interpretation:

2022    Revenue-Local Governments Appropriations, Grants, Contracts

2064    Revenue-Private Gifts,Grants & Contracts-Restricted Contracts

2072    Revenue-Sales & Service of Teaching Hospitals

2082    Revenue-Other Sources - Other

30001   Current Expenditures - Instruction

30002   Current Expenditures - Summer Session

30003   Current Expenditures - Teaching Hospitals

30004   Current Expenditures - Academic Support

30005   Current Expenditures - Research

30006   Current Expenditures - Libraries

30007   Current Expenditures - University Extension

30008   Current Expenditures - Public Service

30009   Current Expenditures - Maint & Operation of Physical Plant

30011   Current Expenditures - Student Services

30012   Current Expenditures - Institutional Support

30013   Current Expenditures - Auxiliary Enterprises

30014   Current Expenditures - Student Financial Aid

300159  Provisions

Comments:

Source - CAFP

Level - Distribution

Effective July 1, 1997, Davis instituted a new accounting structure which no longer correlates to the traditional account, fund and sub structures still used by the other campuses. Data originating from within the Corporate Account Fund Profile (e.g., Account Group Code, Fund Group Code, Function, UAS Discipline, Division/School/College (Corggrp/Orggrp), Department (Corg2/Corg2NM), and Unit (Corgunit/Orgunit)) for Davis campus during the CPS Snapshot file months of July-Sept 1997 and Nov-Dec 1997 may be problematic.

Revision Date:

3/25/98 (effective 7/1/95)

System Number:

CPS0001

User Access Name:

ACCTNO

Name:

ACCOUNT NUMBER

Type:

ALPHANUMERIC

Length:

6

Format:

N/A

General Description:

The number assigned by the campus for the purpose of identifying a specific balance sheet, revenue, or expenditure account.

Code Interpretation:

Refer to Accounting Manual Section A-115-2.

Comments:

Source - PPS

Level - Distribution

Effective July 1, 1997, Davis instituted a new accounting structure which no longer correlates to the traditional account, fund and sub structures still used by the other campuses. Data originating from within the Corporate Account Fund Profile (e.g., Account Group Code, Fund Group Code, Function, UAS Discipline, Division/School/College (Corggrp/Orggrp), Department (Corg2/Corg2NM), and Unit (Corgunit/Orgunit)) for Davis campus during the CPS Snapshot file months of July-Sept 1997 and Nov-Dec 1997 may be problematic.

Revision Date:

March 25, 1998

System Number:

CPS1370

User Access Name:

APTACTIVT

Name:

ACTIVE THIS MONTH CODE-APPOINTMENT

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating whether there are any earnings for an appointment this month.

Code Interpretation:

'Y' - Yes, appointment has earnings

'N' - No, appointment has no earnings

Comments:

Source - Derived

Level - Appointment

Revision Date:

System Number:

CPS1376

User Access Name:

EMPACTIVL

Name:

ACTIVE LAST MONTH CODE-EMPLOYEE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating whether there are any earnings for an employee for the month immiediately prior to this month.

Code Interpretation:

'Y' - Yes, employee has earnings

'N' - No, employee has no earnings

Comments:

Source - Derived

Level - Employee

Revision Date:

3/24/03

System Number:

CPS1375

User Access Name:

EMPACTIVT

Name:

ACTIVE THIS MONTH CODE-EMPLOYEE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating whether there are any earnings for an employee this month.

Code Interpretation:

'Y' - Yes, employee has earnings

'N' - No, employee has no earnings

Comments:

Source - Derived

Level - Employee

Revision Date:

DRAFT 11/01/91

System Number:

CPS0905

User Access Name:

PERMPOST

Name:

ADDRESS-PERMANENT-POSTAL CODE

Type:

ALPHANUMERIC

Length:

10

Format:

N/A

General Description:

The postal code assigned to the area in which the employee's permanent address is located.

Code Interpretation:

N/A

Comments:

Source - PPS

Level - Employee

Revision Date:

PUBL. 09/22/87

System Number:

CPS0901

User Access Name:

PERMCITY

Name:

PERMANENT ADDRESS-CITY

Type:

ALPHANUMERIC

Length:

21

Format:

N/A

General Description:

The city designated by the individual as his or her permanent residence.

Code Interpretation:

N/A

Comments:

Source - PPS

Removed from FY file effective 7/1/2000

Database - FY Address database

Revision Date:

July 1, 2000

System Number:

CPS0903

User Access Name:

PERMADR1

Name:

PERMANENT ADDRESS-LINE 1

Type:

ALPHANUMERIC

Length:

30

Format:

N/A

General Description:

The first line of the address designated by the individual as his or her permanent residence.

Code Interpretation:

N/A

Comments:

Source - PPS

Removed from FY file effective 7/1/2000

Database - FY Address database

Revision Date:

July 1, 2000

System Number:

CPS0904

User Access Name:

PERMADR2

Name:

PERMANENT ADDRESS-LINE 2

Type:

ALPHANUMERIC

Length:

30

Format:

N/A

General Description:

The second line of the address designated by the individual as his or her permanent residence.

Code Interpretation:

N/A

Comments:

Source - PPS

Removed from FY file effective 7/1/2000

Database - FY Address database

Revision Date:

July 1, 2000

System Number:

CPS1958

User Access Name:

AGE

Name:

AGE

Type:

NUMERIC

Length:

2

Format:

nn

General Description:

The age of the individual in whole years as of the last day of the file month.

Code Interpretation:

N/A

Comments:

Source - Defined

Level - Employee

AGE is computed by subtracting Date of Birth from today's date and dividing by 10,000.

Revision Date:

March 30, 1998

System Number:

CPS0999

User Access Name:

APTBASIS

Name:

APPOINTMENT BASIS CODE

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

Code indicating the service period on which an appointment is based.

Code Interpretation:

' 9' - 9 months

'10' - 10 months

'11' - 11 months

'12' - 12 months

Comments:

Source - PPS

Level - Appointment

Effective October 1992, Appointment Basis Code will identify Staff Partial Year Career Positions by indicating the number of paid work months in a partial year position.

Revision Date:

DRAFT 09/15/92

System Number:

CPS0907

User Access Name:

APTBEGDT

Name:

APPOINTMENT BEGIN DATE

Type:

ALPHANUMERIC

Length:

6

Format:

MM/DD/YY - Inquiry Only; MMDDYY - Entry/Update

General Description:

Date on which the employee's appointment is effective.

Code Interpretation:

N/A

Comments:

Source - PPS

Level - Appointment

Revision Date:

System Number:

CPS0908

User Access Name:

APTENDDT

Name:

APPOINTMENT END DATE

Type:

ALPHANUMERIC

Length:

6

Format:

MM/DD/YY - Inquiry Only; MMDDYY - Entry/Update

General Description:

The date on which an appointment ended or is expected to end.

Code Interpretation:

N/A

Comments:

Source - PPS

Level - Appointment

Revision Date:

PUBL. / /

System Number:

CPS0077

User Access Name:

APTPAYRT

Name:

APPOINTMENT PAY RATE

Type:

NUMERIC

Length:

10

Format:

N/A

General Description:

The full-time rate of pay (hourly, annual, or by-agreement amount) associated with the appointment.

Code Interpretation:

N/A

Comments:

Source - PPS

Level - Appointment

Usage - D 11.4

Use Appointment Rate Code to identify hourly versus annual rates

Revision Date:

System Number:

CPS0133

User Access Name:

CAPTRT

Name:

APPOINTMENT RATE CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating the nature of the rate of pay for the appointment.

Code Interpretation:

'A' - Annual

'B' - By Agreement

'H' - Hourly

Comments:

Source - PPS

Level - Appointment

Use Appointment Rate Code in conjunction with Appointment Pay Rate to identify hourly versus annual rates.

Revision Date:

System Number:

CPS0885

User Access Name:

CAPTREP

Name:

APPOINTMENT REPRESENTATION CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating whether an appointment is eligible to be represented, for collective bargaining purposes.

Code Interpretation:

'C' - Covered

'S' - Supervisor (Uncovered)

'U' - Uncovered

Comments:

Source - PPS

Level - Appointment

Related to Title Unit Code

Revision Date:

System Number:

CPS1241

User Access Name:

CAPTTYP

Name:

APPOINTMENT TYPE CODE-PPS

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating the type of appointment.

Code Interpretation:

'1'   - Contract

'2'   - Career

'3'   - Limited

'4'   - Casual/Restricted (i.e., student)

'5'   - Academic

'6'   - Per diem

'7'   - Partial Year Career

'8'   - Floater

Previous codes (prior to January 1, 1988)

'X'   - Contract

'E'   - Executive

'1'   - Management and Professional (MAP)

'2'   - Staff, Career

'3'   - Staff, Casual

'4'   - Staff, Casual/Restricted

'5'   - Academic (0800-3999)

'6'   - Per Diem Health Care

'7'   - Administrative & Professional Staff, Career

'8'   - Administrative & Professional Staff, Casual

'9'   - Administrative & Professional Staff, Casual/Restricted

Previous codes (prior to July 1, 1986):

'1'   - Management Program (0001-0499)

'2'   - Staff, Career (4000-9999, except 8918 and 9119)

'3'   - Staff, Casual (4000-9999, except 8918 and 9119)

'4'   - Staff, Casual/Restricted (4000-9999, except 8918 and 9119)

'5'   - Academic (0800-3999)

'6'   - Per diem nurses and vocational per diem nurses (8918 and 9119)

'7'   - Coaches and related professionals (0500-0799)

'S'   - Staff, Unknown

Comments:

Source - PPS

Level - Employee

Student employees may be identified via Appointment Type (CAPTTYP eq '4') or via Derived BELI (BELIDER eq '6') or UC Student Status Code (CUCSTUDENT eq '3' or '4'), and via academic titles where the first character of Class Title Outline (CCTOB) is equal to '4'

Revision Date:

August 13, 2015

System Number:

CPS4073

User Access Name:

APTYPRI

Name:

APPOINTMENT TYPE CODE-PPS-PRIMARY APPT

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code associated with an employee's primary appointment indicating the type of appointment.

Code Interpretation:

'1'   - Contract

'2'   - Career

'3'   - Casual

'4'   - Casual/Restricted

'5'   - Academic (0800-3999)

'6'   - Per diem

'7'   - Partial Year Career

'8'   - Floater

Previous codes may be attached.

#1241 - APPOINTMENT TYPE CODE-PPS Codes prior to January 1, 1988

'X'   - Contract

'E'   - Executive

'1'   - Management and Professional (MAP)

'2'   - Staff, Career

'3'   - Staff, Casual

'4'   - Staff, Casual/Restricted

'5'   - Academic (0800-3999)

'6'   - Per diem Health Care

'7'   - Administrative & Professional Staff, Career

'8'   - Administrative & Professional Staff, Casual

'9'   - Administrative & Professional Staff, Casual/Restricted

#1241 - APPOINTMENT TYPE CODE-PPS Codes prior to July, 1986

'1'   - Management program (0001-0499)

'2'   - Staff, Career (4000-9999, except 8918 and 9119)

'3'   - Staff, Casual (4000-9999, except 8919 and 9119)

'4'   - Staff, Casual/Restricted (4000-9999, except 8919 and 9119)

'5'   - Academic (0800-3999)

'6'   - Per diem nurses and vocational per diem nurses (8918 and 9119)

'7'   - Coaches and related professionals (0500-0799)

'S'   - Staff, unknown

Comments:

Source - Derived

Level - Employee

Revision Date:

May 22, 2013

System Number:

CPS0149

User Access Name:

CAPTTYPT

Name:

APPOINTMENT TYPE CODE-TITLE CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating the type of appointment associated with an employee's title code.

Code Interpretation:

'1' -        Tier 1 - Professional and Support Staff

(includes former A&PS and Staff titles)

'2' -        Tier 2 - Managers and Senior Professionals

(includes former MAP and Executive titles)

'A' -        Academic

Codes effective prior to 7/1/96

'E'   -      Executive

'M'   -      Management and Professional (MAP)

'P'   -      Administrative and Professional Staff (A&PS)

'S'   -      Staff Personnel

'A'   -      Academic

Comments:

Source - UTCS

Level - Appointment

Tier 2 SMG title codes from 0001-0199, Tier 2 MSP title codes from 0200-0799. Tier 1 stepped employees may be identified via MERIT flag value of ' '. Tier 1 merit-based employees may be identified via MERIT flag value of 'Y'.

Revision Date:

07/01/96

System Number:

CPS4072

User Access Name:

PROGPRI

Name:

APPOINTMENT TYPE CODE-TITLE CODE-PRIMARY APPT

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code associated with an employee's primary appointment indicating the type of appointment associated with an employee's title code.

Code Interpretation:

'1'   -      Professional and Support Staff

(Includes former A&PS and Staff Titles)

'2'   -      Managers and Senior Professionals

(Includes former MAP and Executive Titles)

'A'   -      Academic

Comments:

Source - Derived

Level - Employee

Revision Date:

April 1, 1998

System Number:

CPS0897

User Access Name:

CWOS

Name:

APPOINTMENT WITHOUT SALARY INDICATOR

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating whether an appointment is without salary.

Code Interpretation:

'Y' - Yes, appointment is without salary

'N' - No, appointment is not without salary

Comments:

Source - PPS

Level - Appointment

Revision Date:

System Number:

CPS0344

User Access Name:

AF_SVC_MEDAL

Name:

ARMED FORCES SERVICE MEDAL VETERAN CODE

Type:

ALPHANUMERIC

Length:

1

Format:

nn.nn

General Description:

Code indicating whether an individual who, while serving on active duty in the U.S. military participated in a United States military operation for which an Armed Forces Service Medal was awarded.

Code Interpretation:

Blank   - Not an Armed Forces Service Medal Veteran
N         - Not an Armed Forces Service Medal Veteran
M        - Armed Forces Service Medal Veteran

Comments:

Source - PPS

Level - Employee

Revision Date:

Added 1/31/2008

System Number:

CPS3330

User Access Name:

AVGHRSWK

Name:

AVERAGE PAID HOURS PER WEEK

Type:

NUMERIC

Length:

4

Format:

nn.nn

General Description:

An employee's average paid hours per week over the most recent twelve months. Certain months, such as those in which an employee is on approved leave, are excluded from the average.

Code Interpretation:

N/A

Comments:

Source - PPS

Level - Employee

Revision Date:

PUBL. 10/27/89

System Number:

CPS4318

User Access Name:

BARGAIN

Name:

BARGAIN TYPE CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

A code which indicates whether the specific title is bargained locally or centrally.

Code Interpretation:

'C' - bargained centrally
'L' - bargained locally
'N' - not currently bargained

Comments:

Source - UTCS

Level - Appointment

This field was added to the database effective July 1, 2000.

Revision Date:

July 1, 2000

System Number:

CPS3331

User Access Name:

BELICDT

Name:

BENEFITS ELIGIBILITY LEVEL CONFLICT DATE

Type:

ALPHANUMERIC

Length:

4

Format:

MM/YY - Inquiry Only ; MMYY - Entry/Update

General Description:

The processing month in which the Benefits Eligibility Level Indicator-Assigned and the Benefits Eligibility Level Indicator-Derived are first found to be in conflict.

Code Interpretation:

N/A

Comments:

Source - PPS

Level - Employee

Any non-matching Benefits Eligibility Level Indicators (BELIs) are in conflict except the following: An assigned BELI of '4' or '5' is not in conflict with a derived BELI of 'U'. An assigned BELI of '5' is not in conflict with a derived BELI of 'X', '6', '7', '8', or '9'.

Revision Date:

PUBL. 06/05/02

System Number:

CPS3332

User Access Name:

BELIASI

Name:

BENEFITS ELIGIBILITY LEVEL INDICATOR-ASSIGNED

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating the level of benefits for which an employee is eligible, as assigned by the department.

Code Interpretation:

'1'   - Career benefits eligibility

'2'   - Mid-level benefits eligibility: not a member of a retirement

system and appointment is for 12 months or more

'3'   - Mid-level career benefits eligibility: not a member of a retirement

system and appointment is for less than 12 months

'4'   - Core benefits eligibility: average hours worked per week meets

minimum eligibility requirement

'5'   - No benefits eligibility for any of the following reasons:

average hours worked per week does not meet minimum eligibility requirement

appointments are either Casual/Restricted or are in titles restricted to students

appointments are Per Diem in nature

appointments are By Agreement

appointments are Without Salary

'P'   - Postdoctoral scholar benefits eligibility

'?'   - No values assigned or separated employee

BENEFITS ELIGIBILITY LEVEL-ASSIGNED Previously Used Codes

'5'   - No benefits eligibility: average hours worked per week does

not meet minimum eligibility requirement

'6'   - No benefits eligibility (Student)

'7'   - No benefits eligibility (Per Diem)

'8'   - No benefits eligibility (By Agreement)

'9'   - No benefits eligibility (W/O Salary)

Comments:

Source - PPS

Level - Employee

Revision Date:

August 10, 2005

System Number:

CPS3333

User Access Name:

BELIDER

Name:

BENEFITS ELIGIBILITY LEVEL INDICATOR-DERIVED

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating the level of benefits for which the employee is eligible, as derived by the system.

Code Interpretation:

'1'   - Average hours worked per week meets the minimum eligibility

requirement; employee belongs to a retirement system plan;

employee record reflects non-excludable, non-expired appointment(s)

with duration of at least twelve months at 50 percent or more.

'2'   - Average hours worked per week meets the minimum eligibility

requirement; employee does not belong to a retirement system plan;

employee record reflects non-excludable, non-expired appointment(s)

with duration of at least twelve months at 50 percent or more.

'3'   - Average hours worked per week meets the minimum eligibility

requirement; employee does not belong to a retirement system plan;

employee record reflects non-excludable, non-expired appointment(s)

with duration of at least 3 months at 100 percent.

'4'   - Average hours worked per week meets the minimum

eligibility requirement; employee record reflects non-excludable,

non-expired appointment(s).

'5'   - Average hours worked per week does not meet minimum

eligibility requirement; employee record reflects non-excludable,

non-expired appointment(s).

'6'   - Employee record reflects no non-excludable, non-expired

appointments but does reflect at least one appointment which either

is Casual/Restricted or has a Title Code restricted to students.

'7'   - Employee record reflects no non-excludable, non-expired

appointments but does reflect at least one appointment which is

Per Diem.

'8'   - Employee record reflects no non-excludable, non-expired

appointments but does reflect at least one appointment which has

By Agreemement pay.

'9'   - Employee record reflects no non-excludable, non-expired

appointments but does reflect at least one appointment is

Without Salary.

'P'   -   Employee record reflects at least one appointment with a postdoctoral title

with a duration of at least twelve months at 50 percent time or more

or at least three months at 100%.

'U'   - Average Hours Per Week are equal to zero (invalid average);

employee record reflects non-excludable, non-expired appointment(s).

'X'   - Average Hours Per Week are equal to zero (invalid average);

employee record reflects no appointments.

Previously Used Codes:

- Career Benefits Eligiblity

- Limited Career Benefits Eligibility (12 months at 50 percent)

- Limited Career Benefits Eligibility (3 months at 100 percent)

- Core Benefits Eligibility

- No Benefits Eligibility (Paid Time)

- No Benefits Eligibility (Student)

- No Benefits Eligibility (Per Diem)

- No Benefits Eligibility (By Agreement)

- No Benefits Eligibility (Without Salary)

U     - System cannot derive paid time average and employee doesn't

qualify for benefits above core level

X     - System cannot calculate paid time average and employee has no

appointment records

Comments:

Source - PPS

Level - Employee

Student employees may be identified via Appointment Type (CAPTTYP) value of '4' (Casual Restricted) or via Derived BELI (BELIDER) value of '6' (No Benefits Eligibility-Appointment restricted to Students) or via UC Student Status Code (CUCSTUDENT) values of '3' (Undergraduate Student) or '4' (Graduate Student), and in academic titles where the first character of Class Title Outline (CCTOB) is equal to '4' (Student Assistants)

Revision Date:

August 10, 2005

System Number:

CPS4321

User Access Name:

BDGTCODE

Name:

Budgeted Fund Code

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating whether a fund is budgeted (i.e., incorporated into the annual budget, including State of California support, non-resident tuition fees, registration fees, endowments, and miscellaneous other funds) or non-budgeted (including certain discretionary funds, or funds provided for a limited time period and specific purpose, such as federal contracts and grants, private gifts and grants, special agreements with state and local agencies, and other special income).

Code Interpretation:

'B' - Budgeted
'N' - Non-budgeted

Comments:

Source - CAFP

Level - Distribution

Revision Date:

11/14/2003

System Number:

CPS0802

User Access Name:

BYAGREE

Name:

BY AGREEMENT CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating whether the appointment is on a by agreement basis.

Code Interpretation:

'B' - Appointment by agreement

' ' - Appointment not by agreement

Comments:

Source - UTCS

Level - Appointment

Revision Date:

System Number:

CPS2778

User Access Name:

CAMPUS

Name:

CAMPUS NAME-ABBREVIATED-CPS

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

An abbreviation of the name of a UC campus location.

Code Interpretation:

'BK'  - Berkeley

'DV'  - Davis

'IR'  - Irvine

'LA'  - Los Angeles

'RV'  - Riverside

'SB'  - Santa Barbara

'SC'  - Santa Cruz

'SD'  - San Diego

'SF'  - San Francisco

'MC'  - Merced

'AG'  - Agriculture & Natural Resources

'OP'  - Office of the President

'LB'  - Lawrence Berkeley Laboratory

'LV'  - Lawrence Livermore National Laboratory

'LN'  - Los Alamos National Laboratory

'HA'  - Hastings College of Law

'AS'  - ASUCLA

Comments:

Source - Defined

Level - Employee

Revision Date:

March 29, 2001

System Number:

CPS0830

User Access Name:

CHECK_DATE

Name:

CHECK DATE

Type:

DATE

Length:

8

Format:

YYYY/MM/DD

General Description:

For cancellation, handdrawn, or current activity PAR records, the date the check or the check/advice was issued. For overpayment PAR records, the date on which the overpayment worksheet was prepared (transaction date). 

Code Interpretation:

N/A

Comments:

Source - PPS

Level - Distribution (from PAR)

Revision Date:

August 2012

System Number:

CPS0156

User Access Name:

CCITSTAT

Name:

CITIZENSHIP STATUS CODE-EMPLOYEE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating employee's citizenship status with respect to United States tax regulations. 

Note: For immigration status, use Visa Type Code. 

Code Interpretation:

C - U.S. Citizen

R - Resident Alien

N - Non-resident Alien, wages subject to withholding tax,income reported on Form W-2

E - Non-resident Alien, wages not subject to Federal income tax withholding and FICA withholding; income is reported on Form 1042-S

A - Non-resident Alien from Canada, Japan, Mexico, or South Korea

X - Non-resident Alien living and working outside the United States; wages not subject to Federal and state withholding taxes

F - Resident Alien for Federal income tax purposes, wages subject to FICA witholding but not subject to Federal income tax withholding; income reported on Form 1042-S

P - Pending Permanent Resident, wages subject to withholding tax; income
Reported on Form W-2

S - Non-Resident Alien Student employee from India; income reported on
Form W-2

Comments:

Source - PPS

Level - Employee

Note: do not use this data element to determine citizenship/immigration status.  To evaluate citizenship status use "VISA TYPE CODE."

Revision Date:

May 2008

System Number:

CPS0826

User Access Name:

CTOB

Name:

CLASS TITLE OUTLINE NAME-LEVEL 3

Type:

ALPHANUMERIC

Length:

30

Format:

N/A

General Description:

The name of the specific category within an occupation group in the Class Title Outline to which a title is assigned for reporting purposes.

Code Interpretation:

See Class Title Outline Name/Occupational Subgrp Code (CCTOB)

Comments:

Source - UTCS

Level - Appointment

Revision Date:

March 25, 1998

System Number:

CPS4074

User Access Name:

CTOA

Name:

CLASS TITLE OUTLINE NAME-LEVEL 3-PRIMARY APPT

Type:

ALPHANUMERIC

Length:

30

Format:

N/A

General Description:

The name of the specific category within an occupation group in the Class Title Outline to which an employee's primary title is assigned for reporting purposes.

Code Interpretation:

See Class Title Outline Name/Occupational Subgrp Code (CCTOB)

Comments:

Source - Derived

Level - Employee

Revision Date:

March 25, 1998

System Number:

CPS4075

User Access Name:

CCTOA

Name:

CLASS TITLE OUTLINE/OCC SUBGRP CODE-PRIMARY APPT

Type:

ALPHANUMERIC

Length:

3

Format:

N/A

General Description:

Code indicating the primary occupation group to which an employee's primary title is assigned for reporting purposes. For staff titles, this element is known as the Occupational Subgroup Code. For academic titles, the component characters of the CTO have been assigned specific values. (See key which precedes Class Title Outline codes.)

Code Interpretation:

See Class Title Outline Name/Occupational Subgrp Code (CCTOB)

Comments:

Source - Derived

Level - Employee

Revision Date:

March 25, 1998

System Number:

CPS0799

User Access Name:

CCTOB

Name:

CLASS TITLE OUTLINE/OCCUPATIONAL SUBGRP CODE

Type:

ALPHANUMERIC

Length:

3

Format:

N/A

General Description:

Code indicating the primary occupation group to which a title is assigned for reporting purposes. For staff titles, this element is known as the Occupational Subgroup Code. For academic titles, the component characters of the CTO have been assigned specific values. (See key which precedes Class Title Outline codes.)

Code Interpretation:

LEVEL 1

A    Student Services

B    Clerical and Allied Services

C    Food and Linen Services

D    Communication, Arts and Graphics

E    Architecture, Engineering and Allied Services

F    Fiscal, Management and Staff Services

G    Maintenance, Fabrication and Operations

H    Health Care and Allied Services

I    Sciences, Laboratory and Allied Services

J    Protective Services

M    Management

S    Academic Administrative Officers

Z    Other

Faculty-Ladder Ranks

Faculty-Acting Ranks

Faculty-Lecturers

Other Faculty

Student Assistants

Research

Librarians

Cooperative Extension

University Extension

Other Academic Personnel

LEVEL 2

S2   Deans and Provosts

S3   Director

S4   Coordinator-Administrator

S5   Academic-Administrator

Professorial

Clinical Professor of Dentistry - 50% or more

Supervisor of Physical Education

Acting Professor-Senate

Acting Professor-Non-Senate

21   Lecturer - With Security of Employment

22   Lecturer Titles

31   Professor in Residence

32   Visiting Professor

33   Adjunct Professor

34   Clinical Professor

35   Instructional Assistant

42   Teaching Assistant and Equivalent

43   Research Assistant

44   Intern or Resident

45   Other Student Titles

46   Associate - Student

47   Postgraduate Research-Student

52   Astronomer

53   Agronomist

54   Professional Research

55   Specialist

56   Other Research

57   Postgraduate Research - Non-Student

62   Librarian

72   Cooperative Extension

82   University Extension

92   Miscellaneous Titles

LEVEL 3

A10  Recreational Services

A15  School Relations Services

A20  Residential Services

A25  Placement Services

A30  Advising Services

A35  Counseling Services

B15  Clerical/Administrative, Special and Mail Services

B20  Key Entry Operations

B30  Storekeeping

B40  Word Processing

C10  Food Service Management

C15  Food Preparation and Distribution - Cooks & Bakers

C20  Food Preparation and Distribution - Supervisors & Workers

C25  Linen Service Management

C30  Linen Preparation and Distribution

D10  Communication

D15  Art and Graphics - Photography

D25  Art and Graphics - Theatre

E10  Architecture and Planning

E15  Drafting

E20  Engineering

F10  Computer Operations

F15  Computer Programming and Analysis

F20  Administrative, Budget and Personnel Analysis

F30  Management Services

F35  Fiscal Services

F40  Employment Services

F45  Materiel Management

G15  Physical Plant Services - Agriculture and Grounds

G20  Physical Plant Services - Operations

G23  Physical Plant Services - Maintenance

G25  Physical Plant Services - Maintenance

G33  Custodial Services (U)

G35  Custodial Services

G40  Technical and Operations Services

G45  Marine Trades

G55  Automotive and Aircraft Equipment - Maintenance

G65  Automotive Equipment - Operation

G75  Reprographic and Bookbinding Services

G80  Printing Services

H10  Hospital Attendants - Assistants and Escorts

H15  Hospital Attendants - Vocational Nurses

H20  Technologists - Clinical Laboratory

H25  Technologists - Radiologic, Respiratory and Allied

H30  Technologists - ECG, EEG and Allied

H35  Nursing Services

H40  Physicians and Dentists

H45  Medical Auxiliary Services - Miscellaneous

H50  Pharmacists

H55  Hospital Radiation Physicists

H60  Medical Record Administrators and Technicians

H65  Social Services - Clinical

H70  Social Services - Community

H75  Psychologists

H80  Therapeutic Services

I10  Animal Care Services - Technicians

I15  Animal Care Services - Veterinarians

I20  Laboratory and Allied Services

I25  Sciences

J10  Police and Fire Services

J15  Parking and Guard Services

M05  Executive Program

M10  Managers

M20  Coaches & Related Professionals

S21  Dean

S24  Acting Dean and Acting Provost

S26  Divisional Dean

S27  Provost

S31  Director

S34  Acting Director

S44  Acting Academic Coordinator

S46  Academic Coordinator

S56  Academic Administrator

S61  Department Chairperson

S64 Acting Department Chairperson

Z10  Student Aids, Outside Agencies

Z20  Unclassified

Z25  Unclassified (999X)

010  Professorial-Tenure

011  Professorial-Non Tenure

012  Professorial-Recall

016  Professorial-Emeritus

030  Clinical Professor of Dentistry-50% or more-Tenure

031  Clinical Professor of Dentistry-50% or more-Non Tenure

040  Supervisor of P.E.-Tenure

041  Supervisor of P.E.-Non Tenure

042  Supervisor of P.E.-Recall

114  Acting Professor-Senate

124  Acting Professor-Non Senate

210  Lecturer-Security of Employment

211          Lecturer-Potential Security of Employment - 100% - Senate

212  Lecturer-Security of Employment-Recall

216  Lecturer-Security of Employment-Emeritus

220  Lecturer-Continuity of Employment

221  Lecturer-Potential Security of Employment

225  Lecturer

311  Professor in Residence

316  ___________-Senate-Emeritus

317  Professor of Clinical ____________

323  Visiting Professor

335  Adjunct Professor

341  Health SciencesClinical Professor

346          Clinical Professor-Volunteer

357  Instructional Assistant

426  Teaching Assistant & Equivalent

436  Graduate Student Researcher

446  Intern or Resident

456  Other Student Titles

467  Associate-Student

477  Post-Graduate Research-Student

487          Obsolete

520  Astronomer-Tenure

521  Astronomer-Non Tenure

522  Astronomer-Recall

523  Astronomer-Visiting

524  Astronomer-Acting

530  Agronomist-Tenure

531  Agronomist-Non Tenure

532  Agronomist-Recall

533  Agronomist-Visiting

534  Agronomist-Acting

541  Professional Research-Regular

542  Professional Research-Recall

543  Professional Research-Visiting

551  Specialist

557  Specialist in Agriculture Experiment Station

566  Other Research

575          Postdoctoral scholar

577  Post-Graduate Research Non-Student

581          Project Series

583          Project Series-Visiting

621  Librarian

623  Visiting Librarian

627  Associate and Assistant University Librarian

723  Visiting Cooperative Extension Specialist

727  Cooperative Extension Specialist

728  Cooperative Extension Advisor

729  Specialist in Cooperative Extension

824  Acting Continuing Education Specialist

825          Continuing Educator-University Extension

827  Continuing Education Specialist - University Extension

828  University Extension Other

927  Miscellaneous Titles-Series

928  Miscellaneous Titles-Single Titles

999  Supplemental Pay Codes

Class Title Outline as a key for Academic Titles

Class Title Outline is a three character code.  It contains three positions (XYZ) whose values have particular meaning.

Position X (First Position):  Academic Group Code

'S'   Administrative Titles

'0'   Regular Teaching Faculty - Ladder Ranks

'1'   Regular Teahing Faculty - Acting Ranks

'2'   Lecturers

'3'   Other Teaching Faculty

'4'   Student Assistants

'5'   Research

'6'   Librarians

'7'   Cooperative Extension

'8'   University Extension

'9'   Other Academic Personnel and Pay Codes

Position Y (Second Position):  Academic Senate Membership

'0'   Non-Senate, including student titles

'1'   Senate membership

'2'   Non-Senate, including student titles

'3' Non-Senate, including student titles

'4' Non-Senate, including student titles

'5' Non-Senate, including student titles

'6' Non-Senate, including student titles

'7' Non-Senate, including student titles

'8' Non-Senate, including student titles

'9' Non-Senate, including student titles

Position Z (Third position):  Career Status

'0'   Tenure, SOE or Continuity of Employment

'1' Non Tenure, regular ranks

'2' Recalled

'3' Visiting

'4' Acting

'5' Adjunct

'6' Other

'7' Other

'8' Other

'9' Other

Comments:

Source - UTCS

Level - Appointment

Student employees may be identified via first character of Class Title Outline (1st character of CCTOB eq '4'), and also via Appointment Type (CAPTTYP eq '4') or via Derived BELI (BELIDER eq '6') or via UC Student Status Code (CUCSTUDENT eq '3' or '4')

Revision Date:

June 26, 2006

System Number:

CPS0913

User Access Name:

CCBU

Name:

COLLECTIVE BARGAINING UNIT CODE

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

Code indicating the collective bargaining unit of an individual.

Code Interpretation:

'A1'       - Academic Senate - UCB

'A2'       - Academic Senate - UCSF

'A3'       - Academic Senate - UCD

'A4'       - Academic Senate - UCLA

'A5'       - Academic Senate - UCR

'A6'       - Academic Senate - UCSD

'A7'       - Academic Senate - UCSC

'A8'       - Academic Senate - UCSB

'A9'       - Academic Senate - UCI

'CX'       - Clerical & Allied Services

'DX'       - Student Health Physicians and Dentists

'EX'       - Patient Care Technical

'F3'       - Firefighters - UCD (formerly FF; formerly part of TX)

'F7'       - Firefighters - UCSC (formerly FF; formerly part of TX)

'FX'       - Non-Senate Academic Research Professionals

'GS'       - Printing Trades

'HX'       - Residual Patient Care Professionals

'IX'       - Non-Academic Senate Instructional

'KB'       - Skilled Crafts - UCB/LBL

'K2'       - Skilled Crafts - UCSF

'K3'       - Skilled Crafts - UCD

'K4'       - Skilled Crafts - UCLA

'K5'       - Skilled Crafts - UCR

'K6'       - Skilled Crafts - UCSD

'K7'       - Skilled Crafts - UCSC

'K8'       - Skilled Crafts - UCSB

'K9'       - Skilled Crafts - UCI

'LX'       - Professional Librarians

'NX'       - Registered Nurses

'PA'       - Police Officers

'PX'       - Postdoctoral Scholars

'RX'       - Research Support Professionals

'SX'       - Service

'TX'       - Systemwide Technical

'ZB'       - Readers & Tutors - UCB

'Z2'       - Readers & Tutors - UCSF

'Z3'       - Readers & Tutors - UCD

'Z4'       - Readers & Tutors - UCLA

'Z5'       - Readers & Tutors - UCR

'Z6'       - Readers & Tutors - UCSD

'Z7'       - Readers & Tutors - UCSC

'Z8'       - Readers & Tutors - UCSB

'Z9'       - Readers & Tutors - UCI

'87'       - Stipend/Differential Pay

'88'       - Indeterminate Unit

'99'       - No Bargaining Unit

Comments:

Source - Derived

Level - Employee

Revision Date:

November 18, 2014

System Number:

CPS0914

User Access Name:

COMPHRSBAL

Name:

COMPENSATORY TIME HOURS BALANCE

Type:

NUMERIC

Length:

4

Format:

nnnn

General Description:

The number of hours (rounded to the nearest whole number) that an employee has available for use as paid time off in this leave category.

Code Interpretation:

N/A

Comments:

Source - PPS

Level - Employee

Usage - F5

Revision Date:

PUBL. / /

System Number:

CPS0988

User Access Name:

COMPHRS

Name:

COMPENSATORY TIME HOURS USED BY MONTH

Type:

NUMERIC

Length:

3

Format:

nnn

General Description:

The number of compensatory time hours (rounded to the nearest whole number) used by an employee during a month.

Code Interpretation:

N/A

Comments:

Source - PPS

Level - Employee

Usage - F5

Revision Date:

PUBL. / /

System Number:

CPS4310

User Access Name:

CCOUNTRYRES

Name:

COUNTRY OF RESIDENCY CODE - FOREIGN

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

The code for a foreign country of which the employee is a resident.

Comments:

Source - PPS

Level - Employee

This field was added to the database master effective July 1, 2000, and populated for most locations effective September 1, 2000.

Revision Date:

July 1, 2000

System Number:

CPS4311

User Access Name:

COUNTRYRES

Name:

COUNTRY OF RESIDENCY NAME - FOREIGN

Type:

ALPHANUMERIC

Length:

30

Format:

N/A

General Description:

The name of a foreign country of which the employee is a resident.

Comments:

Source - PPS

Level - Employee

This field was added to the database master effective July 1, 2000, and populated for most locations effective September 1, 2000.

Revision Date:

July 1, 2000

System Number:

CPS0032

User Access Name:

BDATE

Name:

DATE OF BIRTH

Type:

ALPHANUMERIC

Length:

6

Format:

YY/MM/DD

General Description:

The year, month and day on which the person was born.

Code Interpretation:

May 5, 1950 = 50/05/05.

Comments:

Source - PPS

Level - Employee

Date of Birth is the source of the AGE define. AGE is computed by subtracting Date of Birth from today's date and dividing by 10,000.

Revision Date:

May 8, 1998

System Number:

CPS0915

User Access Name:

EMPDT

Name:

DATE OF MOST RECENT HIRE

Type:

ALPHANUMERIC

Length:

6

Format:

MM/DD/YY - Inquiry Only; MMDDYY - Entry/Update

General Description:

Date on which employee was most recently hired by the University.

Code Interpretation:

N/A

Comments:

Source - PPS

Level - Employee

Revision Date:

PUBL. / /

System Number:

CPS4313

User Access Name:

ORIGHIREDT

Name:

ORIGINAL DATE OF HIRE

Type:

DATE

Length:

6

Format:

YY/MM/DD

General Description:

The original date that an employee started employment at the University of California.

Comments:

Source - PPS

Level - Employee

This field was added to the database master effective July 1, 2000, and populated for most locations effective September 1, 2000.

Revision Date:

July 1, 2000

System Number:

CPS4014

User Access Name:

DCPFUND

Name:

DCP FUND SELECTION CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating the fund selected by the individual for the Defined Contribution Plan (DCP) portion of the UC Retirement System (UCRS) deduction.

Code Interpretation:

Y     - DCP Eligible

N     - Not DCP Eligible

Previously valid codes:

A     - Multi-Asset Fund

B     - Bond Fund

C     - Calvert Fund
E     - Equity Fund
F     - Fidelity Investments Fund
G     - Insurance Company Contract Fund

M     - Money

Market Fund
O     - Balanced Growth Fund (BGF)
S     - Savings Fund
T     - Treasury Inflation Protected Securities (TIPS) Fund

Comments:

Source - PPS

Level - Employee

Revision Date:

August 10, 2005

System Number:

User Access Name:

Name:

Type:

Length:

Format:

General Description:

Code Interpretation:

Comments:

• Source - Derived
• Level - Distribution

Revision Date:

System Number:

User Access Name:

Name:

Type:

Length:

Format:

General Description:

Code Interpretation:

Comments:

• Source - PPS Description of Service (DOS) table
• Level - Distribution

Revision Date:

DWH6803

N/A

• Source - derived
• Level - Employee

Currently the University pays the entire cost of dental insurance, so the employee's share is zero.

6/10/05

DWH6805

N/A

• Source - derived
• Level - Employee

Currently the University pays the entire cost of dental insurance.

6/10/05

DWH6804

N/A

• Source - derived
• Level - Employee

Currently the University pays the entire cost of dental insurance.

6/10/05

System Number:

CPS0125

User Access Name:

CDENTPLN

Name:

DENTAL PLAN CODE

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

Code indicating the dental plan selected by the individual.

Code Interpretation:

'D1'   - Delta Dental of California

'D3'   - PMI

'P3'   - PSBP Dental HMO

'P4'   - PSBP Dental PPO

'DD'   - Default Dental*

'XX'   - Opted out of dental

'XC'   - Cancelled dental

'XD'   - De-enrolled - suspension of Premiums or ineligible dependent

Previous codes (prior to July 1, 1986):

'C'   - California Dental Service

'S'   - Safeguard

Comments:

Source - PPS

Level - Employee

Default Dental represents employees who may have enrrolled in one of the dental plans, but whose enrollment and premium have not been reported due to payroll deadlines. DD is used to suspend the Delta single party default mechanism until the employee becomes properly enrolled in the career dental plan selected or truly defaults into Delta single party coverage. Default headcounts should not be reported or included in reports.

Revision Date:

August 10, 2005

System Number:

CPS0253

User Access Name:

CDENTCVG

Name:

DENTAL PLAN COVERAGE CODE-PPS

Type:

ALPHANUMERIC

Length:

3

Format:

N/A

General Description:

Code indicating the type of dental plan coverage selected by the individual.

Code Interpretation:

U     - Self only

UA    - Self and Adult

UC    - Self and Children

UAC   - Self and Family

Previous code values:

'U ' - One party

'UU ' - Two party

'UUU' - Family

Code values prior to July 1, 1986:

'1' - Self

'2' - Self and spouse

'3' - Self, spouse, and dependent(s)

'4' - Self and dependent(s)

Comments:

Source - PPS

Level - Employee

Revision Date:

August 10, 2005

System Number:

CPS0129

User Access Name:

DENTEFFDT

Name:

DENTAL PLAN COVERAGE EFFECTIVE DATE

Type:

ALPHANUMERIC

Length:

6

Format:

MM/DD/YY - Inquiry Only; MMDDYY - Entry/Update

General Description:

The effective date of coverage for dental insurance.

Code Interpretation:

N/A

Comments:

Source - PPS

Level - Employee

Revision Date:

System Number:

CPS6335

User Access Name:

DEPANNAMT

Name:

DEPCARE ANNUAL AMOUNT

Type:

Numeric

Length:

5

Format:

nnnnn

General Description:

The Depcare deduction amount multiplied by the number of months the employee is enrolled in Depcare.

Code Interpretation:

N/A

Comments:

Source - PPS

Level - Employee

Revision Date:

October 2, 2003

System Number:

CPS3752

User Access Name:

YTDDEPDE

Name:

DEPCARE DEDUCTION YTD

Type:

NUMERIC

Length:

7

Format:

nnnnn.nn

General Description:

The total amount the employee has contributed to the Dependent Care Program during the calendar year to date.

Code Interpretation:

N/A

Comments:

Level - Employee

Source - PPS

Revision Date:

PUBL. 09/01/90

System Number:

CPS0315

User Access Name:

DEPTERMDT

Name:

DEPCARE TERMINATION DATE

Type:

Date

Length:

6

Format:

YYMMDD

General Description:

The date on which the DepCare agreement ends for the employee. Claims cannot be made for expenses incurred after this date.

Code Interpretation:

N/A

Comments:

Source - PPS

Level - Employee

Revision Date:

October 2, 2003

System Number:

CPS1850

User Access Name:

DEPCAREPLN

Name:

DEPENDENT CARE SALARY REDUCTION PLAN CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating whether the individual has elected participation in the Dependent Care Salary Reduction Plan.

Code Interpretation:

'Y' - Yes, participation elected 'N' - No, participation not elected

Comments:

Source - PPS

Level - Employee

Revision Date:

PUBL. 05/01/86

System Number:

CPS3390

User Access Name:

LFDEPEFFDT

Name:

DEPENDENT LIFE INSURANCE COVERAGE EFFECTIVE DATE

Type:

ALPHANUMERIC

Length:

6

Format:

MM/DD/YY - Inquiry Only; MMDDYY - Entry/Update

General Description:

The effective date of coverage for dependent life insurance.

Code Interpretation:

N/A

Comments:

Source - PPS

Level - Employee

Revision Date:

DRAFT 11/01/91

System Number:

CPS0147

User Access Name:

LFDEPPLN

Name:

DEPENDENT LIFE INSURANCE PLAN CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating the dependent life insurance plan the individual has selected.

Code Interpretation:

'Y'        - Basic plan

'S'        - Expanded plan, spouse only

'B'        - Expanded plan, spouse and child(ren)

'C'        - Expanded plan, child(ren) only

blank      - No dependent life insurance plan

Comments:

Source - PPS

Level - Employee

Revision Date:

System Number:

CPS0343

User Access Name:

DERPCT

Name:

DERIVED PERCENT TIME

Type:

NUMERIC

Length:

5

Format:

n.nnnn

General Description:

Percent of Time effort associated with an earnings pay distribution.

Code Interpretation:

Valid range is -1.0000 through 1.0000

Comments:

Source - PPS

Revision Date:

1/31/2008

System Number:

CPS0078

User Access Name:

CDOS

Name:

DESCRIPTION OF SERVICE CODE-CPS

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

Code indicating the type of service provided by the employee, as defined by the Corporate Personnel System (CPS) for reporting purposes.

Code Interpretation:

'AA' Additional Compensation - Consultant

'AB' Additional Compensation – Stipend (Covered Compensation)

'AC' Additional Compensation - Other

'AD' Additional Compensation - Research

'AE' Additional Compensation - Teaching & Summer Session

'AF' By Agreement

'AG' Call Back - Regular Time 

'AH' Call Back - Overtime at 1 and 1/2 Time

'AI' Call Back - Overtime at Double Time

'AJ' Call Back - Overtime at Triple Time

'AK' Compensatory Time Paid - Straight Time

'AL' Additional Compensation – Honorarium & Stipend (Uncovered Compensation)

'AM' Leave With Pay

'AN' Maritime Differential

'AO' On Call Time

'AP' Overseas Premium/Incentive Pay

'AQ' Overtime - Straight Time

'AR' Overtime - Time and One Half

'AS' Overtime - Double Time

'AT' Overtime - Triple Time

'AU' Perquisites

'AV' Regular Pay

'AW' Sabbatical Leave - In Residence

'AX' Sabbatical Leave - Not In Residence

'AY' Shift Differential

'AZ' Discretionary Performance Awards, Incentives, or Bonuses

'BA' Suspense

'BB' Terminal Vacation Payment

'BC' Without Salary

'BD' Call Back - Straight Overtime

'BE' Overtime - Half

'BF' Specialty Pay - Police

'BG' Severance Pay

'BR' Hiring Bonus

'CD' Consecutive Days Worked Premium

'CN' Charge Differential (formerly Charge Nurse Differential)

'DB' Temporary Reduction Base

'DD' Temporary Reduction Differential

'DS' Temporary Reduction Stipend

'EA' Employment Allowances

'EP' External Pay - Paid outside PPS but used in Postdoctoral Scholars Dues Calculation

'HC' Differential - Health Science - Suspense

'HD' Health Sciences Comp Plan - Base Pay - APU Scale Differential

'HO' Health Sciences Comp Plan - Bonus/Incentive Pay - Other/ Non-clinical

'HP' Holiday Premium

'HR' Regular Pay - Health Science

'HS' Salary Disclosure - Health Science

'HT' Regular Time - Health Science - Suspense

'HY' Health Sciences Comp Plan - Negotiated Component

'HZ' Health Sciences Comp Plan - Bonus/Incentive Pay - Clinical/ DEFAULT

'LS' Mass Lump Sum Payments

'LV' Leave (Vacation, Sick, Comp Time, etc.)

'MI' Military Leave - Special Payment

'NB' Non-Base Pay

'ND' Non-Discretionary Performance Awards, Incentives, or Bonuses

'RB' Retirement Benefits Allowance

'RP' Voluntary Program Reduction - Stipend

'RS' Voluntary Program Reduction - shift differential

'RT' Voluntary Program Reduction

'SO' Shift Differential - Overtime Straight

'SP' Shift Differential - Overtime Premium

'TF' Taxable Fringe Benefits – Not for Service

'TI' Termination-Involuntary

'TR' Miscellaneous Transfer of Expenses

'TV' Termination-Voluntary

'XX' By Agreement-Hours Only

'ZZ' Other

Comments:

Source - PPS

Level - Distribution

DOS Code must be used in conjunction with FTE (MONFTE), Hours Worked (MONHRS), Monthly Pay (MONGRS) when there is a need to exclude additional fte/pay such as shift differential, overtime, incentive awards, severance pay, perquisites, etc. Regular Pay is defined as values 'AV' and 'HR'. Base Pay is defined as values 'AV', 'AM', 'AW', 'AX', 'HD', and 'HR'. Base FTE is defined as values 'AV', 'AM', 'AW', 'AX', 'HD', 'HR' and 'HY'.
**  HD was added to the list of base pay DOS codes effective July 1, 2007.

Revision Date:

August 21, 2014

System Number:

CPS0898

User Access Name:

PDOS

Name:

DESCRIPTION OF SERVICE CODE-PPS

Type:

ALPHANUMERIC

Length:

3

Format:

N/A

General Description:

Code indicating the type of service or type of pay associated with an earnings distribution.

Code Interpretation:

See Description of Service Table.

Comments:

Source - PPS

Level - Distribution

Revision Date:

System Number:

CPS0918

User Access Name:

DSTPAYRT

Name:

DISTRIBUTION PAY RATE

Type:

NUMERIC

Length:

10

Format:

nnnnnn.nnnn

General Description:

The full time rate of pay (hourly, monthly, or by-agreement amount) associated with the distribution.

Code Interpretation:

N/A

Comments:

Source - PPS

Level - Distribution

Usage - D11.4

Revision Date:

PUBL. / /

System Number:

CPS0891

User Access Name:

CDISTRT

Name:

DISTRIBUTION RATE CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating the nature of the rate of pay for the distribution.

Code Interpretation:

'H' - Hourly rate

'A' - Pay period amount

Comments:

Source - PPS

Level - Distribution

Use Distribution Rate Code with Distribution Pay Rate to identify hourly versus monthly rates

Revision Date:

System Number:

Name:

Type:

Length:

Format:

General Description:

Code Interpretation:

Comments:

Revision Date:

System Number:

CPS3590

User Access Name:

ERN_TRANS_CD

Name:

EARNINGS TRANSACTION CODE

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

Code indicating the type of transaction associated with the Earnings Distribution-PAR.

Code Interpretation:

AP      Additional pay

AU     Automatic pay

C2      Cancellation

E1       Expense transfer 1

E3       Expense transfer 3

FT       One-time payment

H2       Hand-Drawn

LX       Late time or leave

O2       Overpayment

RA       Retroactive pay

RX       Reduction in pay or leave

R2        Rush Check

ST        Payment in lieu of notice

TE        Exception time

TX        Positive time

Comments:

Source - PPS

Level - Distribution (from PAR)

Revision Date:

August 2012

System Number:

CPS0920

User Access Name:

CEDFLD

Name:

EDUCATION FIELD CODE

Type:

ALPHANUMERIC

Length:

4

Format:

N/A

General Description:

Code indicating the field of study in which the employee's highest level of education was attained.

Code Interpretation:

0100 Agriculture & Natural Resources

0101 General Agriculture

0102 Agronomy

0103 Soils Science

0105 Environmental Studies

0107 Fish, Game & Wildlife Management

0108 Horticulture

0109 Ornamental Horticulture

0113 Food Science & Technology

0114 Forestry

0115 Natural Resources Management

0116 Agricultural & Forestry Technology

0117 Range Management

0120 Water Science

0199 Other Agriculture

0200 Architecture & Environmental Design

0201 General Environmental Design

0202 Architecture

0204 Landscape Arthitecture

0299 Other Architecture & Environmental

0300 Area Studies

0301 Asian Studies

0302 East Asian Studies

0304 Southeast Asian Studies

0305 African Studies

0307 Russian & Slavic Studies

0308 Latin American Studies

0309 Middle Eastern Studies

0310 European Studies

0313 American Studies

0320 Subsaharan Studies

0321 Saharan Studies

0322 Romance Studies

0323 Indo-European Studies

0399 Other Area Studies

0400 Biological Sciences

0401 General Biology

0402 General Botany

0403 Bacteriology

0404 Plant Pathology

0406 Plant Physiology

0407 Zoology

0408 Pathology, Human & Animal

0409 Pharmacology, Human & Animal

0410 Physiology, Human & Animal

0411 Microbiology

0412 Anatomy

0416 Molecular Biology

0418 Marine Biology

0420 Physical & Natural Ecology

0421 Entomology

0425 Neurosciences

0430 Bioradiology

0431 Genetics

0432 Marine Sciences

0433 Medical Biology

0434 Plant Science

0435 Psychobiology

0499 Other Biological Sciences

0500 Business & Management

0502 Accounting

0506 Business Management & Administration

0509 Marketing

0520 Agricultural Economics

0521 Agricultural Science & Management

0522 Business, Commerce & Distributive

0523 Business Management

0524 Finance

0525 Industricl & Management Engineering

0526 Organization Theory

0599 Other Business & Management

0600 Communications & Performing Arts

0610 Visual Communications

0611 Oral Communications

0612 Media - Journalism

0613 Media - Other

0614 Performing Arts - Dramatic Arts

0615 Performing Arts - Dance

0699 Other Comm. & Perf. Arts

0700 Computer & Information Sciences

0701 Computer & Information Sciences

0710 Librarianship

0799 Other Computer & Information Sci

0800 Education

0801 General Education

0802 Elementary Education

0803 Secondary Education

0807 Adult & Continuing Education

0821 History of Education

0822 Educational Psychology

0826 Guidance, Counseling & Student Per

0827 Educational Administration

0835 Physical Education

0850 Educational Measurement & Statistic

0851 Higher Education Administration

0852 Kinesiology

0853 Special Education - Disabilities

0854 Speech Education

0855 Vocational Education

0899 Other Education

0900 Engineering

0901 General Engineering

0902 Aerospace, Aeronautical & Astronaut

0903 Agricultural Engineering

0905 Bioengineering & Biomedical Eng

0906 Chemical Engineering

0908 Civil, Constr & Transportation Eng

0909 Electrical, Electronics & Comm. Eng

0910 Mechanical Engineering

0911 Geological Engineering

0913 Industrial & Management Eng

0914 Metallurgical Engineering

0915 Materials Science & Engineering

0919 Engineering Physics

0920 Nuclear Engineering

0921 Engineering Mechanics

0922 Environmental & Sanitary Eng.

0923 Naval Arthitecture & Marine Eng.

0924 Ocean Engineering

0940 Applied Mechanics & Eng. Sciences

0941 Applied Science

0942 Ceramic Engineering

0943 Computer Engineering

0944 Medical Engineering

0945 Operations Research

0999 Other Engineering

1000 Fine & Applied Arts

1001 General Fine Arts

1002 Art

1004 Music

1007 Dramatic Arts

1008 Dance

1099 Other Fine & Applied Arts

1100 Foreign Languages

1102 French

1103 Germanic Languages

1104 Italian

1105 Spanish

1106 Russian

1107 Chinese

1108 Japanese

1109 Latin

1110 Greek, Classical

1111 Hebrew

1112 Arabic

1113 Indian (Asiatic)

1114 Scandinavian Languages

1115 Slavic Languages & Lit

1116 African Languages (Non-Semitic)

1120 Near Eastern Lang. & Lit or Culture

1122 Portuguese

1123 Persian Lang & Lit

1199 Other Foreign Languages

1300 Home Economics

1301 General Home Economics

1303 Clothing & Textiles

1304 Consumer Economics & Home Mgmt

1305 Family Relations & Child Development

1306 Foods & Nutrition

1310 Consumer Science

1399 Other Home Economics

1400 Law

1401 General Law

1499 Other Law

1500 Letters

1502 English Literature

1504 Classics

1505 Linguistics

1507 Creative Writing

1509 Philosophy

1510 Jewish Studies

1511 Islamic Studies

1512 Buddhist Studies

1513 Religious Studies

1521 American Literature

1522 Comparative Literature

1523 European Literature

1524 Folklore & Mythology

1525 Other Composition

1526 Discourse Analysis

1527 Debate

1528 Forensics

1599 Other Letters (Humanities)

1700 Mathematics

1701 General Mathematics

1703 Applied Mathematics

1710 Algebra

1711 Applied Statistics

1712 Biostatistics

1713 Computing Theory & Practice

1714 Geometry

1715 Medical Mathematics

1716 Statistics

1799 Biomathematics

1900 Physical Sciences

1902 Physics

1905 General Chemistry

1906 Inorganic Chemistry

1907 Organic Chemistry

1908 Physical Chemistry

1909 Analytical Chemistry

1911 Astronomy

1913 Atmospheric Sciences & Meteorology

1914 Geology

1916 Geophysics & Seismology

1918 Paleontology

1919 Oceanography

1920 Metallurgy

1930 Agricultural Chemistry

1931 Applied Science

1932 Biochemistry

1933 Biophysics

1934 Chemical Engineering

1935 Endocrinology

1936 Engineering Physics

1937 Fuel Technology & Petroleum Eng.

1938 Fluids

1939 General Physical Sciences

1940 Earth Sciences

1941 Geochemistry

1942 Geophysics & Space Physics

1943 Medical Chemistry

1944 Minerology, Petrology

1945 Nuclear Chemistry

1946 Nuclear Structure

1947 Physical Anthropology

1948 Solid State Physics

1949 Structural Geology

1950 Toxicology

1990 Other Physics

1991 Environmental Chemistry

1992 Other Earth Sciences

2000 Psychology

2001 General Psychology

2002 Experimental Psychology

2003 Clinical Psychology

2004 Counselling & Guidance

2005 Social Psychology

2008 Industrial Relations

2009 Developmental Psychology

2010 Physiological Psychology

2099 Other Psychology

2100 Public Admin & Public Policy

2102 Public Administration

2120 City, Community & Regional Planning

2121 Comparative Administration

2122 Hospital Administration

2123 Public Policy

2124 Social Work

2199 Other Pub Admin & Pub Policy

2200 Social Sciences

2201 General Social Sciences

2202 Anthropology

2203 Archaeology

2204 History

2206 Geography

2207 Political Sciences & Government

2208 Sociology

2209 Criminology/Criminal Justice

2210 International Relations

2211 Afro-American Studies

2212 Native American Studies

2213 Urban Studies

2215 Demography

2220 Agricultural Economics

2221 American History

2222 American Studies

2223 Art History

2224 Business Economics

2225 Consumer Economics

2226 Economics

2227 European History

2228 Medical Sociology

2229 Music History

2230 Social Ecology

2231 Cultural Studies

2232 Asian-American Studies

2233 Comparative Culture

2234 Women's Studies

2235 Chicano History

2298 Other History

2299 Other Social Sciences

2300 Library Science & Information Sci

2400 Dentistry

2500 Medicine

2501 Ambulatory & Community Medicine

2502 Anatomy

2503 Anaesthesiology

2504 Biochemistry Biological Chem & Bio

2505 Bioethics

2506 Clinical Pathology & Labratory Med

2507 Dermatology

2508 General Medicine

2509 Genetics

2510 Hermatology

2511 Internal Medicine

2512 International Health

2513 Microbiology & Immunology

2514 Neurological Surgery

2515 Neurology

2516 Obstetrics & Gynecology

2517 Ophthalmology

2518 Orthopedic Surgery

2519 Otolaryngology

2520 Paramedics

2521 Pathology

2522 Pediatrics

2523 Pharmacology

2524 Physical Medicine & Rehabilitation

2525 Physiology

2526 Plastic Surgery

2527 Psychiatry

2528 Psychology

2529 Radiology

2530 Reproductive Medicine

2531 Surgery, General

2532 Thoracic Surgery

2533 Urology

2599 Other Medicine

2600 Nursing

2601 Biological Dysfunction

2602 Family Health Care

2603 Mutual Health Care & Community Nursing

2699 Other Nursing

2700 Optometry

2800 Pharmacy

2801 Clinical Pharmacy

2802 Pharmacy Instruction

2899 Other Pharmacy

2900 Podiatric Medicine

3000 Public Health

3001 Biomedical & Environ Health Sci

3002 Social & Admin Health Sciences

3099 Other Public Health

3100 Veterinary Medicine

3101 Anatomy of Animals

3102 Animal Resources Service

3103 Clinical Pathology of Animals

3104 Epidemiology & Preventive Med.

3105 Veterinary Medicine

3106 Pathology of Animals

3107 Physiological Sciences

3108 Radiological Sciences

3109 Reproduction

3110 Special Clinical Instruction

3111 Surgery

3199 Other Veterinary Medicine

3200 History of Medical Science

Comments:

For selected academic appointees.

Source - Academic File

Level - Employee

Revision Date:

April 16, 1998

System Number:

CPS0920

User Access Name:

CEDFLD

Name:

EDUCATION FIELD CODE

Type:

ALPHANUMERIC

Length:

4

Format:

N/A

General Description:

Code indicating the field of study in which the employee's highest level of education was attained.

Code Interpretation:

0100 Agriculture & Natural Resources

0101 General Agriculture

0102 Agronomy

0103 Soils Science

0105 Environmental Studies

0107 Fish, Game & Wildlife Management

0108 Horticulture

0109 Ornamental Horticulture

0113 Food Science & Technology

0114 Forestry

0115 Natural Resources Management

0116 Agricultural & Forestry Technology