Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse LIBRARY ITEM STATUS Table


View exposing library item status reference values used to classify item availability and circulation conditions.


Field Name

Description

Data Type

Length

LIBRARY_ITEM_PROCESS_STATUS

Library item process status associated with the record.

VARCHAR2

45

LIBRARY_ITEM_PROCESS_STAT_CODE

Code identifying library item process stat.

VARCHAR2

3

LIBRARY_ITEM_STATUS

Library item status associated with the record.

VARCHAR2

40

LIBRARY_ITEM_STATUS_CODE

Code identifying library item status.

VARCHAR2

3

LIBRARY_ITEM_STATUS_KEY

Surrogate key identifying the library item status.

VARCHAR2

20

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE