Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse RELEASE INDICATOR Table


View exposing purchasing release-indicator reference data including release description, planning and quotation indicators, purchase-order release indicator, field-selection reference, and changeability-after-release code.


Field Name

Description

Data Type

Length

CHANGEABLE_AFTER_RELEASE_CODE

Code identifying changeable after release.

VARCHAR2

1

FIELD_SELECTION_REFERENCE_KEY

Surrogate key identifying the field selection reference.

VARCHAR2

4

IS_FIXED_FOR_REQMTS_PLANNING

Indicator identifying whether fixed for reqmts planning (Y/N).

VARCHAR2

1

IS_RELEASED_FOR_PO

Indicator identifying whether released for po (Y/N).

VARCHAR2

1

IS_RELEASED_FOR_QUOTATION

Indicator identifying whether released for quotation (Y/N).

VARCHAR2

1

RELEASE_INDICATOR

Indicator identifying whether release (Y/N).

VARCHAR2

1

RELEASE_INDICATOR_DESCRIPTION

Description of release indicator.

VARCHAR2

30

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE