Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse COMMITMENT TYPE Table


A dimension table to be used with commitment fact tables, to identify types of commitments, such as blanket orders or LDS. Also includes commitment type codes and descriptions.


Field Name

Description

Data Type

Length

COMMITMENT_CATEGORY

Category of commitment: currently Manual Commitment, Purchase Order Commitment, and Purchase Requisition Commitment.

VARCHAR2

50

COMMITMENT_CATEGORY_CODE

Code designating category of commitment as defined in SAP. See Commitment_Category definition for descriptions.

VARCHAR2

2

COMMITMENT_TYPE_KEY

Key used to join to the COMMITMENT_TYPE table which describes various aspects of the commitment.

VARCHAR2

5

IS_BLANKET_ORDER_COMMITMENT

Flag indicating whether a commitment is a blanket order. Values: Y or N.

VARCHAR2

1

IS_LDS_COMMITMENT

Flag indicating whether a commitment is an LDS commitment. Values: Y or N.

VARCHAR2

1

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8