Data Elements in the Personnel Data Warehouse Per_Academic_All and Per_Academic_Curr 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
|
|
| Acad_Prior Service_Code | ACPRSVC |
1
|
Prior service code |
| Acad_Prior_Service |
40
|
Translation of Prior service code | |
| Acad_Prior_Institution_Code | ACPRINST |
3
|
Prior institution code |
| Acad_Prior_Institution |
40
|
Prior institution name | |
| Edu_Level_Code | ACEDLVL |
1
|
Education level code |
| Edu_Level |
35
|
Translation of Education level | |
| Edu_Level_Year | AEDLVLYR |
2
|
Education level year |
| Edu_Level_year_4 | TAEDLVLYR |
4
|
Education level year - 4 digit |
| Edu_Institution_Code | ACEDINST |
3
|
Education institution code |
| Edu_Institution |
40
|
Translation of Education institution code | |
| Edu_Field_Code | ACEDFLD |
4
|
Education field code |
| Edu_Field |
35
|
Education field | |
| Separated_Emp_Dest_Code | ACEMPDEST |
1
|
Separated employee destination code |
| Separated_Emp_Dest |
40
|
Translation of Separated employee destination | |
| Future_Institution_Code | ACFUTINST |
3
|
Future institution code |
| Future_Institution |
40
|
Future institution name | |
| Separation_Reason_Code | ACSEPRSNA |
2
|
Separation reason code - academic |
| Separation_Reason |
35
|
Translation of Separation reason code- academic |
Last Updated: March 7, 2004