STUDENT COURSE OF MAJOR Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COURSE |
The major program (eg. "6 2", "15 M", "18 D") in which the student is enrolled in for the current term. |
VARCHAR2 |
9 |
COURSE_DESCRIPTION |
The description of the course or program (eg. "Elec. Eng & Comp Sci" for "6 2", "Management - SM" for "15 M", "Mathematics Doctoral" for "18 D") in which a student is enrolled. |
VARCHAR2 |
30 |
COURSE_LEVEL |
The level (Graduate or Undergraduate) of the course of major/degree program in which a student is enrolled. |
VARCHAR2 |
2 |
DEPARTMENT_FULL_NAME |
XXX |
VARCHAR2 |
35 |
IS_DOUBLE_MAJOR |
A "Y" in this field indicates that the student is enrolled pursuing an undergraduate double major. "N" otherwise |
VARCHAR2 |
1 |
IS_PRIMARY_COURSE |
A "Y" or "N" flag indicates whether this is the primary course/degree program a student is enrolled in. |
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 |
The descriptive text for SCHOOL_CODE. |
VARCHAR2 |
30 |
STUDENT_DEPARTMENT_CODE |
XXX |
VARCHAR2 |
6 |
STUDENT_DEPARTMENT_NAME |
XXX |
VARCHAR2 |
30 |
STUDENT_TERM_ENROLLMENT_KEY |
Use this field to join to the STUDENT TERM ENROLLMENT table |
VARCHAR2 |
15 |
TERM_CODE |
** For FINANCIAL DATA: the Term Code identifies the status of the cost collector. Blank - open for charges between start and end dates. Term Code = 1 - Closed. Pre-end date charges allowed. Term Code = 2 - No longer in use. Term Code = 3 - Terminated. Charges not allowed. ** For STUDENT DATA: the Term Code identifies one of the terms in an academic year; for example: 1999FA==>Fall Term of the 1998-99 academic year, and 1999SP==>Spring Term of the 1998-99 academic year. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |