Data Elements in the Personnel Data Warehouse Per_FY_Curr_Empl and _All_Empl Tables
Click on data element name for CPS data dictionary information
| Data Element Name | CPS FOCUS Name |
Size
|
Comment |
| Eff_Date_FY | No Cycle field in CPS FY file |
7
|
Format of this field is mmmyyyy (i.e., MAR2001) |
| Location_1 | CCAMPUS |
2
|
|
| Employee_Number | EMPNO |
9
|
|
| Employee_Name | EMPNAME |
35
|
|
| Social_Security_Number | SOCSECNO |
9
|
|
| Home_Address_Discl_Code | ADRDISCIND |
1
|
|
| Title_Code_Pri_Appt | TITLEPRI |
5
|
|
| Title_Code_Pri_Appt_PPS | PRITPPS |
4
|
|
| Active_This_Month_Empl | EMPACTIVT |
1
|
|
| Active_Last_Month_Empl | EMPACTIVL |
1
|
|
| Multiple_Appt_Code | MULTAPPT |
1
|
|
| Federal_Occup_Code | FEDOCPRI |
2
|
|
| Appt_Type_Code_Pri | APTYPRI |
1
|
|
| Personnel_Program_Primary | PROGPRI |
1
|
|
| Class_Ttl_Outl_Code_Pri | CCTOA |
3
|
|
| UCOP_Employee_Ind | COP |
1
|
"A" if DANR, "P" if UCOP |
| Merced_Employee_Ind | MER |
1
|
"M" if Merced employee |
| Sex_Code | CSEX |
1
|
|
| Date_of_Birth | BDATE |
6
|
|
| Citizen_Status_Code | CCITSTAT |
1
|
|
| Ethnic_Origin_Code | CETHNIC |
2
|
|
| Retirement_System_Code | CRETSYS |
1
|
|
| FICA_Medicare_Elig_Code | FICADED |
1
|
|
| Unemployment_Ins_Cov_Code | UNINSCVG |
1
|
|
| UC_Student_Status_Code | CUCSTUDENT |
1
|
|
| Collective_Barg_Unit_Code | CCBU |
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_Rel_Pos_Type_Code | CEMPRELPOS |
1
|
|
| Empl_Rel_Confid_Code | EMPRELCONF |
1
|
|
| Empl_Unit_Code | EUC |
2
|
|
| Empl_Represent_Code | CEMPREP |
1
|
|
| Date_of_Most_Recent_Hire | EMPDT |
6
|
|
| Original_Date_of_Hire | ORIGHIREDT |
6
|
MM/DD/YY |
| Next_Salary_Rev_Date | SALREVDT |
5
|
MM/YY |
| Next_Salary_Rev_Type_Code | CSALREVTYP |
1
|
|
| Employment_Status_Code | CEMPSTAT |
1
|
|
| Merit_Pct | MERITPCT |
4
|
|
| Separation_Date | SEPDT |
6
|
MM/DD/YY |
| Separation_Rsn_Code | CSEPRSN |
2
|
|
| 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
|
|
| Monthly_Earnings_Code_July | MONERNJUL |
1
|
"Y" if there are July earnings |
| Monthly_Earnings_Code_August | MONERNAUG |
1
|
"Y" if there are August earnings |
| Monthly_Earnings_Code_September | MONERNSEP |
1
|
"Y" if there are September earnings |
| Monthly_Earnings_Code_October | MONERNOCT |
1
|
"Y" if there are October earnings |
| Monthly_Earnings_Code_November | MONERNNOV |
1
|
"Y" if there are November earnings |
| Monthly_Earnings_Code_December | MONERNDEC |
1
|
"Y" if there are December earnings |
| Monthly_Earnings_Code_January | MONERNJAN |
1
|
"Y" if there are January earnings |
| Monthly_Earnings_Code_February | MONERNFEB |
1
|
"Y" if there are February earnings |
| Monthly_Earnings_Code_March | MONERNMAR |
1
|
"Y" if there are March earnings |
| Monthly_Earnings_Code_April | MONERNAPR |
1
|
"Y" if there are April earnings |
| Monthly_Earnings_Code_May | MONERNMAY |
1
|
"Y" if there are May earnings |
| Monthly_Earnings_Code_June | MONERNJUN |
1
|
"Y" if there are June earnings |
| ADD_Eff_Date | ADEFFDT |
6
|
MM/DD/YY |
| ADD_Coverage_Code | CADCVG |
1
|
|
| ADD_Principal_Sum | ADPRINSUM |
3
|
|
| Dental_Plan_Eff_Date | DENTEFFDT |
6
|
MM/DD/YY |
| Dental_Plan_Code | CDENTPLN |
2
|
|
| Dental_Plan_Name | not in CPS |
21
|
translation of Dental Plan Code |
| Life_Ins_Cov_Eff_Date_Empl | LFEFFDT |
6
|
MM/DD/YY |
| Life_Ins_Plan_Code | CLFPLN |
1
|
|
| Life_Ins_Salary_Base_Empl | LFBASAMT |
3
|
|
| Dep_Life_Ins_Plan_Code | LFDEPPLN |
1
|
|
| Med_Ins_Plan_Cov_Eff_Date | HPPEFFDT |
6
|
MM/DD/YY |
| Med_Ins_Plan_Code | CHPPPLN |
2
|
|
| Med_Ins_Plan_Cov_Code | CHPPCVG |
3
|
|
| Medical_Plan_Name | not in CPS |
21
|
Translation of Med Ins Plan Code |
| Temp_Dis_Ins_Code | CNDIPLN |
1
|
|
| TIP_Enrollment | CINSRED |
1
|
|
| 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 |
| Prior_Service_Code | CPRSVC |
1
|
|
| Prior_Institution_Code | CPRINST |
3
|
Only used for faculty |
| Education_Level_Code | CEDLVL |
1
|
|
| Education_Level_Year | EDLVLYR |
2
|
|
| Education_Inst_Code | CEDINST |
3
|
|
| Education_Field_Code | CEDFLD |
4
|
|
| Separated_Empl_Dest_Code | CEMPDEST |
1
|
|
| Future_Institution_Code | CFUTINST |
3
|
|
| Separation_Rsn_Code_Acad | CSEPRSNA |
2
|
|
| Dep_Care_Salary_Red_Plan | DEPCAREPLN |
1
|
|
| Dental_Plan_Cov_Code | CDENTCVG |
3
|
|
| Optical_Plan_Cov_Eff_Date | VISEFFDT |
6
|
MM/DD/YY |
| Optical_Plan_Code | CVISPLN |
2
|
|
| Optical_Plan_Cov_Code | CVISCVG |
3
|
|
| Optical_Plan_Name | Not in CPS |
21
|
Translation of Optical Plan Code |
| Life_Ins_Salary_Base_UC | LFBASAMTUC |
3
|
|
| Life_Ins_Cov_Eff_Date_UC | LFEFFDTUC |
6
|
MM/DD/YY |
| Vietnam_Era_Vet_Status_Code | CVETSTAT |
1
|
|
| WCE_Vet_Status_Code | WCEVETSTAT |
1
|
|
| Veteran_Dis_Status_Code | CVETDISAB |
1
|
|
| Handicapped_Status_Code | CHNDCPSTAT |
1
|
|
| Legal_Plan_Eff_Date | LGLEFFDT |
6
|
MM/DD/YY |
| Legal_Plan_Code | CLGLPLN |
2
|
|
| Legal_Plan_Cov_Code | CLGLCVG |
3
|
|
| Legal_Plan_Name | Not in CPS |
21
|
Translation of Legal Plan Code |
| Life_Ins_Exec_Cov_Code | EXECLFPLN |
1
|
|
| Life_Ins_Exec_Salary_Base | EXECLFAMT |
3
|
|
| Life_Ins_Exec_Eff_Date | EXECLFEFFDT |
10
|
|
| Exec_Sev_Pay_Tot_Int | EXSPINTR |
9
|
|
| Exec_Sev_Pay_Tot_Cont_And_Int | EXSPCONTP |
9
|
|
| Exec_Sev_Pay_Tot_Cont_No_Int | EXSPCONTNP |
9
|
|
| Exec_Sev_Pay_Recent_Mo_Cont | EXSPCMCONT |
9
|
|
| BELI_Asgnd | BELIASI |
1
|
|
| BELI_Derivd | BELIDER |
1
|
|
| BELI_Confl_Dte | BELICDT |
4
|
YYMM |
| 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 |
| Opt_Out_Ind_Medical | MEDOPTOUT |
1
|
|
| Opt_Out_Ind_Dental | DENOPTOUT |
1
|
|
| Opt_Out_Ind_Optical | VISOPTOUT |
1
|
|
| Avg_Paid_Hours_Wk | AVGHRSWK |
4
|
|
| Dep_Life_Cov_Eff_Date | LFDEPEFFDT |
6
|
MM/DD/YY |
| Total_Gross_Cal_YTD | YTDTOTGR |
9
|
|
| Taxable_Gross_Cal_YTD | YTDFWTGR |
9
|
|
| Dep_Care_Ded_YTD | YTDDEPDE |
7
|
|
| DCP_Fund_Select_Cd | DCPFUND |
1
|
|
| Total_Gross_Cal_YTD_Prior | PRYTDTOT |
9
|
|
| Taxable_Gross_Cal_Prior | PRYTDFWT |
9
|
|
| Last_Day_On_Pay_Status | LPAYDT |
6
|
MM/DD/YY |
| Empl_Pd_Dis_Ins_Plan_Code | EDISPLN |
1
|
|
| Empl_Pd_Dis_Ins_Wait_Per | EDISWTPER |
3
|
|
| Empl_Pd_Dis_Ins_Base_Amt | EDISBSAMT |
5
|
|
| Empl_Pd_Dis_Ins_Eff_Date | EDISEFFDT |
6
|
MM/DD/YY |
| Title_Code_Pri_Appt_PPS | PRITPPS |
4
|
|
| Temp_Dis_Ins_Eff_Date | NDIEFFDT |
6
|
MM/DD/YY |
| Taxable_Gross_Fiscal_YTD | FYTDFWTG |
9
|
|
| Home_Department_Code | CHOMEDEPT |
6
|
|
| Home_Department_Name | HOMEDEPT |
30
|
|
| Country_of_Origin_Code | CCOUNTRYRES |
2
|
|
| Country_of_Origin | COUNTRYRES |
30
|
|
| Visa_Type | VISATYPE |
2
|
|
| Num_Hrs_Reg_UC_Units | NUMREGUC |
6
|
1 decimal place |
| Retire_FICA_Deriv_Ind | RETDEVIND |
1
|
|
| Hrs_Toward_Benefits_Elig | BENELHRS |
11
|
2 decimal places |
| Hrs_Toward_Career_Elig | CARELHRS |
11
|
2 decimal places |
| Exec_Sev_Pay_YTD_Total | YTDSEVPAY |
13
|
Fiscal year cumulative total. Not effective until 2001-2002 fiscal year. |
| 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 |
| HCRA_Termination_Date | HCRATDT |
6
|
|
| HCRA_YTD_Deductions | HCRAYTD |
11
|
2 decimal places |
| 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
|
|
| Home_zip | PERMPOST | 5 | |
| Depcare_Annual_Amt | DEPANNAMT | 5 | |
| Depcare_Term_Date | DEPTERMDT | 6 | |
| 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 |
| Class_Ttl_Outl_Name_Pri | CTOA |
30
|
The description of the CTO (Class Title Outline) code for the primary title. |
| 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. |
| Title_Name_Pri_Appt | TITLEPRINM |
30 |
The title name corresponding to the title code of the employee's primary appointment. |
| 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. |
| Ben_Unit_Code | BEN_UNIT_CODE |
2 |
Code indicating Title Unit Code of the predominant appointment for benefits purposes |
| Ben_Rep_Cd | BEN_REP_CD |
1 |
Code indicating whether Benefits Unit Elig and Rep Codes should be derived by PPS |
| Ben_Unit_Der | BEN_UNIT_DER |
1 |
Code indicating whether Benefits Unit Elig and Rep Codes should be derived by PPS |
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. |
Last Updated: February 19, 2008