Data Elements in the Personnel Data Warehouse Per_Snap_Curr_Appt, _Prior_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
|
Different format from CYCLE in CPS. MAR2001 rather than MAR01. |
| Location_1 | CCAMPUS |
2
|
|
| Employee_Number | EMPNO |
9
|
|
| 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 Senate Flag | ACADSEN |
1
|
"Y" if the title is an Academic Senate title |
| 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
|
|
| Federal_Occup_Code | FOC |
1
|
|
| FLSA_Status_Code | FLSASTAT |
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_Rep | Not in CPS |
3
|
Used to join to TCS data - COV, UNC, ALL |
| Pay_Schedule_Code | CPAYSKED |
2
|
|
| Payroll_Title_Unit_Rep_Code | PTUC |
5
|
|
| Personnel_Program | CAPTTYPT |
1
|
|
| Pers_Pgm | PERSPGM (Defined) |
1
|
Identifies the personnel program for the title by its acronym (MSP, SMG, PSS, or ACA) |
| 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
|
|
Grade_Type |
GRADETYPE |
2 |
The Grade type from the Title Code Table in PPS which is applicable to the title code. |
| Salary_Range_Maximum | SALMAX |
12
|
|
| Salary_Range_Midpoint | SALMID |
12
|
|
| Salary_Range_Minimum | SALMIN |
12
|
|
| Salary_Step | SALSTEP |
6
|
Not populated at SF |
| Salary_Step_Grade | SALMGTGD |
2
|
|
| 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
|