ADM GRAD TIME Table
This table is used as a time dimension for querying the graduate admissions data. Included in this table are fields such as the expected entry term, expected entry year, expected entry month, corresponding to the academic year.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_YEAR |
Academic year |
VARCHAR2 |
4 |
ADM_GRAD_TIME_KEY |
Graduate Admissions Time Key. Use this field to join the ADM GRAD TIME table to the Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL). |
VARCHAR2 |
6 |
ENTRY_MONTH |
Expected month of entry to a graduate program at MIT. |
VARCHAR2 |
30 |
ENTRY_TERM |
The academic term code (eg. 2004FA for Fall term 2003-2004, 2004SP for Spring Term 2003-2004) to which the applicant has applied for admission. |
VARCHAR2 |
6 |
ENTRY_TERM_DESC |
Expcted term of entry to a graudate program at MIT. |
VARCHAR2 |
30 |
ENTRY_YEAR |
The academic year to which the applicant has applied for admissions. |
VARCHAR2 |
4 |
ENTRY_YEAR_DESC |
Expected year of entry to a graduate program at MIT. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |