Overview

Types of Data Stored in the Corporate Personnel System (CPS) Fiscal Year and Snapshot Databases and Data Warehouse Tables

Employee Data:

Demographic data

Examples: employee name, birthdate, social security number, gender, citizenship status, ethnicity

Employment data

Examples: date of original hire, date of most recent hire, UC student status code, separation date, prior year taxable gross income, primary title code, and employee organization codes

Benefits data

Examples: assigned BELI (Benefits Eligibility Indicator), derived BELI, medical plan code/effective date/coverage code, employee-paid disability plan code/effective date/coverage code/salary base, retirement system code, and UC-paid life insurance coverage code/effective date

Appointment Data:

Appointment data specific to the employee that is stored in the payroll system

Examples: title code, appointment begin and end dates, title unit code, pay schedule code, anticipated time appointed, appointment pay rate, salary step, appointment rate code, FLSA status code

Appointment data from the Title Code System (TCS), matched by title code and campus

Examples: off/above scale code, title name, class title outline (CTO), federal occupation subcategory code (FOCSUB), standard occupational class (SOC), overtime exemption status code, salary range minimum, midpoint, and maximum

Distribution Data:

Earnings data from the payroll system

Examples: location code 2 (local campus or systemwide) location code 3 (general campus or health sciences), account number, fund number, description of service (DOS) code (regular pay, overtime, shift differential, etc), title code applicable to the pay, gross earnings, hours paid, FTE, systemwide administrative unit (SAU) code (DANR, Universitywide academic program, Office of the President, Regents Officers, University Programs, etc).

Account and fund attributes from the Corporate Account Fund Profile (CAF), matched by campus and account or fund number

Examples: account group code (Instruction, Teaching Hospitals, Libraries, Institutional Support, etc.), fund group code (General funds, tuition and fees, special state appropriations, etc), function (derived from account group), budgeted fund code, and organizational codes (division, department, and unit)