Data Elements in the Personnel Data Warehouse Per_Snap_Curr_Dep and Per_Snap_All_Dep tables
Click on data element name for DEP data dictionary information
| Data Element Name | DEP/CPS FOCUS Name |
Size
|
Comment |
| Eff_Date | CYCLE |
7
|
Different format from CYCLE in DEP. MAR2001 rather than MAR01. |
| Location_1 | DCCAMPUS |
2
|
|
| Employee_Number | DEMPNO |
9
|
|
| Social_Security_Number | EMPSSN |
9
|
|
| Employee_Name | EMPNAME |
35
|
|
| Personnel_Program_Primary | PROGPRI |
1
|
|
| Home_Department_Code | CHOMEDEPT |
6
|
|
| Home_Department_Name | HOMEDEPT |
30
|
|
| UCOP_Employee_Ind | COP |
1
|
|
| Dep_Number | DEPNO |
2
|
|
| Dep_Date_of_Birth | DEPDOB |
10
|
MM/DD/YY |
| Dep_Deenrollment_Cntl_Code | DEPDIS |
1
|
|
| Dep_Deenrollment_Desc | Not in DEP |
30
|
Translation of Dep Deenrollment Cntl Code |
| Dep_Dental_Coverage_Date | DDENCVGDT |
10
|
MM/DD/YY |
| Dep_Legal_Coverage_Date | DLGLCVGDT |
10
|
MM/DD/YY |
| Dep_Medical_Coverage_Date | DMEDCVGDT |
10
|
MM/DD/YY |
| Dep_Name | DEPNAME |
26
|
|
| Dep_Optical_Coverage_Date | DVISCVGDT |
10
|
MM/DD/YY |
| Dep_Relation_Code | DEPREL |
1
|
|
| Dep_Relation_Desc | Not in DEP |
40
|
Translation of Dep Relation Code |
| Dep_Sex_Code | DEPSEXCD |
1
|
|
| Dep_Social_Security_Number | DEPSSN |
9
|