| Data Elements in the Personnel Data Warehouse Per_FY_Curr_Appt and _All_Appt Tables | |||
| Click on data element name for CPS data dictionary information | |||
| Data Element Name | CPS FOCUS Name | Size | Comment |
| Eff_Date | CYCLE | 7 | Format is mmmyyyy - e.g., MAR2001 |
| Location_1 | CCAMPUS | 2 | |
| Employee_Number | EMPNO | 9 | |
| Appointment_Number | APPTNO | 2 | A unique number assigned to each appointment for an employee |
| Title_Code | CTITLE | 4 | |
| Sub_Location | SUBLOC | 2 | Used only at UCLA/Merced |
| Active_This_Month_Appt | APTACTIVT | 1 | |
| Active_Last_Month_Appt | APTACTIVL | 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 | |
| Off_Above_Scale_Code | COFFABSCA | 1 | |
| Paid_Over_Code | CPDOVER | 2 | |
| Pay_Schedule_Code | CPAYSKED | 2 | |
| Title_Unit_Code_PPS | TUC | 2 | |
| Salary_Step_Grade | SALMGTGD | 2 | |
| Salary_Step | SALSTEP | 4 | |
| Time_Appt_Anticipated | APTPCT | 5 | |
| Title_Name | TITLE | 30 | |
| 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 |
| FOCSUB | CFOCSUB | 2 | |
| Academic_Rank_Code | CACRANK | 1 | |
| Sabbatical_Accrual_Code | SABACCR | 1 | |
| Leave_Accrual_Code_Sick | CLVACCSICK | 1 | |
| Leave_Accrual_Code_Vac | CLVACCVAC | 1 | |
| Title_Spec_Handling_Code | |||
| Appt_WOS_Ind | CWOS | 1 | |
| Appt_Rep_Code | CAPTREP | 1 | |
| FLSA Status Code | FLSASTAT | 1 | |
| Personnel_Program | CAPTTYPT | 1 | |
| Grade_Ind_TCS | GRADEIND | 1 | |
| Academic_Service_Limit | ACSVCLIM | 2 | |
| Frozen_Title_Flag | FROZNFLG | 1 | |
| Standard_Occup_Class_Code | SOC | 3 | |
| Representation_Flag | REPIND | 1 | |
| Related_99_TUC | REL99 | 2 | |
| Bargaining_Type | BARGAIN | 1 | |
| Salary_Range_Minimum | SALMIN | 12 | |
| Salary_Range_Midpoint | SALMID | 12 | |
| Salary_Range_Maximum | SALMAX | 12 | |
| Number_of_Whole_Steps | NUMSTEPS | 2 | |
| Use_of_Title_Code | CUSETITLE | 1 | |
| Restricted_Title_Flag | RESTRFLG | 1 | |
| Overtime_Exempt_Status_Code | OTEXEMP | 1 | |
| Retirement_Code1 | CRETIRE1 | 1 | |
| Retirement_Code2 | CRETIRE2 | 1 | |
| Academic_Appt_Basis_Code | CACAPTBAS | 1 | |
| Academic_Appt_Type_Code | CACAPTTYP | 1 | |
| Academic_Pay_Period_Code | CACPAYPER | 1 | |
| Academic_Sick_Lv_Elig_Code | ACSICKELIG | 1 | |
| Staff_Step_Scale_Except_Flag | STFEXCPFLG | 1 | |
| By_Agreement_Code | BYAGREE | 1 | |
| Title_Unit_Code_TCS | TUCT | 2 | |
| Supervisory_Flag | SUPVFLAG | 1 | |
| Shift_Differential_Elig_Code | SDELIG | 1 | |
| On_Call_Rate_Elig_code | ONCALLELIG | 1 | |
| Linkage_Code | CLINKAGE | 3 | |
| Merit_Flag | MERIT | 1 | |
| Pers_Pgm | PERSPGM (Defined) | 3 | 3-character personnel program name; ACA, PSS, MSP, SMG |
| Academic_Senate_Flag | Not in CPS | 1 | "Y" if the title is an Academic Senate Title (including SMG titles which are part of the Academic Senate) |
| Class_Ttl_Outl_Name_Appt | CTOB (Defined) | 30 | Description of the Class Title Outline code |
| Last Updated: October 21, 2008 | |||
| Return to Personnel Data Warehouse Description of Tables | |||