Data Elements in the CPS PER_FY

Data Elements in the Personnel Data Warehouse Per_FY_Curr_ and All_Summary Tables

This is a view which combines data from the Employee, Appointment, and Distribution Tables

Click on data element name for CPS data dictionary information

Data Element Name CPS FOCUS Name
Size
Comment

Employee Table Data

Eff_Date_FY No Cycle field in CPS FY file
7
Format of this field is mmmyyyy (i.e., MAR2001)

Location_1 CCAMPUS
2

Employee_Number EMPNO
9

Social_Security_Number SOCSECNO
9

Loc_Indicator LOCIND
1
Code for the campus location assigned to home department code, such as medical center, Merced, UCOP, CEB, etc.

Loc_Ind_Description LOCINDNM (defined)
20
Translation of Loc_Indicator

OP_DANR_Location OPANRLOC (defined)
12
Indicates whether the DANR or UCOP location is at a campus or at the Oakland systemwide office

Emp_Location EMPLOC (defined)
13
Location based on employee's Loc_Indicator; medical centers, UCOP, and ANR are all differentiated from campus.

Title_Code_Pri_Appt TITLEPRI
5

Primary_Perspgm PRIPERPG (defined)
3
Identifies the personnel program for the primary title by its acronym (MSP, SMG, PSS, or ACA)

Class_Ttl_Outl_Code_Pri CCTOA
3

Class_Ttl_Outl_Name_Pri CTOA
30
The description of the CTO (Class Title Outline) code for the primary title.

Empl_Unit_Code EUC
2

Empl_Represent_Code CEMPREP
1

Retirement_System_Code CRETSYS
1

Active_This_Month_Empl EMPACTIVT
1

Retire_FICA_Deriv_Ind RETDEVIND
1

FICA_Medicare_Elig_Code FICADED
1

Email_Address EMAILADD (in Address database)
50
The employee's work email address, as contained in the Telecom file

Medical_Premium_Emp_Paid Not in CPS
7
The employee-paid premium for medical coverage, based on medical plan, coverage code, and medical contribution base.

Medical_Premium_UC_Paid Not in CPS
7
The UC-paid premium for medical coverage, based on the employee's medical plan, coverage code, and medical contribution base.

Medical_Premium_Tot Not in CPS
7
The total premium for medical coverage, based on the employee's medical plan, coverage code, and medical contribution base.

Dental_Premium_Emp_Paid Not in CPS
7
The employee-paid premium for dental coverage, based on dental plan and coverage code. Currently the dental premium is paid entirely by the University.

Dental_Premium_UC_Paid Not in CPS
7
The UC-paid premium for dental coverage, based on dental plan and coverage code. Currently the dental premium is paid entirely by the University.

Dental_Premium_Tot Not in CPS
7
The total premium for dental coverage, based on dental plan and coverage code. Currently the dental premium is paid entirely by the University.

Optical_Premium_Emp_Paid Not in CPS
7
The employee-paid premium for optical coverage, based on vision plan and coverage code. Currently the optical premium is paid entirely by the University.

Optical_Premium_UC_Paid Not in CPS
7
The UC-paid premium for optical coverage, based on vision plan and coverage code. Currently the optical premium is paid entirely by the University.

Optical_Premium_Tot Not in CPS
7
The total premium for optical coverage, based on vision plan and coverage code. Currently the optical premium is paid entirely by the University.

Title_Name_Pri_Appt TITLEPRINM
30
The title name corresponding to the title code of the employee's primary appointment.

Armed Forces Svc Medal AF_SVC_MEDAL
1
Code indicating whether an individual was awarded a service medal while on active duty in a US military operation.

Appointment Table Data

Title_Code CTITLE
4

Title_Unit_Code_TCS TUCT
2

Appt_Rep_Code CAPTREP
1

Pers_Pgm PERSPGM (Defined)
1
Identifies the personnel program for the title by its acronym (MSP, SMG, PSS, or ACA)

Appt_Type_Code CAPTTYP
1

Class_Ttl_Outl_Code_Appt CCTOB
3

Class_Ttl_Outl_Name_Appt CTOB
30
The description of the CTO (Class Title Outline) code for the title code.

Academic_Rank_Code CACRANK
1

Academic Senate Flag ACADSEN (defined)
1
"Y" if the title is an Academic Senate title

Distribution Table Data

Locnm 2 Not in CPS
2
2-character location abbreviation-includes OP and AG, medical centers not differentiated

Location_2 CLOC2
1

Location_3 CLOC3
1

SAU_Code SAU
1

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 UCOP, ANR, and campus medical centers

Locnm_Comp Not in CPS
5
5-character location abbrev-includes PRES, ANR, and campus medical centers. At UCLA and Davis, the School of Medicine is included in the Medical Center.

Function_Code FUNCTION
2

Function_Name FUNCDESC (defined)
30
Field used to sort Fundsource into preferred order

Fundsort FUNDSORT (defined)
1
Field used to sort Fundsource into preferred order

Fundsource FUNDSOURCE (defined)
21
Fundsource category assigned to the fundgroup associated with the payment

Fund_Group_Code FUNDGROUP
6

UCRS_Gross_Ind UCRSGROSIND
1
Indicates whether earnings are included in retirement covered compensation, based on the PPS Description of service code

Ret_Covcomp_July through Ret_Covcomp_June RETCCJUL through RETCCJUN (defined)
16
Retirement covered compensation earnings, based on the UCRS Gross Indicator, for each month of the fiscal year

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

DOS_Code_CPS CDOS
2

DOS_Code_PPS PDOS
3

Gross_Earnings_July MONGRSJUL
14
2 decimal places

Gross_Earnings_August MONGRSAUG
14
2 decimal places

Gross_Earnings_September MONGRSSEP
14
2 decimal places

Gross_Earnings_October MONGRSOCT
14
2 decimal places

Gross_Earnings_November MONGRSNOV
14
2 decimal places

Gross_Earnings_December MONGRSDEC
14
2 decimal places

Gross_Earnings_January MONGRSJAN
14
2 decimal places

Gross_Earnings_February MONGRSFEB
14
2 decimal places

Gross_Earnings_March MONGRSMAR
14
2 decimal places

Gross_Earnings_April MONGRSAPR
14
2 decimal places

Gross_Earnings_May MONGRSMAY
14
2 decimal places

Gross_Earnings_June MONGRSJUN
14
2 decimal places

Tot_FY_Gross Earnings TOTFYGRS (defined)
16
The total gross earnings for months July through June of the current fiscal year.

Gross_Earnings_Prior_FY PRFYGRS
17
2 decimal places

Hours_Paid_July MONHRSJUL
8
2 decimal places

Hours_Paid_August MONHRSAUG
8
2 decimal places

Hours_Paid_September MONHRSSEP
8
2 decimal places

Hours_Paid_October MONHRSOCT
8
2 decimal places

Hours_Paid_November MONHRSNOV
8
2 decimal places

Hours_Paid_December MONHRSDEC
8
2 decimal places

Hours_Paid_January MONHRSJAN
8
2 decimal places

Hours_Paid_February MONHRSFEB
8
2 decimal places

Hours_Paid_March MONHRSMAR
8
2 decimal places

Hours_Paid_April MONHRSAPR
8
2 decimal places

Hours_Paid_May MONHRSMAY
8
2 decimal places

Hours_Paid_June MONHRSJUN
8
2 decimal places

Tot_FY_Hours Worked TOTFYHRS (defined)
16
The total number of hours paid for months July through June of the current fiscal year.

Hours_Paid_Prior_FY PRFYHRS
12
2 decimal places

Time_Distrib_July MONFTEJUL
8
4 decimal places

Time_Distrib_August MONFTEAUG
8
4 decimal places

Time_Distrib_September MONFTESEP
8
4 decimal places

Time_Distrib_October MONFTEOCT
8
4 decimal places

Time_Distrib_November MONFTENOV
8
4 decimal places

Time_Distrib_December MONFTEDEC
8
4 decimal places

Time_Distrib_January MONFTEJAN
8
4 decimal places

Time_Distrib_February MONFTEFEB
8
4 decimal places

Time_Distrib_March MONFTEMAR
8
4 decimal places

Time_Distrib_April MONFTEAPR
8
4 decimal places

Time_Distrib_May MONFTEMAY
8
4 decimal places

Time_Distrib_June MONFTEJUN
8
4 decimal places

Tot_FY_Time_Distrib TOTFYFTE (defined)
16
The total monthly FTE for months July through June of the current fiscal year. Only meaningful if divided by the number of months worked during the year, since it will equal 12.00 for any employee who worked full-time throughout the entire fiscal year.

Time_Distrib_Prior_FY PRFYFTE
12
4 decimal places

Derived Pct_Julthrough Derived_Pct_Prior_FY DERPCTJUL through DERPCTJUN and PRFYDERPCT n.nnnn Derived percent for purposes of Effort Reporting

Last Updated: February 19, 2008

Return to Personnel Data Warehouse Description of Tables

Data Element Name	CPS FOCUS Name	Size	Comment
Employee Table Data
Eff_Date_FY	No Cycle field in CPS FY file	7	Format of this field is mmmyyyy (i.e., MAR2001)
Location_1	CCAMPUS	2
Employee_Number	EMPNO	9
Social_Security_Number	SOCSECNO	9
Loc_Indicator	LOCIND	1	Code for the campus location assigned to home department code, such as medical center, Merced, UCOP, CEB, etc.
Loc_Ind_Description	LOCINDNM (defined)	20	Translation of Loc_Indicator
OP_DANR_Location	OPANRLOC (defined)	12	Indicates whether the DANR or UCOP location is at a campus or at the Oakland systemwide office
Emp_Location	EMPLOC (defined)	13	Location based on employee's Loc_Indicator; medical centers, UCOP, and ANR are all differentiated from campus.
Title_Code_Pri_Appt	TITLEPRI	5
Primary_Perspgm	PRIPERPG (defined)	3	Identifies the personnel program for the primary title by its acronym (MSP, SMG, PSS, or ACA)
Class_Ttl_Outl_Code_Pri	CCTOA	3
Class_Ttl_Outl_Name_Pri	CTOA	30	The description of the CTO (Class Title Outline) code for the primary title.
Empl_Unit_Code	EUC	2
Empl_Represent_Code	CEMPREP	1
Retirement_System_Code	CRETSYS	1
Active_This_Month_Empl	EMPACTIVT	1
Retire_FICA_Deriv_Ind	RETDEVIND	1
FICA_Medicare_Elig_Code	FICADED	1
Email_Address	EMAILADD (in Address database)	50	The employee's work email address, as contained in the Telecom file
Medical_Premium_Emp_Paid	Not in CPS	7	The employee-paid premium for medical coverage, based on medical plan, coverage code, and medical contribution base.
Medical_Premium_UC_Paid	Not in CPS	7	The UC-paid premium for medical coverage, based on the employee's medical plan, coverage code, and medical contribution base.
Medical_Premium_Tot	Not in CPS	7	The total premium for medical coverage, based on the employee's medical plan, coverage code, and medical contribution base.
Dental_Premium_Emp_Paid	Not in CPS	7	The employee-paid premium for dental coverage, based on dental plan and coverage code. Currently the dental premium is paid entirely by the University.
Dental_Premium_UC_Paid	Not in CPS	7	The UC-paid premium for dental coverage, based on dental plan and coverage code. Currently the dental premium is paid entirely by the University.
Dental_Premium_Tot	Not in CPS	7	The total premium for dental coverage, based on dental plan and coverage code. Currently the dental premium is paid entirely by the University.
Optical_Premium_Emp_Paid	Not in CPS	7	The employee-paid premium for optical coverage, based on vision plan and coverage code. Currently the optical premium is paid entirely by the University.
Optical_Premium_UC_Paid	Not in CPS	7	The UC-paid premium for optical coverage, based on vision plan and coverage code. Currently the optical premium is paid entirely by the University.
Optical_Premium_Tot	Not in CPS	7	The total premium for optical coverage, based on vision plan and coverage code. Currently the optical premium is paid entirely by the University.
Title_Name_Pri_Appt	TITLEPRINM	30	The title name corresponding to the title code of the employee's primary appointment.
Armed Forces Svc Medal	AF_SVC_MEDAL	1	Code indicating whether an individual was awarded a service medal while on active duty in a US military operation.
Appointment Table Data
Title_Code	CTITLE	4
Title_Unit_Code_TCS	TUCT	2
Appt_Rep_Code	CAPTREP	1
Pers_Pgm	PERSPGM (Defined)	1	Identifies the personnel program for the title by its acronym (MSP, SMG, PSS, or ACA)
Appt_Type_Code	CAPTTYP	1
Class_Ttl_Outl_Code_Appt	CCTOB	3
Class_Ttl_Outl_Name_Appt	CTOB	30	The description of the CTO (Class Title Outline) code for the title code.
Academic_Rank_Code	CACRANK	1
Academic Senate Flag	ACADSEN (defined)	1	"Y" if the title is an Academic Senate title
Distribution Table Data
Locnm 2	Not in CPS	2	2-character location abbreviation-includes OP and AG, medical centers not differentiated
Location_2	CLOC2	1
Location_3	CLOC3	1
SAU_Code	SAU	1
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 UCOP, ANR, and campus medical centers
Locnm_Comp	Not in CPS	5	5-character location abbrev-includes PRES, ANR, and campus medical centers. At UCLA and Davis, the School of Medicine is included in the Medical Center.
Function_Code	FUNCTION	2
Function_Name	FUNCDESC (defined)	30	Field used to sort Fundsource into preferred order
Fundsort	FUNDSORT (defined)	1	Field used to sort Fundsource into preferred order
Fundsource	FUNDSOURCE (defined)	21	Fundsource category assigned to the fundgroup associated with the payment
Fund_Group_Code	FUNDGROUP	6
UCRS_Gross_Ind	UCRSGROSIND	1	Indicates whether earnings are included in retirement covered compensation, based on the PPS Description of service code
Ret_Covcomp_July through Ret_Covcomp_June	RETCCJUL through RETCCJUN (defined)	16	Retirement covered compensation earnings, based on the UCRS Gross Indicator, for each month of the fiscal year
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
DOS_Code_CPS	CDOS	2
DOS_Code_PPS	PDOS	3
Gross_Earnings_July	MONGRSJUL	14	2 decimal places
Gross_Earnings_August	MONGRSAUG	14	2 decimal places
Gross_Earnings_September	MONGRSSEP	14	2 decimal places
Gross_Earnings_October	MONGRSOCT	14	2 decimal places
Gross_Earnings_November	MONGRSNOV	14	2 decimal places
Gross_Earnings_December	MONGRSDEC	14	2 decimal places
Gross_Earnings_January	MONGRSJAN	14	2 decimal places
Gross_Earnings_February	MONGRSFEB	14	2 decimal places
Gross_Earnings_March	MONGRSMAR	14	2 decimal places
Gross_Earnings_April	MONGRSAPR	14	2 decimal places
Gross_Earnings_May	MONGRSMAY	14	2 decimal places
Gross_Earnings_June	MONGRSJUN	14	2 decimal places
Tot_FY_Gross Earnings	TOTFYGRS (defined)	16	The total gross earnings for months July through June of the current fiscal year.
Gross_Earnings_Prior_FY	PRFYGRS	17	2 decimal places
Hours_Paid_July	MONHRSJUL	8	2 decimal places
Hours_Paid_August	MONHRSAUG	8	2 decimal places
Hours_Paid_September	MONHRSSEP	8	2 decimal places
Hours_Paid_October	MONHRSOCT	8	2 decimal places
Hours_Paid_November	MONHRSNOV	8	2 decimal places
Hours_Paid_December	MONHRSDEC	8	2 decimal places
Hours_Paid_January	MONHRSJAN	8	2 decimal places
Hours_Paid_February	MONHRSFEB	8	2 decimal places
Hours_Paid_March	MONHRSMAR	8	2 decimal places
Hours_Paid_April	MONHRSAPR	8	2 decimal places
Hours_Paid_May	MONHRSMAY	8	2 decimal places
Hours_Paid_June	MONHRSJUN	8	2 decimal places
Tot_FY_Hours Worked	TOTFYHRS (defined)	16	The total number of hours paid for months July through June of the current fiscal year.
Hours_Paid_Prior_FY	PRFYHRS	12	2 decimal places
Time_Distrib_July	MONFTEJUL	8	4 decimal places
Time_Distrib_August	MONFTEAUG	8	4 decimal places
Time_Distrib_September	MONFTESEP	8	4 decimal places
Time_Distrib_October	MONFTEOCT	8	4 decimal places
Time_Distrib_November	MONFTENOV	8	4 decimal places
Time_Distrib_December	MONFTEDEC	8	4 decimal places
Time_Distrib_January	MONFTEJAN	8	4 decimal places
Time_Distrib_February	MONFTEFEB	8	4 decimal places
Time_Distrib_March	MONFTEMAR	8	4 decimal places
Time_Distrib_April	MONFTEAPR	8	4 decimal places
Time_Distrib_May	MONFTEMAY	8	4 decimal places
Time_Distrib_June	MONFTEJUN	8	4 decimal places
Tot_FY_Time_Distrib	TOTFYFTE (defined)	16	The total monthly FTE for months July through June of the current fiscal year. Only meaningful if divided by the number of months worked during the year, since it will equal 12.00 for any employee who worked full-time throughout the entire fiscal year.
Time_Distrib_Prior_FY	PRFYFTE	12	4 decimal places
Derived Pct_Julthrough Derived_Pct_Prior_FY	DERPCTJUL through DERPCTJUN and PRFYDERPCT	n.nnnn	Derived percent for purposes of Effort Reporting