SIS DEPARTMENT Table
This table contains information about academic departments and schools as recorded in MITSIS.
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 |
DEPARTMENT_FULL_NAME |
XXX |
VARCHAR2 |
40 |
DEPARTMENT_LAST_ACTIVITY_DATE |
XXX |
DATE |
7 |
DEPARTMENT_NAME |
The name of the department, school, center, or lab. |
VARCHAR2 |
50 |
DEPARTMENT_NAME_HISTORY |
XXX |
VARCHAR2 |
250 |
DEPT_BUDGET_CODE |
Budget code assigned to the department. |
VARCHAR2 |
6 |
DEPT_NAME_IN_COMMENCEMENT_BK |
XXX |
VARCHAR2 |
80 |
DLC_KEY |
a unigue key to enable joining information stored with other forms of Department Key |
VARCHAR2 |
15 |
IS_DEGREE_GRANTING |
'Y' indicates that this is a degree granting department. |
VARCHAR2 |
1 |
SCHOOL_CODE |
The school code for Schools at MIT, eg.: E (School of Engineering), S (Science) H (Humanities, Arts, and Social Sciences), M (Management) |
VARCHAR2 |
2 |
SCHOOL_NAME |
The descriptive text for SCHOOL_CODE. |
VARCHAR2 |
30 |
SCHOOL_NAME_IN_COMMENCEMENT_BK |
XXX |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |