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

Data Elements in the Personnel Data Warehouse Per_Lab_Curr, _Prior, and _All 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
  
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
  
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
  
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
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_Worked_YTD OTHRSWKYTD
9
  
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
  
Sex_Code CSEX
1
  
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
  
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
  
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
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
Appointment Table Data
Location_1 CCAMPUS
2
  
Employee_Number EMPNO
9
  
Title_Code CTITLE
4
  
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_Type_Code CAPTTYP
1
  
FLSA Status Code
 FLSASTAT
1
Overtime_Exempt_Status_Code OTEXEMP
1
  
Pay_Schedule_Code CPAYSKED
2
  
Pers_Pgm PERSPGM (Defined)
1
 Identifies the personnel program for the title by its acronym (MSP, SMG, PSS, or ACA). Does not apply to lab titles.
Time_Appt_Anticipated APTPCT
5
  
Title_Name TITLE
30
  
Title_Unit_Code_PPS TUC
2
  
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_Code_PPS PDOS
3
  
Distrib_Pay_Rate DSTPAYRT
10
  
Distrib_Rate_Code CDISTRT
1
  
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.
Time_Distrib_Actual MONFTE
5
  
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
UCRS_Gross_Ind UCRSGROSIND
1
 Indicates whether earnings are included in retirement covered compensation
Ret_Covcomp RETCOVCOMP (defined)
16
 Retirement covered compensation earnings
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
Address Table Data
Employee_Name_Addr EMPNAME
35
  
Social_Security_Name_Addr SOCSECNO
9
  
Home_Address_Line_1 PERMADR1
30
  
Home_Address_Line_2 PERMADR2
30
  
Home_Address_City PERMCITY
21
  
Home_Address_State PERMSTATE
2
  
Home_Address_Zip PERMPOST
5
  
Home_Address_Disclosure ADRDISCIND
1
  
Work_Address_Line_1 MAILADR1
30
  
Work_Address_Line_2 MAILADR2
30
  
Work_Address_Campus MAILCAMPUS
13
  
Work Address City St Cntry MAILCSC
30
  
Work_Address_Zip MAILPOST
10
  
Work_Email EMAILADD
50
 Not populated for LBL, Hastings or ASUCLA
Email_Address EMAILADD (in Address database)
50
 The employee's work email address, as contained in the Telecom file