Data Elements in the Personnel Data Warehouse Per_Snap_Curr_Dist, _Prior_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
|
|
| 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
|
|
| Account_Group_Code | ACCTGROUP |
6
|
|
| DOS_Code_PPS | PDOS |
3
|
|
| Distrib_Pay_Rate | DSTPAYRT |
10
|
|
| Distrib_Rate_Code | CDISTRT |
1
|
|
| Function_Code | FUNCTION |
2
|
|
| Function_Name | FUNCT |
30
|
|
| Fund_Group_Code | FUNDGROUP |
6
|
|
| 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. |
| Org_1_Code | CORGGRP |
7
|
Differs from ORG 1 in Financial tables - the campus code is affixed to the beginning of the code; e.g., 44500 for ORG 1 4500 at UCLA |
| Org_1 Title | ORGGRP |
30
|
|
| Org_2_Code | CORG2 |
7
|
|
| Org_2 Title | CORG2NM |
30
|
|
| Org_3 Code | CORGUNIT |
7
|
|
| Org_3 Title | ORGUNIT |
30
|
|
| SAU_Code | SAU |
1
|
|
| Time_Distrib_Actual | MONFTE |
5
|
|
| UAS_Discipline_Code | CUASDISC |
3
|
|
| UAS_Discipline_Name | UASDISC |
35
|
|
| 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 |
| Tot_FY_Gross_Earnings | Not in CPS |
18 |
Total gross earnings for all months within the fiscal year |
| Tot_FY_Hours_Worked | Not in CPS |
18 |
Total hours worked for all months within the fiscal year |
| Tot_FY_Time_Distrib | Not in CPS |
18 |
Total monthly Time_Dist (FTE) for all months within the fiscal year (of limited usefulness, but may be divided by 12 to get an average monthly FTE) |
| 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 |
| Budg_Fund | BDGTCODE |
1 |
"B" indicates that the fund is incorporated into the annual UC budget |
| 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. |
| 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 | Not in CPS | 16 | The FTE associated with earnings which are considered covered compensation for the purposes of UCRP |
| Fed_Tax_FTE | Not in CPS | 16 | The FTE associated with earnings which are subject to federal tax withholding |
| Fed_Tax_Gross | Not in CPS | 16 | Total gross earnings which are subject to federal tax withholding |
| Derived Pct | DERPCT | n.nnnn | Derived percent for purposes of Effort Reporting |
Check Date |
CHECK_DATE |
8 YYYY/MM/DD |
For cancellation, handdrawn, or current activity PAR records, the date the check or the check/advice was issued. For overpayment PAR records, the date on which the overpayment worksheet was prepared (transaction date). Added July 2012. |
| Earnings_Trans_Code |
ERN_TRANS_CD |
2 | Code indicating the type of transaction associated with the Earnings Distribution-PAR (PAR 2990). Added July 2012 |
| Full_FAU |
FULL_FAU | 30 | The local Full Accounting Unit. Added July 2012 |