| Data element |
Definition |
DEGREE_RECEIVED_DESC
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The description of the educational degree granted to the individual. |
DEGREE_RECEIVED_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The system identifier for the educational degree granted to the individual. |
FIELD_OF_STUDY_DESC
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The description of the individual's educational field of study. |
FIELD_OF_STUDY_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The system identifier for the individual's educational field of study. |
GPA
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The Grade Point Average (GPA) the individual achieved for the particular degree on the HCM_PERSON_EDUCATION row. |
LAST_EXTRACT_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date on which the record was extracted from Workday and loaded to the Data Warehouse. |
PENN_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The 8-digit identification number assigned to an individual by Penn Community system. For example: 77777777. No two persons have the same Penn ID. Note that Penn IDs created in and assigned by Penn Community begin at 10000000. Within the Data Warehouse, the numeric range from 00000000-00999999 is used for individuals who do not yet have a Penn ID in Penn Community, to allow for reliable joins between tables using the PENN_ID column. When a Penn ID appears for the individual appear in Penn Community, it will replace the assigned value throughout the Data Warehouse. |
PRI_PENN_AU_COST_CENTER
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The 4-digit number for the Penn Cost Center associated with the Academic Unit of the person's primary appointment. This field is only populated for academic workers or affiliates with a current appointment. |
PRI_PENN_COST_CENTER
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The 4-digit number for the Penn Cost Center associated with the primary position. This field is only populated for workers with a current position. |
PRI_PENN_SCH_CTR
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The 2-digit number used to identify the school or center for the Penn Cost Center associated with the primary position. This field is only populated for workers with a current position. |
SCHOOL_DESC
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The system description of the institution where the individual pursued the particular degree on the HCM_PERSON_EDUCATION row. |
SCHOOL_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The system identifier for the institution where the individual pursued the particular degree on the HCM_PERSON_EDUCATION row. |
SCHOOL_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The name of the institution where the individual pursued the particular degree on the HCM_PERSON_EDUCATION row. |
WORKDAY_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
The unique ID for a worker or affiliate in Workday. Although 8 digits long, it is distinct from and should not be confused with the Penn ID. |
YEAR_DEGREE_RECEIVED
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Year_Degree_Received: The year in which the person received the particular degree on the HCM_PERSON_EDUCATION row. |
