Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse LIBRARY MATERIAL STATUS Table


View exposing library material status reference values used to classify material availability and processing states.


Field Name

Description

Data Type

Length

LIBRARY_MATERIAL_STATUS

Library material status associated with the record.

VARCHAR2

50

LIBRARY_MATERIAL_STATUS_CODE

Code identifying library material status.

VARCHAR2

1

LIBRARY_MATERIAL_STATUS_KEY

Surrogate key identifying the library material status.

VARCHAR2

1

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE