THESIS SUPERVISOR DETAIL Table
This table contains records for graduate thesis supervisor by academic term, ie. Information about the supervisor, the student, and the THG subject.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_TERMS_KEY |
Use this field to join to the ACADEMIC_TERMS table to get information about the academic term(s). |
VARCHAR2 |
6 |
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 |
RESEARCH_SUPERVISOR_MIT_ID |
MIT ID of the research/thesis supervisor of this student for this subject. |
VARCHAR2 |
9 |
SCHOOL_NAME |
The descriptive text for SCHOOL_CODE. |
VARCHAR2 |
30 |
STUDENT_MIT_ID |
The student's MIT ID |
VARCHAR2 |
9 |
SUBJECT_ID |
The subject ID (eg.18.01, 15.012, 21W.731) |
VARCHAR2 |
8 |
SUBJECT_TITLE |
The title of the subject |
VARCHAR2 |
100 |
TEACHING_FACULTY_KEY |
XXX |
VARCHAR2 |
15 |
TOTAL_UNITS |
Total number of credit units of a subject. |
NUMBER |
2 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |