ADM GRAD PROGRAM Table
This table contains information about graduate admissions programs, including joint programs and research areas.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMISSIONS_PROGRAM |
XXX |
VARCHAR2 |
4 |
ADMISSIONS_PROGRAM_DESC |
XXX |
VARCHAR2 |
40 |
ADM_GRAD_PROGRAM_KEY |
Graduate Admissions Program Key. Use this field to join the ADM GRAD PROGRAM table to the Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL). |
VARCHAR2 |
20 |
DEPARTMENT_CODE |
Code identifying an academic department, eg. 18 for "Mathematics", 6 for "Electrical Eng & Computer Sci". In the Alumni's tables, the department codes used are different from those used in MITSIS. |
VARCHAR2 |
4 |
DEPARTMENT_NAME |
The name of the department, school, center, or lab. |
VARCHAR2 |
50 |
JOINT_PROGRAM |
XXX |
VARCHAR2 |
4 |
JOINT_PROGRAM_DESC |
XXX |
VARCHAR2 |
40 |
PROGRAM_TYPE |
XXX |
VARCHAR2 |
1 |
PROGRAM_TYPE_DESC |
XXX |
VARCHAR2 |
40 |
RESEARCH_AREA |
XXX |
VARCHAR2 |
4 |
RESEARCH_AREA_2 |
XXX |
VARCHAR2 |
4 |
RESEARCH_AREA_2_DESC |
XXX |
VARCHAR2 |
100 |
RESEARCH_AREA_3 |
XXX |
VARCHAR2 |
4 |
RESEARCH_AREA_3_DESC |
XXX |
VARCHAR2 |
100 |
RESEARCH_AREA_DESC |
XXX |
VARCHAR2 |
100 |
SCHOOL_CODE |
The school code for Schools at MIT, eg.: E (School of Engineering), S (Science) H (Humanities, Arts, and Social Sciences), M (Management) |
VARCHAR2 |
2 |
SCHOOL_NAME |
The descriptive text for SCHOOL_CODE. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |