Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse LIBRARY COLLECTION Table


View exposing library collection reference records including collection identifiers, collection names, and related classification attributes.


Field Name

Description

Data Type

Length

LIBRARY_COLLECTION

Library collection associated with the record.

VARCHAR2

100

LIBRARY_COLLECTION_CODE

Code identifying library collection.

VARCHAR2

5

LIBRARY_COLLECTION_KEY

Surrogate key identifying the library collection.

VARCHAR2

12

LIBRARY_ITEM_MATERIAL

Library item material associated with the record.

VARCHAR2

30

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE