Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse LIBRARY ORDER STATUS Table


View exposing library order status reference values used to classify acquisitions order processing states.


Field Name

Description

Data Type

Length

LIBRARY_ORDER_STATUS

Library order status associated with the record.

VARCHAR2

30

LIBRARY_ORDER_STATUS_KEY

Surrogate key identifying the library order status.

VARCHAR2

20

ORDER_ARRIVAL_STATUS

Order arrival status associated with the record.

VARCHAR2

30

ORDER_INVOICE_STATUS

Order invoice status associated with the record.

VARCHAR2

30

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE