| |
|
| 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 |
| |
|
|
|
|
|