Data Elements in the Personnel Data Warehouse Per_Lab_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
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_Type_Code	CAPTTYP	1
Overtime_Exempt_Status_Code	OTEXEMP	1
Pay_Schedule_Code	CPAYSKED	2
Time_Appt_Anticipated	APTPCT	5
Title_Name	TITLE	30
Title_Unit_Code_PPS	TUC	2
FLSA Status Code	FLSASTAT	1
Pers_Pgm	PERSPGM (Defined)	1	Identifies the personnel program for the title by its acronym (MSP, SMG, PSS, or ACA). Does not apply to lab titles.
Academic Senate Flag	ACADSEN	1	"Y" if the title is an Academic Senate title
Grade_Type	GRADETYPE	2	The Grade type from the Title Code Table in PPS which is applicable to the title code.