AAUDE banner MIT Data Warehouse logo

EXCHANGE ITEM

This is a dimension table that contains the name and some characteristics of all the exchange items in the Data Warehouse


Field Name Description Data Type Length
EXCHANGE_ITEM AAUDE Exchange Item VARCHAR2 60
EXCHANGE_ITEM_DESC Description of an AAUDE exchange item. VARCHAR2 2000
EXCHANGE_ITEM_KEY Use this field to join together the EXCHANGE ITEM and EXCHANGE ITEM FOOTNOTE DETAIL tables. VARCHAR2 8
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