STUDENT MINOR Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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 |
MINOR_DEPARTMENT_CODE |
XXX |
VARCHAR2 |
4 |
MINOR_FIELD_CODE |
Minor field (eg. "14" for Economics, "15" for Management) |
VARCHAR2 |
4 |
MINOR_FIELD_DESC |
XXX |
VARCHAR2 |
60 |
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 |
The name of the school from which the person earned the highest or most recent degree. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |