This table contains students' degree information from external institutions including high school diplomas.
For first-year applicants, in theory, what is in ADM_APPL_DATA and EXT_DEGREE should match. If anything, they could be off by only a few days. For transfer applicants, you would need to look at the ext_degree table for this information. The data in both tables are entered manually and one does not flow to the other.
Key | Record.Fieldname | Format | XLAT | Heading Text | Note |
---|---|---|---|---|---|
DEGREE - Degree | Char8 | Degree | |||
DEGREE_DT - Degree Date | Date | Deg Dt | |||
DEGREE_STATUS - Degree Status | Char1 | N | Deg Status | ||
DESCR - Description | Char30 | Descr | |||
→ | EMPLID - Empl ID | Char11 | ID | ||
EXT_CAREER - External Career | Char4 | N | Career | some examples: | |
EXT_DATA_NBR - External Data Nbr | Num3.0 | Data Nbr | |||
→ | EXT_DEGREE_NBR - External Degree Number | Num3.0 | Degree Nbr | ||
→ | EXT_ORG_ID - External Org ID | Char11 | Org ID | EXT_ORG_TBL | |
EXT_SUBJ_AREA_1 - External Subject Area 1 | Char4 | Subject 1 | EXT_SUBJECT_TBL | ||
EXT_SUBJ_AREA_2 - External Subject Area 2 | Char4 | Subject 2 | EXT_SUBJECT_TBL | ||
FIELD_OF_STUDY_1 - Field of Study 1 | Char30 | Study Fld1 | |||
FIELD_OF_STUDY_2 - Field of Study 2 | Char30 | Study Fld2 | |||
HONORS_CATEGORY - Honors Category | Char4 | N | Category | ||
LS_DATA_SOURCE - Data Source | Char3 | N | Data Srce |
Attachments:





