Data Elements in the Personnel Data Warehouse Per_Lab_Curr, _Prior, and _All 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
Title_Code	CTITLE	4
Location_2	CLOC2	1
Location_3	CLOC3	1
Account	ACCTNO	6
Fund	FUNDNO	5
Sub_Account	CSUBACCT	2
DOS_Code_CPS	CDOS	2
DOS_Code_PPS	PDOS	3
Distrib_Pay_Rate	DSTPAYRT	10
Distrib_Rate_Code	CDISTRT	1
Gross_Earnings_Pay_Per	MONGRS	7
Hours_Paid_Pay_Per	MONHRS	5
Location_10_Dist	10LOC	5	Does not differentiate ANR or Merced.
Location_11_Dist	11LOC	5	Does not differentiate Merced.
Time_Distrib_Actual	MONFTE	5
Loc_Code	Not in CPS	2	Used for sorting locations in specific order- 22 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 PRES, ANR, and campus medical centers
UCRS_Gross_Ind	UCRSGROSIND	1	Indicates whether earnings are included in retirement covered compensation
Ret_Covcomp	RETCOVCOMP (defined)	16	Retirement covered compensation earnings
Payment_Category_Code	PAYCAT	1	Code indicating payment category associated with earnings, such as regular, leave, additional pay, etc.
Payment_Category	PAYCAT_DESC (defined)	20	Translation of Payment Category Code
Type_Hours	TYPEHOURS	1	Code indicating type of hours such as regular, overtime, non-worked, etc.
Type_of Hours	TYPEHRS (defined)	16	Translation of Type Hours code
Fundsource	FUNDSOURCE (defined)	21	Fundsource category assigned to the fundgroup associated with the payment
Fundsort	FUNDSORT (defined)	1	Field used to sort Fundsource into preferred order