Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse LIBRARY CURRENCY Table


View exposing currency reference records used in library acquisitions, purchasing, and invoicing processes.


Field Name

Description

Data Type

Length

CURRENCY_CODE

Code identifying currency.

VARCHAR2

3

CURRENCY_KEY

Surrogate key identifying the currency.

VARCHAR2

3

CURRENCY_NAME

Currency name associated with the record.

VARCHAR2

50

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE