GRADUATE AWARDING DEPARTMENT Table
The dimension table consists of all the academic departments and their schools at MIT. Limit on the awarding department fields in this table, and join it to the GRADUATE AWARD TERM DETAIL table for graduate awards that are awarded by the specific department.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AWARDING_DEPARTMENT |
A code indicating the Department or Department Office that entered the graduate award. Valid values include: GSO=Graduate Education Office 1=Civil Engineering 2=Mechanical Engineering 3=Materials Engineering TOX=Toxicology NOTE: This is the department that entered the award. It does NOT necessarily mean the student is enrolled in this department. This IS the Department to contact to make any corrections on MITSIS, however. |
VARCHAR2 |
4 |
AWARDING_DEPARTMENT_KEY |
The key identifying a unique entry in the GRADUATE AWARDING DEPARTMENT table. Use this key to join to the GRADUATE AWARD TERM DETAIL TABLE for graduate awards data. This field is not used for reporting |
VARCHAR2 |
4 |
AWARDING_DEPARTMENT_NAME |
Name of the awarding department of graduate student financial awards |
VARCHAR2 |
30 |
SCHOOL_NAME |
The descriptive text for SCHOOL_CODE. |
VARCHAR2 |
30 |
SIS_DEPT_BUDGET_CODE |
XXX |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |