Skip to content
  1. Home > Subject Areas > Data Elements in the Personnel Data Warehouse Per_Snap_Curr, _Prior, and _All Tables

Data Elements in the Personnel Data Warehouse Per_Snap_Curr, _Prior, and _All Tables

This is a view which combines data from the Employee, Appointment, and Distribution Tables

Click on data element name for CPS data dictionary information
Data Element Name CPS FOCUS Name
Size
 Comment
Employee Table Data
Eff_Date CYCLE
7
 Different format from CYCLE in CPS. MAR2001 rather than MAR01.
Location_1 CCAMPUS
2
  
Employee_Number EMPNO
9
  
ADD_Coverage_Code CADCVG
1
  
ADD_Eff_Date ADEFFDT
6
 MM/DD/YY
ADD_Principal_Sum ADPRINSUM
3
  
Active_This_Month_Empl EMPACTIVT
1
  
Age AGE
2
  
Appt_Type_Code_Pri APTYPRI
1
  
Avg_Paid_Hours_Wk AVGHRSWK
4
  
BELI_Confl_Dte BELICDT
4
 YYMM
BELI_Asgnd BELIASI
1
  
BELI_Derivd BELIDER
1
  
Ben_Rep_Cd BEN_REP_CD

1

 Code indicating whether the predominant appointment of an individual is eligible to be represented for benefit purposes.
Ben_Unit_Code BEN_UNIT_CODE

2

 Code indicating Title Unit Code of the predominant appointment for benefits purposes
Ben_Unit_Der BEN_UNIT_DER

1

 Code indicating whether Benefits Unit Elig  and Rep Codes should be derived by PPS
Campus_Name_Abr CAMPUS
2
  
Citizenship_Status_Code CCITSTAT
1
  
Class_Ttl_Outl_Code_Pri CCTOA
3
  
Class_Ttl_Outl_Name_Pri CTOA
30
  
Collective_Barg_Unit_Code CCBU
2
  
Country_of_Origin Name COUNTRYRES
30
  
Country_of_Origin_Code CCOUNTRYRES
2
  
Date_of_Birth BDATE
6
  
Date_of_Most_Recent_Hire EMPDT
6
  
DCP_Fund_Selection_Code DCPFUND
1
  
Dental_Plan_Code CDENTPLN
2
  
Dental_Plan_Cov_Code CDENTCVG
3
  
Dental_Plan_Eff_Date DENTEFFDT
6
 MM/DD/YY
Dental_Plan_Name not in CPS
21
 translation of Dental Plan Code
Dep_Care_Ded_YTD YTDDEPDE
7
  
Dep_Care_Salary_Red_Plan DEPCAREPLN
1
  
Dep_Life_Cov_Eff_Date LFDEPEFFDT
6
 MM/DD/YY
Dep_Life_Ins_Plan_Code LFDEPPLN
1
  
Education_Field_Code CEDFLD
4
  
Education_Field_Name not in CPS
35
 translation of CEDFLD
Education_Inst_Code CEDINST
3
  
Education_Level_Code CEDLVL
1
  
Education_Level_Year EDLVLYR
2
  
Empl_Org_Code_Dues_Ben1 CEMPORG1
4
  
Empl_Org_Code_Dues_Ben2 CEMPORG2
4
  
Empl_Org_Code_Dues_Ben3 CEMPORG3
4
  
Empl_Org_Code_Dues_Ben4 CEMPORG4
4
  
Empl_Org_Ded_Type1 CDEDTYP1
1
  
Empl_Org_Ded_Type2 CDEDTYP2
1
  
Empl_Org_Ded_Type3 CDEDTYP3
1
  
Empl_Org_Ded_Type4 CDEDTYP4
1
  
Empl_Org_Name1 EMPORG1
34
  
Empl_Org_Name2 EMPORG2
34
  
Empl_Org_Name3 EMPORG3
34
  
Empl_Org_Name4 EMPORG4
34
  
Empl_Pd_Dis_Ins_Eff_Date EDISEFFDT
6
 MM/DD/YY
Empl_Pd_Dis_Ins_Plan_Code EDISPLN
1
  
Empl_Pd_Dis_Ins_Base_Amt EDISBSAMT
5
  
Empl_Pd_Dis_Ins_Wait_Per EDISWTPER
3
  
Empl_Rel_Code CHEERA
3
  
Empl_Rel_Confid_Code EMPRELCONF
1
  
Empl_Rel_Pos_Type_Code CEMPRELPOS
1
  
Empl_Represent_Code CEMPREP
1
  
Empl_Unit_Code EUC
2
  
Employee_Name EMPNAME
35
  
Employment_Status_Code CEMPSTAT
1
  
Ethnic_Origin_Abbr CGETH
2
  
Ethnic_Origin_Code CETHNIC
2
  
Exec_Sev_Pay_Recent_Mo_Cont EXSPCMCONT
9
 no longer used
Exec_Sev_Pay_Tot_Cont_And_Int EXSPCONTP
9
 no longer used
Exec_Sev_Pay_Tot_Cont_No_Int EXSPCONTNP
9
 no longer used
Exec_Sev_Pay_Tot_Int EXSPINTR
9
 no longer used
Exec_Sev_Pay_YTD_Total YTDSEVPAY
13
 no longer used
FICA_Medicare_Elig_Code FICADED
1
  
FOCSUB_Pri FEDOCPRI
2
  
Future_Institution_Code CFUTINST
3
  
Handicapped_Status_Code CHNDCPSTAT
1
  
Highly_Comp_Flag HCLFLAG
1
  
Home_Address_Discl_Code ADRDISCIND
1
  
Home_Department_Code CHOMEDEPT
6
  
Home_Department_Name HOMEDEPT
30
  
Last_Day_On_Pay_Status LPAYDT
6

MM/DD/YY
Leave_Of_Abs_Beg_Date LOABEGDT
6
 MM/DD/YY
Leave_Of_Abs_Rtn_Date LOARETDT
6
 MM/DD/YY
Leave_Of_Abs_Type_Code CLOATYP
2
  
Legal_Plan_Code CLGLPLN
2
  
Legal_Plan_Cov_Code CLGLCVG
3
  
Legal_Plan_Eff_Date LGLEFFDT
6
 MM/DD/YY
Legal_Plan_Name Not in CPS
21
 Translation of Legal Plan Code
Life_Ins_Cov_Amt_Empl Not in CPS
9
 Calculated from LFBASAMT
Life_Ins_Cov_Eff_Date_Empl LFEFFDT
6
 MM/DD/YY
Life_Ins_Cov_Eff_Date_UC LFEFFDTUC
6
 MM/DD/YY
Life_Ins_Exec_Cov_Code EXECLFPLN
1
  
Life_Ins_Exec_Eff_Date EXECLFEFFDT
10
  
Life_Ins_Exec_Salary_Base EXECLFAMT
3
  
Life_Ins_Plan_Code CLFPLN
1
  
Life_Ins_Salary_Base_Empl LFBASAMT
3
  
Life_Ins_Salary_Base_UC LFBASAMTUC
3
  
Location_10_Empl LOC10
5
  
Location_11_Empl LOC11
5
  
Med_Ins_Plan_Code CHPPPLN
2
  
Med_Ins_Plan_Cov_Code CHPPCVG
3
  
Med_Ins_Plan_Cov_Eff_Date HPPEFFDT
6
 MM/DD/YY
Medical_Plan_Name not in CPS
21
 Translation of Med Ins Plan Code
Merced_Employee_Ind MER
1
 "M" if Merced employee
Merit_Pct MERITPCT
4
  
Multiple_Appt_Code MULTAPPT
1
  
Next_Salary_Rev_Date SALREVDT
4
 MM/YY
Next_Salary_Rev_Type_Code CSALREVTYP
1
  
Opt_Out_Ind_Dental DENOPTOUT
1
  
Opt_Out_Ind_Medical MEDOPTOUT
1
  
Opt_Out_Ind_Optical VISOPTOUT
1
  
Optical_Plan_Code CVISPLN
2
  
Optical_Plan_Cov_Code CVISCVG
3
  
Optical_Plan_Cov_Eff_Date VISEFFDT
6
 MM/DD/YY
Optical_Plan_Name Not in CPS
21
 Translation of Optical Plan Code
Original_Date_of_Hire ORIGHIREDT
6
 MM/DD/YY
OT_Hours_Paid_Month OTHRSPD
5
  
OT_Hours_Worked_Month OTHRSWK
5
  
OT_Hours_Worked_YTD OTHRSWKYTD
9
  
Personnel_Action_Code1 CPERACT1
2
  
Personnel_Action_Code2 CPERACT2
2
  
Personnel_Action_Code3 CPERACT3
2
  
Personnel_Action_Code4 CPERACT4
2
  
Personnel_Action_Code5 CPERACT5
2
  
Personnel_Action_Date PERACTDT
6
 MM/DD/YY
Personnel_Program_Primary PROGPRI
1
  
Prior_Institution_Code CPRINST
3
 Only used for faculty
Prior_Service_Code CPRSVC
1
  
Prior_Service_Months PRSVCMOS
3
  
Retirement_System_Code CRETSYS
1
  
Separated_Empl_Dest_Code CEMPDEST
1
  
Separation_Date SEPDT
6
 MM/DD/YY
Separation_Rsn_Code CSEPRSN
2
  
Separation_Rsn_Code_Acad CSEPRSNA
2
  
Sex_Code CSEX
1
  
Sick_Lv_Hours_Bal SICKHRSBAL
5
  
Sick_Lv_Hours_Used_Month SICKHRS
3
  
Social_Security_Number SOCSECNO
9
  
Taxable_Gross_Cal_YTD YTDFWTGR
9
  
Taxable_Gross_Cal_Prior PRYTDFWT
9
  
Taxable_Gross_Fiscal_YTD FYTDFWTG
9
  
Temp_Dis_Ins_Code CNDIPLN
1
  
Temp_Dis_Ins_Eff_Date NDIEFFDT
6
 MM/DD/YY
TIP_Enrollment CINSRED
1
  
Title_Code_Pri_Appt TITLEPRI
4
  
Title_Code_Pri_Appt_PPS PRITPPS
4
  
Total_Gross_Cal_YTD YTDTOTGR
9
  
Total_Gross_Cal_YTD_Prior PRYTDTOT
9
  
UC_Student_Status_Code CUCSTUDENT
1
  
UCOP_Employee_Ind COP
1
  
UCRS_Vol_Long_Term_Loan_Pln VLPLTERM
1
  
UCRS_Vol_Shrt_Term_Loan_Pln VLPSTERM
1
  
Unemployment_Ins_Cov_Code UNINSCVG
1
  
Vacation_Lv_Hours_Bal VACHRSBAL
3
  
Vacation_Lv_Hours_Used_Mo VACHRS
3
  
Vacation_Lv_Hours_Lost VACHRSLOST
5
  
Veteran_Dis_Status_Code CVETDISAB
1
  
Vietnam_Era_Vet_Status_Code CVETSTAT
1
  
Visa_Type VISATYPE
2
  
WCE_Vet_Status_Code WCEVETSTAT
1
  
Years_Of_Service SERVICE
2
  
Pri_BELI_Status_Qual_Code BELISQC1
2
  
Pri_BELI_Status_Qual_Date BELISQD1
6
 YY/MM/DD
Sec_BELI_Status_Qual_Code BELISQC1
2
  
Sec_BELI_Status_Qual_Date BELISQD1
6
 YY/MM/DD
Num_Hrs_Reg_UC_Units NUMREGUC
4
 1 decimal place
Retire_FICA_Deriv_Ind RETDEVIND
1
  
Hrs_Toward_Career_Elig CARELHRS
11
 2 decimal places
Hrs_Toward_Benefits_Elig BENELHRS
11
 2 decimal places
Med_Contri_Base_Curr_Yr MEDBASCUR
3
 Annual base salary divided by 1000
Med_Contri_Base_Next_Yr MEDBASNXT
3
 Annual base salary divided by 1000
Sep_Vet_Date SEPVETDT
4
 YY/MM
HCRA_Indicator HCRAIND
1
 "Y" if enrolled in HCRA program
HCRA_Annual_Amount HCRAAMT
7
 no decimals; this is the planned HCRA deduction amount for the year
HCRA_Termination_Date HCRATDT
6
  
HCRA_YTD_Deductions HCRAYTD
11
 2 decimal places; this is the total HCRA deductions as of the end of the cycle month
START Reduction Percent STARTPCT
2
  
START Begin Date STARTBEGDT
6
 YY/MM/DD
START End Date STARTENDDT
6
 YY/MM/DD
Sr_Mgmt Sev Pay_Exc_Ind SMSEVEXCIND
1
 Y or N
Sr_Mgmt Over Contr Rate SMSEVORCNRT
1
  
Depcare_Annual_Amt DEPANNAMT
5
 Estimated annual Depcare amount
Depcare_Term_Date DEPTERMDT
6
 Depcare end date
Home_zip PERMPOST
5
  
Loc_Indicator LOCIND
1
 Code for the campus location assigned to home department code, such as medical center, Merced, UCOP, CEB, etc.
Loc_Ind_Description LOCINDNM (defined)
20
 Translation of Loc_Indicator
Emp_Location EMPLOC (defined)
13
 Location based on employee's Loc_Indicator; medical centers, UCOP, and ANR are all differentiated from campus.
OP_DANR_Location OPANRLOC (defined)
12
 Indicates whether the DANR or UCOP location is at a campus or at the Oakland systemwide office
Primary_Perspgm PRIPERPG (defined)
3
 Identifies the personnel program for the primary title by its acronym (MSP, SMG, PSS, or ACA)
Email_Address EMAILADD (in Address database)
50

The employee's work email address, as contained in the Telecom file
Medical_Premium_Emp_Paid Not in CPS

7

The employee-paid premium for medical coverage, based on medical plan, coverage code, and medical contribution base.
Medical_Premium_UC_Paid Not in CPS

7

The UC-paid premium for medical coverage, based on the employee's  medical plan, coverage code, and medical contribution base.
Medical_Premium_Tot Not in CPS

7

The total premium for medical coverage, based on the employee's  medical plan, coverage code, and medical contribution base.
Dental_Premium_Emp_Paid Not in CPS

7

The employee-paid premium for dental coverage, based on dental plan and coverage code.  Currently the dental premium is paid entirely by the University.
Dental_Premium_UC_Paid Not in CPS

7

The UC-paid premium for dental coverage, based on dental plan and coverage code.  Currently the dental premium is paid entirely by the University.
Dental_Premium_Tot Not in CPS

7

The total premium for dental coverage, based on dental plan and coverage code.  Currently the dental premium is paid entirely by the University.
Optical_Premium_Emp_Paid Not in CPS

7

The employee-paid premium for optical coverage, based on vision plan and coverage code.  Currently the optical premium is paid entirely by the University.
Optical_Premium_UC_Paid Not in CPS

7

The UC-paid premium for optical coverage, based on vision plan and coverage code.  Currently the optical  premium is paid entirely by the University.
Optical_Premium_Tot Not in CPS

7

 The total premium for optical coverage, based on vision plan and coverage code.  Currently the optical premium is paid entirely by the University.
WOS_Emp WOS_CODE

1

 The employee has only without salary appointments, no appointments with salary.
Postdoc POST_DOC

1

 Indicates whether the employee has any postdoctoral scholar appointment.
Special_Training_Code SPECTRNG

1

 Indicates whether the employee should be included in Sexual Harassment Training extract for Workplace Answers.
SLCG_Grade SLCG_GRADE

3

 Code indicating the Senior Leadership Compensation Group (SLCG) for an employee. Valid values are 102-118 and 999.
SLCG_Eff_Date SLCG_EFFDT

10

 Effective Date of the employee Senior Leadership Compensation Group (SLCG) grade.
Armed Forces Svc Medal AF_SVC_MEDAL

1

 Code indicating whether an individual was awarded a service medal while on active duty in a US military operation.
Appointment Table Data
Title_Code CTITLE
4
  
Sub_Location SUBLOC
2
  
Academic_Appt_Basis_Code CACAPTBAS
1
  
Academic_Appt_Type_Code CACAPTTYP
1
  
Academic_Pay_Period_Code CACPAYPER
1
  
Academic_Rank_Code CACRANK
1
  
Academic_Service_Limit ACSVCLIM
2
  
Academic_Sick_Lv_Elig_Code ACSICKELIG
1
  
Active_This_Month_Appt APTACTIVT
1
  
Appt_Basis_Code APTBASIS
2
  
Appt_Begin_Date APTBEGDT
6
 MM/DD/YY
Appt_End_Date APTENDDT
6
 MM/DD/YY
Appt_Pay_Rate APTPAYRT
10
  
Appt_Rate_Code CAPTRT
1
  
Appt_Rep_Code CAPTREP
1
  
Appt_Type_Code CAPTTYP
1
  
Appt_WOS_Ind CWOS
1
  
Bargaining_Type BARGAIN
1
  
By_Agreement_Code BYAGREE
1
  
Class_Ttl_Outl_Code_Appt CCTOB
3
  
Class_Ttl_Outl_Code_Appt1 Not in CPS
1
 First character of CCTOB
Class_Ttl_Outl_Code_Appt2 Not in CPS
1
 Second character of CCTOB
Class_Ttl_Outl_Name_Appt CTOB
30
  
Federal_Occup_Code FOC
1
  
FLSA Status Code FLSASTAT
1
  
FOCSUB CFOCSUB
2
  
Frozen_Title_Flag FROZNFLG
1
  
Leave_Accrual_Code_Sick CLVACCSICK
1
  
Leave_Accrual_Code_Vac CLVACCVAC
1
  
Linkage_Code CLINKAGE
3
  
Merit_Flag MERIT
1
  
Number_of_Whole_Steps NUMSTEPS
2
  
Off_Above_Scale_Code COFFABSCA
1
  
Overtime_Exempt_Status_Code OTEXEMP
1
  
Paid_Over_Code CPDOVER
2
  
Pay_Rep Not in CPS
3
 Used to join to TCS data - COV, UNC, ALL
Pay_Schedule_Code CPAYSKED
2
  
Payroll_Title_Unit_Rep_Code PTUC
5
  
Personnel_Program CAPTTYPT
1
  
Pers_Pgm PERSPGM (Defined)
1
 Identifies the personnel program for the title by its acronym (MSP, SMG, PSS, or ACA)
Related_99_TUC REL99
2
  
Representation_Flag REPIND
1
  
Restricted_Title_Flag RESTRFLG
1
  
Retirement_Code1 CRETIRE1
1
  
Retirement_Code2 CRETIRE2
1
  
Sabbatical_Accrual_Code SABACCR
1
  
Salary_Step_Grade SALMGTGD
2
 Combines salary step and grade in one field. All campuses used this field until 7/1/02; some continued submitting grade/step in this combined field until 2/04.
Salary_Step SALSTEP
4
 Formatted as 99.9
Grade_Type GRADETYPE

2

 The Grade type from the Title Code Table in PPS which is applicable to the title code.
Salary_Range_Maximum SALMAX
12
  
Salary_Range_Midpoint SALMID
12
  
Salary_Range_Minimum SALMIN
12
  
Staff_Step_Scale_Except_Flag STFEXCPFLG
1
  
Standard_Occup_Class_Code SOC
3
  
Supervisory_Flag SUPVFLAG
1
  
Time_Appt_Anticipated APTPCT
5
  
Title_Name TITLE
30
  
Title_Unit_Code_PPS TUC
2
  
Title_Unit_Code_TCS TUCT
2
  
Title_Unit_Code_TCS TUCT
2
  
Academic Senate Flag ACADSEN
1
 "Y" if the title is an Academic Senate title
Distribution Table Data
Location_2 CLOC2
1
  
Location_3 CLOC3
1
  
Account ACCTNO
6
  
Fund FUNDNO
5
  
Sub_Account CSUBACCT
2
  
DOS_Code_CPS CDOS
2
  
DOS_Desc_CPS Not in CPS
51
 Full Description of the CPS Dos code
Account_Group_Code ACCTGROUP
6
  
