Skip to content
  1. Home > Subject Areas > Data Elements in the Personnel Data Warehouse Per_Snap_Curr, _Prior, and _All Tables

Data Elements in the Personnel Data Warehouse Per_Snap_Curr, _Prior, and _All 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
  
Employee_Name EMPNAME
35
Social_Security_Number SOCSECNO 9
Home_Address_Discl_Code ADRDISCIND 1
Title_Code_Pri_Appt_PPS PRITPPS
4
  
Active_This_Month_Empl EMPACTIVT
1
  
Active_Last_Month_Empl EMPACTIVL
1
  
Multiple_Appt_Code MULTAPPT
1
  
Federal_Occup_Code FEDOCPRI
2
  
Appt_Type_Code_Pri APTYPRI
1
  
Personnel_Program_Primary PROGPRI
1
  
Class_Ttl_Outl_Code_Pri CCTOA
3
  
UCOP_Employee_Ind COP
1
 "A" if DANR, "P" if UCOP
Merced_Employee_Ind MER
1
 "M" if Merced employee; used before July 1, 2005
Sex_Code CSEX
1
  
Date_of_Birth BDATE
6
  
Citizen_Status_Code CCITSTAT
1
  
Ethnic_Origin_Code CETHNIC
2
  
Retirement_System_Code CRETSYS
1
  
FICA_Medicare_Elig_Code FICADED
1
  
Unemployment_Ins_Cov_Code UNINSCVG
1
  
UC_Student_Status_Code CUCSTUDENT
1
  
Collective_Barg_Unit_Code CCBU
2
  
Empl_Org_Code_Dues_Ben1 CEMPORG1
4
  
Empl_Org_Code_Dues_Ben2 CEMPORG2
4
  
Empl_Org_Code_Dues_Ben3 CEMPORG3
4
  
Empl_Org_Code_Dues_Ben4 CEMPORG4
4
  
Empl_Rel_Pos_Type_Code CEMPRELPOS
1
  
Empl_Rel_Confid_Code EMPRELCONF
1
  
Empl_Unit_Code EUC
2
  
Empl_Represent_Code CEMPREP
1
  
Date_of_Most_Recent_Hire EMPDT
6
  
Original_Date_of_Hire ORIGHIREDT
6
 MM/DD/YY
Next_Salary_Rev_Date SALREVDT
5
 MM/YY
Next_Salary_Rev_Type_Code CSALREVTYP
1
  
Employment_Status_Code CEMPSTAT
1
  
Merit_Pct MERITPCT
4
  
Separation_Date SEPDT
6
 MM/DD/YY
Separation_Rsn_Code CSEPRSN
2
  
Leave_Of_Abs_Beg_Date LOABEGDT
6
 MM/DD/YY
Leave_Of_Abs_Rtn_Date LOARETDT
6
 MM/DD/YY
Leave_Of_Abs_Type_Code CLOATYP
2
  
Monthly_Earnings_Code_July MONERNJUL
1
 "Y" if there are July earnings
Monthly_Earnings_Code_August MONERNAUG
1
 "Y" if there are August earnings
Monthly_Earnings_Code_September MONERNSEP
1
 "Y" if there are September earnings
Monthly_Earnings_Code_October MONERNOCT
1
 "Y" if there are October earnings
Monthly_Earnings_Code_November MONERNNOV
1
 "Y" if there are November earnings
Monthly_Earnings_Code_December MONERNDEC
1
 "Y" if there are December earnings
Monthly_Earnings_Code_January MONERNJAN
1
 "Y" if there are January earnings
Monthly_Earnings_Code_February MONERNFEB
1
 "Y" if there are February earnings
Monthly_Earnings_Code_March MONERNMAR
1
 "Y" if there are March earnings
Monthly_Earnings_Code_April MONERNAPR
1
 "Y" if there are April earnings
Monthly_Earnings_Code_May MONERNMAY
1
 "Y" if there are May earnings
Monthly_Earnings_Code_June MONERNJUN
1

"Y" if there are June earnings
ADD_Coverage_Code CADCVG
1
  
ADD_Eff_Date ADEFFDT
6
 MM/DD/YY
ADD_Principal_Sum ADPRINSUM
3
  
Dental_Plan_Eff_Date DENTEFFDT
6
 MM/DD/YY
Dental_Plan_Code CDENTPLN
2
  
Dental_Plan_Name not in CPS
21
 translation of Dental Plan Code
Life_Ins_Cov_Eff_Date_Empl LFEFFDT
6
 MM/DD/YY
Life_Ins_Plan_Code CLFPLN
1
  
Life_Ins_Salary_Base_Empl LFBASAMT
3
  
Dep_Life_Ins_Plan_Code LFDEPPLN
1
  
Med_Ins_Plan_Cov_Eff_Date HPPEFFDT
6
 MM/DD/YY
Med_Ins_Plan_Code CHPPPLN
2
  
Med_Ins_Plan_Cov_Code CHPPCVG
3
  
Medical_Plan_Name not in CPS
21
 Translation of Med Ins Plan Code
Temp_Dis_Ins_Code CNDIPLN
1
  
TIP_Enrollment CINSRED
1
  
Personnel_Action_Code1 CPERACT1
2
  
Personnel_Action_Code2 CPERACT2
2
  
Personnel_Action_Code3 CPERACT3
2
  
Personnel_Action_Code4 CPERACT4
2
  
Personnel_Action_Code5 CPERACT5
2
  
Personnel_Action_Date PERACTDT
6
 MM/DD/YY
Prior_Service_Code CPRSVC
1
  
Prior_Institution_Code CPRINST
3
 Only used for faculty
Education_Level_Code CEDLVL
1
  
Education_Level_Year EDLVLYR
2
  
Education_Inst_Code CEDINST
3
  
Education_Field_Code CEDFLD
4
  
Separated_Empl_Dest_Code CEMPDEST
1
  
Future_Institution_Code CFUTINST
3
  
Separation_Rsn_Code_Acad CSEPRSNA
2
  
Dep_Care_Salary_Red_Plan DEPCAREPLN
1
  
Dental_Plan_Cov_Code CDENTCVG
3
  
Optical_Plan_Cov_Eff_Date VISEFFDT
6
 MM/DD/YY
Optical_Plan_Code CVISPLN
2
  
Optical_Plan_Cov_Code CVISCVG
3
  
Optical_Plan_Name Not in CPS
21
 Translation of Optical Plan Code
Life_Ins_Salary_Base_UC LFBASAMTUC
3
  
Life_Ins_Cov_Eff_Date_UC LFEFFDTUC
6
 MM/DD/YY
Vietnam_Era_Vet_Status_Code CVETSTAT
1
  
WCE_Vet_Status_Code WCEVETSTAT
1
  
Veteran_Dis_Status_Code CVETDISAB
1
  
Handicapped_Status_Code CHNDCPSTAT
1
  
Legal_Plan_Eff_Date LGLEFFDT
6
 MM/DD/YY
Legal_Plan_Code CLGLPLN
2
  
Legal_Plan_Cov_Code CLGLCVG
3
  
Legal_Plan_Name Not in CPS
21
 Translation of Legal Plan Code
Life_Ins_Exec_Cov_Code EXECLFPLN
1
  
Life_Ins_Exec_Salary_Base EXECLFAMT
3
  
Life_Ins_Exec_Eff_Date EXECLFEFFDT
10
  
Exec_Sev_Pay_Tot_Int EXSPINTR
9
  
Exec_Sev_Pay_Tot_Cont_And_Int EXSPCONTP
9
  
Exec_Sev_Pay_Tot_Cont_No_Int EXSPCONTNP
9
  
Exec_Sev_Pay_Recent_Mo_Cont EXSPCMCONT
9
  
BELI_Asgnd BELIASI
1
  
BELI_Derivd BELIDER
1
  
BELI_Confl_Dte BELICDT
4
 YYMM
Pri_BELI_Status_Qual_Code BELISQC1
2
  
Pri_BELI_Status_Qual_Date BELISQD1
6
 YY/MM/DD
Sec_BELI_Status_Qual_Code BELISQC1
2
  
Sec_BELI_Status_Qual_Date BELISQD1
6
 YY/MM/DD
Opt_Out_Ind_Medical MEDOPTOUT
1
  
Opt_Out_Ind_Dental DENOPTOUT
1
  
Opt_Out_Ind_Optical VISOPTOUT
1
  
Avg_Paid_Hours_Wk AVGHRSWK
4
  
Dep_Life_Cov_Eff_Date LFDEPEFFDT
6
 MM/DD/YY
Total_Gross_Cal_YTD YTDTOTGR
9
  
Taxable_Gross_Cal_YTD YTDFWTGR
9
  
Dep_Care_Ded_YTD YTDDEPDE
7
  
DCP_Fund_Select_Cd DCPFUND
1
  
Total_Gross_Cal_YTD_Prior PRYTDTOT
9
  
Taxable_Gross_Cal_Prior PRYTDFWT
9
  
Last_Day_On_Pay_Status LPAYDT
6

MM/DD/YY
Empl_Pd_Dis_Ins_Plan_Code EDISPLN
1
  
Empl_Pd_Dis_Ins_Wait_Per EDISWTPER
3
  
Empl_Pd_Dis_Ins_Base_Amt EDISBSAMT
5
  
Empl_Pd_Dis_Ins_Eff_Date EDISEFFDT
6
 MM/DD/YY
Title_Code_Pri_Appt_PPS PRITPPS
4
  
Temp_Dis_Ins_Eff_Date NDIEFFDT
6
 MM/DD/YY
Taxable_Gross_Fiscal_YTD FYTDFWTG
9
  
Home_Department_Code CHOMEDEPT
6
  
Home_Department_Name HOMEDEPT
30
  
Country_of_Origin_Code CCOUNTRYRES
2
  
Country_of_Origin COUNTRYRES
30
  
Visa_Type VISATYPE
2
  
Num_Hrs_Reg_UC_Units NUMREGUC
6
 1 decimal place
Retire_FICA_Deriv_Ind RETDEVIND
1
  
Hrs_Toward_Benefits_Elig BENELHRS
11
 2 decimal places
Hrs_Toward_Career_Elig CARELHRS
11
 2 decimal places
Exec_Sev_Pay_YTD_Total YTDSEVPAY
13
 Fiscal year cumulative total. Not effective until 2001-2002 fiscal year.
Med_Contri_Base_Curr_Yr MEDBASCUR
3
 Annual base salary divided by 1000
Med_Contri_Base_Next_Yr MEDBASNXT
3
 Annual base salary divided by 1000
Sep_Vet_Date SEPVETDT
4
 YY/MM
HCRA_Indicator HCRAIND
1
 "Y" if enrolled in HCRA program
HCRA_Annual_Amount HCRAAMT
7
 no decimals
HCRA_Termination_Date HCRATDT
6
  
HCRA_YTD_Deductions HCRAYTD
11
 2 decimal places
START Reduction Percent STARTPCT
2
  
START Begin Date STARTBEGDT
6
 YY/MM/DD
START End Date STARTENDDT
6
 YY/MM/DD
Sr_Mgmt Sev Pay_Exc_Ind SMSEVEXCIND
1
 Y or N
Sr_Mgmt Over Contr Rate SMSEVORCNRT
1
  
Home_zip PERMPOST 5  
Depcare_Annual_Amt DEPANNAMT 5  
Depcare_Term_Date DEPTERMDT 6  
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
Emp_Location EMPLOC (defined)
13
 Location based on employee's Loc_Indicator; medical centers, UCOP, and ANR are all differentiated from campus.
OP_DANR_Location OPANRLOC (defined)
12
 Indicates whether the DANR or UCOP location is at a campus or at the Oakland systemwide office
Primary_Perspgm PRIPERPG (defined)
3
 Identifies the personnel program for the primary title by its acronym (MSP, SMG, PSS, or ACA)
Email_Address EMAILADD (in Address database)
50

The employee's work email address, as contained in the Telecom file
Class_Ttl_Outl_Name_Pri CTOA
30

The description of the CTO (Class Title Outline) code for the primary title.
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.
WOS_Emp WOS_CODE

1

 The employee has only without salary appointments, no appointments with salary.
Postdoc POST_DOC

1

 Indicates whether the employee has any postdoctoral scholar appointment.
Special_Training_Code SPECTRNG

1

 Indicates whether the employee should be included in Sexual Harassment Training extract for Workplace Answers.
SLCG_Grade SLCG_GRADE

3

 Code indicating the Senior Leadership Compensation Group (SLCG) for an employee. Valid values are 102-118 and 999.
SLCG_Eff_Date SLCG_EFFDT

10

 Effective Date of the employee Senior Leadership Compensation Group (SLCG) grade.
Ben_Unit_Code BEN_UNIT_CODE

2

 Code indicating Title Unit Code of the predominant appointment for benefits purposes
Ben_Rep_Cd BEN_REP_CD

1

 Code indicating whether Benefits Unit Elig  and Rep Codes should be derived by PPS
Ben_Unit_Der BEN_UNIT_DER

1

 Code indicating whether Benefits Unit Elig  and Rep Codes should be derived by PPS
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
Appointment_Number APPTNO
2
 A unique number assigned to each appointment for an employee
Title_Code CTITLE
4
  
Sub_Location SUBLOC
2
 Used only by 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
  
Grade_Type GRADETYPE

2

 The Grade type from the Title Code Table in PPS which is applicable to the title code.
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)
1
 Identifies the personnel program for the title by its acronym (MSP, SMG, PSS, or ACA)
Academic Senate Flag ACADSEN (defined)
1
 "Y" if the title is an Academic Senate title
Class_Ttl_Outl_Name_Appt CTOB
30

The description of the CTO (Class Title Outline) code for the title code.
Distribution Table Data
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_Rate_Code CDISTRT
1
  
Distrib_Unit_Code DUC
1
  
Loc Code LOCCD
2
 Used for sorting locations in specific order-19 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 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.
SAU_Code SAU
1
  
Distrib_Pay_Rate DSTPAYRT
10
  
Work_Study_Cur_Yr_Gross_Earn WORKSTDY
14
 2 decimal places
Org_3_Code CORGUNIT
7
  
Org_3 Title ORGUNIT
30
  
Org_1 Code CORGGRP
7
  
Org 1 Title ORGGRP
30
  
UAS_Discipline_Code CUASDISC
3
  
NSF_Code CNSF
3
  
Org_2_Code CORG2
7
  
Org_2 Title CORG2NM
30
  
Account_Group_Code ACCTGROUP
6
  
Fund_Group_Code FUNDGROUP
6
  
Function_Code FUNCTION
2
  
Budget_Code BDGTCODE
1
  
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
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
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
Gross_Earnings_Prior_FY PRFYGRS
17
 2 decimal places
Hours_Paid_Prior_FY PRFYHRS
12
 2 decimal places
Time_Distrib_Prior_FY PRFYFTE
12
 4 decimal places
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
Ret_Covcomp_Prior_FY RETCCPRY (defined)

16

 Retirement covered compensation earnings, based on the UCRS Gross Indicator, for earnings paid during the current fiscal year which were earned during a previous fiscal year (such as retroactive pay or adjustments to pay)
Ret_Covcomp_Total_FY RETCCFY (defined)

16

 The total retirement covered comp for the months July through June of the current fiscal year.
Payment_Category PAYCAT_DESC (defined)
20
 Translation of Payment Category Code
Payment_Category_Code PAYCAT
1
 Code indicating payment category associated with earnings, such as regular, leave, additional pay, etc.
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
Tot_FY_Gross Earnings TOTFYGRS (defined)
16
 The total gross earnings for months July through June of the current fiscal year.
Tot_FY_Hours Worked TOTFYHRS (defined)
16
 The total number of hours paid for months July through June of the current fiscal year.
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.
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
Function_Name FUNCDESC (defined)
30
 Field used to sort Fundsource into preferred order
DOS_Desc_CPS Not in CPS
51
 Full Description of the CPS Dos code
DOS_Desc_PPS Not in CPS
25
 Full Description of the PPS Dos code
FWT_Gross_Ind Not in CPS
1
 Indicates whether earnings are subject to federal withholding tax
Total_Gross_Ind Not in CPS 1 Indicates whether earnings are included in total gross earnings
Ins_Ben_Ind Not in CPS 1 Code indicating whether the pay rate associated with a Description of Service is included in the annual recalculation of benefits bases
Time_Ben_Ind Not in CPS 1 Code indicating whether or not the hours associated with a Description of Service are included in Hours Toward Leave Accrual
Pay_Stat_Ind Not in CPS 1 Code indicating whether or not the hours associated with a Description of Service are included in Hours on Pay Status
Dos_Obj_Code_Acad Not in CPS 4 Object code associated with academic salary activity
Dos_Obj_Code_Staff Not in CPS 4 Object code associated with staff salary activity
Ret_Cov_Cmp_FTE_Total Not in CPS 16 The FTE associated with earnings which are considered covered compensation for the purposes of UCRP
Fed_Tax_FTE_Total Not in CPS 16 The FTE associated with earnings which are subject to federal tax withholding
Fed_Tax_Gross_Total Not in CPS 16 Total gross earnings which are subject to federal tax withholding
Derived Pct_Julthrough Derived_Pct_Prior_FY DERPCTJUL through DERPCTJUN and PRFYDERPCT n.nnnn Derived percent for purposes of Effort Reporting