THESIS SUPERVISOR DETAIL Table
View exposing thesis or research supervisor detail by academic term, faculty key, student, and subject including department and school, total units, and warehouse load date.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_TERMS_KEY |
Surrogate key identifying the academic terms. |
VARCHAR2 |
6 |
DEPARTMENT_CODE |
Code identifying department. |
VARCHAR2 |
8 |
DEPARTMENT_NAME |
Department name associated with the record. |
VARCHAR2 |
30 |
RESEARCH_SUPERVISOR_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_MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
SUBJECT_ID |
Business identifier for the subject. |
VARCHAR2 |
8 |
SUBJECT_TITLE |
Subject title associated with the record. |
VARCHAR2 |
60 |
TEACHING_FACULTY_KEY |
Surrogate key identifying the teaching faculty. |
VARCHAR2 |
15 |
TOTAL_UNITS |
Total units associated with the record. |
NUMBER |
2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |