All tables in this data category contain multi column keys. In the following table lists, an asterik (*) follows the name of a column that belongs to a multi column key. For each table in the category, these multi column keys identify a unique row in the table.
| Table Name DEG_CMPLTD | ||||||
|---|---|---|---|---|---|---|
| Column Name | Column Description | Data Type | Length | Source Definition | Source Derivation | Values |
| ACT_INSTN | Act Institution Code | VARCHAR2 | 4 | Identifies each campus to the American College Testing Organization. Also used to identify a campus when reporting for MSAS, IPEDS, and CBHE. | SRDB SYSTAB16 | Columbia: 2382 , Kansas: 2380, Rolla: 2398 and St.Louis: 2383 |
| CIP_CD | Classification Of Instructional Program Code | VARCHAR2 | 6 | the Classification of Instructional Program code for the degree awarded. | SRDB SYSTAB07 | Examples: 420101 or 450801 |
| CMP_CD* | Campus Code | CHAR | 1 | Identifier of campus location where student earned the degree completed. | SRDB CAMP001 | Columbia: C, Kansas: K, Rolla: R and St.Louis: S |
| DEG_ABBRV | Degree Abbreviation | VARCHAR2 | 5 | Abbreviated descriptor that identifies degrees previously awarded or sought. | SRDB PDEG030 -> SYSTAB06 | Examples: Master Of Science = MS, Doctor of Philosophy = PHD Bachelor Of Journalism = BJ |
| DEG_CD | Degree Code | VARCHAR2 | 2 | Identifies type of degree for which the student has been awarded. | SRDB DGSA006 | Example: BS = 04 |
| DEG_DESC | Degree Description | VARCHAR2 | 50 | Description of the type of degree which the student has been awarded. | SRDB DGSA006 -> SYSTAB06 | Example: BACHELOR OF SCIENCE |
| DEG_LVL_CD | Degree Level Code | CHAR | 1 | code that identifies the level of the degree awarded. | SRDB DGSA006 -> SYSTAB06 | Example: BS = 3 |
| DEG_LVL_DESC | Degree Level Description | VARCHAR2 | 30 | Describes the level of the degree awarded. | SRDB DGSA006 -> SYSTAB06 pos. 65 -> hardcode | Example: Doctor of Medicine = PROFESSIONAL |
| GPA | Grade Point Average | NUMBER | 4,3 | Student's grade point average when degree was awarded. | SRDB DGPA006 | Format=9.999 |
| HNRS_CD | Degree Honors Code | CHAR | 1 | Honors Code: 19 codes, conferred upon the student by an academic unit when the degree was awarded. | SRDB DGHN006 -> SYSTAB10 | Format=X |
| MSAS_LVL | Missouri Student Achievement Study Level | CHAR | 1 | the Missouri Student Achievement Study degree level as derived by the C1 Completions program and defined by the degree level. | SRDB DGSA006 -> SYSTAB06 pos. 65 -> hardcode | CBHE defined |
| PGM_ABBRV | Degree Program Abbreviation | VARCHAR2 | 7 | Abbreviated descriptor that identifies the degree program in which the degree was awarded. | SRDB DGPG006 -> SYSTAB07 | JOURNALISM = JOURN |
| PGM_AU_ABBRV | Degree Program Academic Unit Abbreviation | VARCHAR2 | 5 | Abbreviated descriptor that identifies the academic unit which adminsters the degree program in which the degree was awarded. | SRDB CAMP001||DGAU006 -> SYSTAB09 | EDUCATION = EDUC |
| PGM_AU_CD* | Degree Program Academic Unit Code | VARCHAR2 | 2 | Code of school or college responsible for the degree program in which the degree was awarded. | SRDB DGAU006 | Example: UMC in Education = 14 |
| PGM_AU_DESC | Degree Program Academic Unit Description | VARCHAR2 | 35 | Name of the college or school responsible for the degree program in which the degree was awarded. | SRDB CAMP001 || DGAU006 -> SYSTAB09 | Example: EDUCATION |
| PGM_CD | Degree Program Code | VARCHAR2 | 4 | Code the degree program in which the degree has been awarded. | SRDB DGPG006 | Format = 9999 |
| PGM_DEPT_ABBRV | Degree Program Department Abbreviation | VARCHAR2 | 7 | Abbreviated descriptor that identifies the department or academic support unit for the degree program. | SRDB DGPG006 || DGEM006 -> SYSTAB07 pos. 65-68 || CAMP001 -> SYSTAB04 | Example: B&PA |
| PGM_DEPT_CD | Degree Program Department Code | VARCHAR2 | 5 | Code of the department or academic support unit responsible of the degree program. | SRDB DGPG006||DGEM006 -> SYSTAB07 pos. 65-68 || CAMP001 | Example: K0270 |
| PGM_DEPT_DESC | Degree Program Department Description | VARCHAR2 | 50 | Name of the department or academic support unit responsible for the degree program. | SRDB DGPG006||DGEM006 -> SYSTAB07 pos 65-68 || CAMP001 | Example: BUSINESS AND PUBLIC ADMINISTRATION |
| PGM_DESC | Degree Program Description | VARCHAR2 | 32 | Name of degree program in which the degree was awarded. | SRDB DGPG006 -> SYSTAB07 | Example: OPTOMETRY |
| PGM_EMPH_ABBRV | Degree Program Emphasis Area Abbreviation | VARCHAR2 | 7 | Abbreviated descriptor of the area of concentration within the degree program. | SRDB CAMP001||DGPG006||DGEM006 -> SYSTAB07 | Example: GENRL |
| PGM_EMPH_CD | Degree Program Emphasis Area Code | VARCHAR2 | 2 | Code of the area of concentration within the degree program. | SRDB DGEM006 | Format =99 |
| PGM_EMPH_DESC | Degree Program Emphasis Area Description | VARCHAR2 | 25 | Describes the area of concentration within a degree program. | SRDB CAMP001 || DGPG006 || DGEM006 -> SYSTAB07 | Example: GENERAL |
| PGM_INDCTR_CD | Degree Program Indicator Code | CHAR | 1 | Code that indicates whether the degree awarded in the degree program was a primary or secondary degree when the student was dual degree seeking within the same academic unit. | SRDB DGPP006 | P = PRIMARY or S = SECONDARY |
| PGM_INDCTR_DESC* | Degree Program Indicator Description | VARCHAR2 | 10 | Indicates whether the degree awarded within the degree program was a primary or secondary degree if the student was dual degree seeking within the same academic unit. | SRDB CAMP001, DGPP006 | PRIMARY or SECONDARY |
| STU_FED_ID_NO* | Student Federal Identification Number | VARCHAR2 | 9 | Student's federal identification number. | SRDB SSNO001 | Format:999999999 |
| TERM* | Census Point Term | VARCHAR2 | 4 | Term and year of census point to which the degree completed information corresponds. | derived hardcode | SS1998 FS1998 WS1999 |