|
|
|
EXCHANGE ITEM FOOTNOTE DETAIL
This is a fact table that contains documentation and footnotes for a particular exchange item of an institution for a particular year.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| ACADEMIC_YEAR_KEY | Use this field to join the ACADEMIC YEAR table to a fact table for time dimension information. | VARCHAR2 | 4 |
| EXCHANGE_ITEM_KEY | Use this field to join together the EXCHANGE ITEM and EXCHANGE ITEM FOOTNOTE DETAIL tables. | VARCHAR2 | 8 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| NOTE | Note | VARCHAR2 | 200 |
| URL | The URL to a web site which may provide more information about the item. | VARCHAR2 | 200 |
| 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