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:
image2022-1-13_13-9-31.png (image/png)
image2022-1-13_13-15-51.png (image/png)
image2022-1-13_13-18-18.png (image/png)
image2022-1-13_13-19-55.png (image/png)
image2022-1-13_13-20-43.png (image/png)
image2022-1-13_13-21-11.png (image/png)