Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse WORK ORDER SYSTEM STATUS Table


XXX


Field Name

Description

Data Type

Length

IS_CLOSED

Y= this account is closed.

VARCHAR2

1

IS_CONFIRMED

XXX

VARCHAR2

1

IS_CREATED

XXX

VARCHAR2

1

IS_DELETION_FLAG_SET

XXX

VARCHAR2

1

IS_DELETION_INDICATOR_SET

XXX

VARCHAR2

1

IS_FRM_CREATD_TO_TECH_COMPLETD

XXX

VARCHAR2

1

IS_NOT_COMPLETED

XXX

VARCHAR2

1

IS_PARTIALLY_CONFIRMED

XXX

VARCHAR2

1

IS_PRINTED

XXX

VARCHAR2

1

IS_RELEASED

XXX

VARCHAR2

1

IS_SETTLEMENT_RULE_CREATED

XXX

VARCHAR2

1

IS_SETTLE_RULE_CREATD_MANUALLY

XXX

VARCHAR2

1

IS_TECHNICALLY_COMPLETED

XXX

VARCHAR2

1

IS_WORK_PERMIT_PRINTED

XXX

VARCHAR2

1

WAREHOUSE_LOAD_DATE

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

DATE

WORK_ORDER_SYSTEM_STATUS_KEY

XXX

VARCHAR2

20