| Data element |
Definition |
EMPLID
Indexed - Yes
Format - VARCHAR2
Nullable - N | Unique identifier for individual (non-org) records. |
EXT_ORG_ID
Indexed - Yes
Format - VARCHAR2
Nullable - N | Unique identifier for org (non-individual) records. In this table it is for the external degree granting school. |
EXT_DEGREE_NBR
Indexed - Yes
Format - NUMBER
Nullable - N | Part of the key, this is a counter of external degrees. |
DEGREE
Indexed - No
Format - VARCHAR2
Nullable - N | Non-Penn (external) degree. |
DESCR
Indexed - No
Format - VARCHAR2
Nullable - N | Type of degree. |
DEGREE_DT
Indexed - No
Format - DATE
Nullable - Y | Date of external degree. |
DEGREE_STATUS
Indexed - No
Format - VARCHAR2
Nullable - N | Status of degree, e.g. complete. |
HONORS_CATEGORY
Indexed - No
Format - VARCHAR2
Nullable - N | Honor category |
EXT_SUBJ_AREA_1
Indexed - No
Format - VARCHAR2
Nullable - N | Not used |
EXT_SUBJ_AREA_2
Indexed - No
Format - VARCHAR2
Nullable - N | Not used |
FIELD_OF_STUDY_1
Indexed - No
Format - VARCHAR2
Nullable - N | Free text for listing field of study |
FIELD_OF_STUDY_2
Indexed - No
Format - VARCHAR2
Nullable - N | Free text for listing field of study |
EXT_CAREER
Indexed - No
Format - VARCHAR2
Nullable - N | Type of degree |
EXT_DATA_NBR
Indexed - No
Format - NUMBER
Nullable - N | Not used |
LS_DATA_SOURCE
Indexed - No
Format - VARCHAR2
Nullable - N | |
