Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse COMMITMENT TYPE Table


View exposing commitment type reference data including commitment category, LDS indicator, blanket-order indicator, and warehouse load date.


Field Name

Description

Data Type

Length

COMMITMENT_CATEGORY

Commitment category as provided by the source.

VARCHAR2

31

COMMITMENT_CATEGORY_CODE

Code identifying commitment category.

VARCHAR2

2

COMMITMENT_TYPE_KEY

Surrogate key identifying the commitment type.

VARCHAR2

4

IS_BLANKET_ORDER_COMMITMENT

Indicator identifying whether blanket order commitment (Y/N).

VARCHAR2

1

IS_LDS_COMMITMENT

Indicator identifying whether lds commitment (Y/N).

VARCHAR2

1

WAREHOUSE_LOAD_DATE

Date associated with warehouse load.

DATE