|
|
|
ACADEMIC YEAR
Contains information about academic years.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| ACADEMIC_YEAR | Academic year, eg. 1999-2000, 2001-2002 | VARCHAR2 | 9 |
| ACADEMIC_YEAR_DESC | Description for the academic year | VARCHAR2 | 30 |
| ACADEMIC_YEAR_KEY | Use this field to join the ACADEMIC YEAR table to a fact table for time dimension information. | VARCHAR2 | 4 |
| ACAD_YEAR_BEGIN_TERM | The first/begining term of an academic year, usually it's the Fall term | VARCHAR2 | 12 |
| BEGIN_YEAR | The calendar year when the academic year starts. For example, in academic year 2001-2002, this field contains the value "2001". This is a numeric year which can be used for computation | NUMBER | 4 |
| END_YEAR | The calendar year when the academic year ends. For example, in academic year 2001-2002, this field contains the value "2002". This is a numeric field which can be used for computation | NUMBER | 4 |
| WAREHOUSE_LOAD_DATE | The date the records were last loaded/updated in this table in the Data Warehouse | DATE | 7 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home