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
|
Different format from CYCLE in CPS. MAR2001 rather than MAR01. |
| 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
|
Doesn't include Hastings or ASUCLA |
| Location_11_Dist | 11LOC |
5
|
Doesn't include Hastings or ASUCLA |
| Time_Distrib_Actual | MONFTE |
5
|
|
| Loc Code | Not in CPS |
2
|
21 through 25 for labs |
| Locnm 2 | Not in CPS |
2
|
AS, HA, LB, LN, LV |
| Locnm 5 | Not in CPS |
5
|
ASUCL, HAST, LAL, LBL, LLL |
| Locnm 13 | Not in CPS |
13
|
ASUCLA, Hastings, LBL, Livermore, Los Alamos |
| 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 |
Last Updated: August 10, 2004