STUDENT COURSE OF MAJOR Table
View exposing student course of major data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COURSE |
Course associated with the record. |
VARCHAR2 |
9 |
COURSE_DESCRIPTION |
Description of course. |
VARCHAR2 |
30 |
COURSE_LEVEL |
Course level associated with the record. |
VARCHAR2 |
2 |
DEPARTMENT_FULL_NAME |
Department full name associated with the record. |
VARCHAR2 |
35 |
IS_DOUBLE_MAJOR |
Indicator identifying whether double major (Y/N). |
VARCHAR2 |
1 |
IS_PRIMARY_COURSE |
Indicator identifying whether primary course (Y/N). |
VARCHAR2 |
1 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
SCHOOL_NAME |
School name associated with the record. |
VARCHAR2 |
30 |
STUDENT_DEPARTMENT_CODE |
Code identifying student department. |
VARCHAR2 |
6 |
STUDENT_DEPARTMENT_NAME |
Student department name associated with the record. |
VARCHAR2 |
30 |
STUDENT_TERM_ENROLLMENT_KEY |
Surrogate key identifying the student term enrollment. |
VARCHAR2 |
15 |
TERM_CODE |
Term code associated with the record. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |