Data Elements in the Personnel Data Warehouse Per_FY_Curr_Dist and _All_Dist 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
|
|
| Appointment_Number | APPTNO |
2
|
A unique number assigned to each appointment for an employee |
| 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_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_Jul through Derived_Pct_Prior_FY |
DERPCT_mmm | n.nnnn | Derived percent for purposes of Effort Reporting |