Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse LIBRARY ORDER TYPE Table


View exposing library order type reference values used to classify acquisitions transactions.


Field Name

Description

Data Type

Length

ACQUISITION_METHOD

Acquisition method associated with the record.

VARCHAR2

30

ACQUISITION_METHOD_CODE

Code identifying acquisition method.

VARCHAR2

3

IS_RUSH_ORDER

Indicator identifying whether rush order (Y/N).

VARCHAR2

3

LIBRARY_ORDER_TYPE

Library order type associated with the record.

VARCHAR2

20

LIBRARY_ORDER_TYPE_CODE

Code identifying library order type.

VARCHAR2

4

LIBRARY_ORDER_TYPE_KEY

Surrogate key identifying the library order type.

VARCHAR2

20

ORDER_MATERIAL

Order material associated with the record.

VARCHAR2

30

ORDER_MATERIAL_CODE

Code identifying order material.

VARCHAR2

3

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE