Data Elements in the Personnel Data Warehouse Per_Acad_Snap_yyyy tables
Click on data element name for CPS data dictionary information
| Data Element Name | CPS FOCUS Name |
Size
|
Comment |
| Eff_Date_Acad | CYCLE |
7
|
Different format from CYCLE in CPS. MAR2001 rather than MAR01. This is the cycle of the academic file. |
| Location_1 | CCAMPUS |
2
|
|
| Employee_Number | EMPNO |
9
|
|
| Employee_Name | EMPNAME |
35
|
|
| Social_Security_Number | SOCSECNO |
9
|
|
| Acad_Prior Service_Code | ACPRSVC |
1
|
Prior service code |
| Acad_Prior_Service |
40
|
Translation of Prior service code | |
| Acad_Prior_Institution_Code | ACPRINST |
3
|
Prior institution code |
| Acad_Prior_Institution |
40
|
Prior institution name | |
| Edu_Level_Code | ACEDLVL |
1
|
Education level code |
| Edu_Level |
35
|
Translation of Education level | |
| Edu_Level_Year | AEDLVLYR |
2
|
Education level year |
| Edu_Level_year_4 | TAEDLVLYR |
4
|
Education level year - 4 digit |
| Edu_Institution_Code | ACEDINST |
3
|
Education institution code |
| Edu_Institution |
40
|
Translation of Education institution code | |
| Edu_Field_Code | ACEDFLD |
4
|
Education field code |
| Edu_Field |
35
|
Education field | |
| Separated_Emp_Dest_Code | ACEMPDEST |
1
|
Separated employee destination code |
| Separated_Emp_Dest |
40
|
Translation of Separated employee destination | |
| Future_Institution_Code | ACFUTINST |
3
|
Future institution code |
| Future_Institution |
40
|
Future institution name | |
| Separation_Reason_Code | ACSEPRSNA |
2
|
Separation reason code - academic |
| Separation_Reason |
35
|
Translation of Separation reason code- academic | |
| Employee Table Data | |||
| Eff_Date_Snap | No Cycle field in CPS FY file |
7
|
Format of this field is mmmyyyy (i.e., MAR2001). This is from the Snapshot file. It includes each cycle within the fiscal year corresponding with the academic year. |
| 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
|
|
| 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
|
|
| Exec_Sev_Pay_Tot_Cont_And_Int | EXSPCONTP |
9
|
|
| Exec_Sev_Pay_Tot_Cont_No_Int | EXSPCONTNP |
9
|
|
| Exec_Sev_Pay_Tot_Int | EXSPINTR |
9
|
|
| Exec_Sev_Pay_YTD_Total | YTDSEVPAY |
13
|
Fiscal year cumulative total. Not effective until 2001-2002 fiscal year. |
| 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 | CISATYPE |
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 |
| 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 This field was added in 2003; it is not included in the 2001 and 2002 tables. |
| Sr_Mgmt Over Contr Rate | SMSEVORCNRT |
1
|
This field was added in 2003; it is not included in the 2001 and 2002 tables. |
| Home_zip | PERMPOST | 5 | This field was added in 2003; it is not included in the 2001 and 2002 tables. |
| Depcare_Annual_Amt | DEPANNAMT | 5 | This field was added in 2003; it is not included in the 2001 and 2002 tables. |
| Depcare_Term_Date | DEPTERMDT | 6 | This field was added in 2003; it is not included in the 2001 and 2002 tables. |
| 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
|
|
| FLSA Status Code | FLSASTAT |
1
|
|
| Federal_Occup_Code | FOC |
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_Schedule_Code | CPAYSKED |
2
|
|
| Payroll_Title_Unit_Rep_Code | PTUC |
5
|
|
| Personnel_Program | CAPTTYPT |
1
|
|
| 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_Grade | SALMGTGD |
2
|
Combines salary step and grade in one field. All campuses used this field until 7/1/02; some are still submitting grade/step in this combined field. |
| Salary_Step | SALSTEP |
6
|
Not populated at SF |
| Salary_Range_Maximum | SALMAX |
12
|
|
| Salary_Range_Midpoint | SALMID |
12
|
|
| Salary_Range_Minimum | SALMIN |
12
|
|
| Salary_Step_Grade | SALMGTGD |
2
|
Do not use - empty |
| 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
|
|
| 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
|
|
| Account_Group_Code | ACCTGROUP |
6
|
|
| DOS_Code_PPS | PDOS |
3
|
|
| 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
|
|
| Location_11_Dist | 11LOC |
5
|
|
| Org_1_Code | CORGGRP |
7
|
|
| 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-19 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 UCOP, ANR, and campus medical centers |
Last Updated: March 7, 2004