DOS_Code_PPS PDOS
3
  
DOS_Desc_PPS Not in CPS
25
 Full Description of the PPS Dos code
Dos_Obj_Code_Acad Not in CPS 4 Object code associated with academic salary activity
Dos_Obj_Code_Staff Not in CPS 4 Object code associated with staff salary activity
Distrib_Pay_Rate DSTPAYRT
10
  
Distrib_Rate_Code CDISTRT
1
  
Function_Code FUNCTION
2
  
Function_Name FUNCT
30
  
Fund_Group_Code FUNDGROUP
6
  
Gross_Earnings_Pay_Per MONGRS
7
  
Hours_Paid_Pay_Per MONHRS
5
  
Location_10_Dist 10LOC
5
 Does not differentiate ANR or Merced.
Location_11_Dist 11LOC
5
 Does not differentiate Merced.
Org_1_Code CORGGRP
7
 Differs from ORG 1 in Financial tables - the campus code is affixed to the beginning of the code - e.g., ORG1 code 4300 at UCLA is coded 44300.
Org_1 Title ORGGRP
30
  
Org_2 Code CORG2
7
  
Org_2 Title CORG2NM
30
  
Org_3 Title ORGUNIT
30
  
Org_3 Code CORGUNIT
7
  
SAU_Code SAU
1
  
Time_Distrib_Actual MONFTE
5
  
UAS_Discipline_Code CUASDISC
3
  
UAS_Discipline_Name UASDISC
35
  
Loc_Code Not in CPS
2
 Used for sorting locations in specific order- 22 locations including AG, OP, and campus medical centers
Locnm_2 Not in CPS
2
 2-character location abbreviation-includes OP and AG. Medical centers not differentiated
Locnm_5 Not in CPS
5
 5-character location abbrev-includes PRES, ANR, and campus medical centers
Locnm_13 Not in CPS
13
 13-character location abbrev-includes PRES, ANR, and campus medical centers
Locnm_Comp Not in CPS
5
 5-character location abbrev-includes PRES, ANR, and campus medical centers.  At UCLA and Davis, the School of Medicine is included in the Medical Center.
Budg_Fund BDGTCODE

1

 "B" indicates that the fund is incorporated into the annual UC budget
FWT_Gross_Ind Not in CPS
1
 Indicates whether earnings are subject to federal withholding tax
Total_Gross_Ind Not in CPS 1 Indicates whether earnings are included in total gross earnings
UCRS_Gross_Ind UCRSGROSIND
1
 Indicates whether earnings are included in retirement covered compensation
Ins_Ben_Ind Not in CPS 1 Code indicating whether the pay rate associated with a Description of Service is included in the annual recalculation of benefits bases
Time_Ben_Ind Not in CPS 1 Code indicating whether or not the hours associated with a Description of Service are included in Hours Toward Leave Accrual
Pay_Stat_Ind Not in CPS 1 Code indicating whether or not the hours associated with a Description of Service are included in Hours on Pay Status
Ret_Covcomp RETCOVCOMP (defined)
16
 Retirement covered compensation earnings
Ret_Cov_Cmp_FTE Not in CPS 16 The FTE associated with earnings which are considered covered compensation for the purposes of UCRP
Fed_Tax_FTE Not in CPS 16 The FTE associated with earnings which are subject to federal tax withholding
Fed_Tax_Gross Not in CPS 16 Total gross earnings which are subject to federal tax withholding
Payment_Category_Code PAYCAT
1
 Code indicating payment category associated with earnings, such as regular, leave, additional pay, etc.
Payment_Category PAYCAT_DESC (defined)
20
 Translation of Payment Category Code
Type_Hours TYPEHOURS
1
 Code indicating type of hours such as regular, overtime, non-worked, etc.
Type_of Hours TYPEHRS (defined)
16
 Translation of Type Hours code
Fundsource FUNDSOURCE (defined)
21
 Fundsource category assigned to the fundgroup associated with the payment
Fundsort FUNDSORT (defined)
1
 Field used to sort Fundsource into preferred order
Derived Pct DERPCT n.nnnn Derived percent for purposes of Effort Reporting