WORK ORDER SYSTEM STATUS Table
View exposing system status reference values used to describe facilities work order processing state.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
IS_CLOSED |
Indicator identifying whether closed (Y/N). |
VARCHAR2 |
1 |
IS_CONFIRMED |
Indicator identifying whether confirmed (Y/N). |
VARCHAR2 |
1 |
IS_CREATED |
Indicator identifying whether created (Y/N). |
VARCHAR2 |
1 |
IS_DELETION_FLAG_SET |
Indicator identifying whether deletion flag set (Y/N). |
VARCHAR2 |
1 |
IS_DELETION_INDICATOR_SET |
Indicator identifying whether deletion indicator set (Y/N). |
VARCHAR2 |
1 |
IS_FRM_CREATD_TO_TECH_COMPLETD |
Indicator identifying whether frm creatd to tech completd (Y/N). |
VARCHAR2 |
1 |
IS_NOT_COMPLETED |
Indicator identifying whether not completed (Y/N). |
VARCHAR2 |
1 |
IS_PARTIALLY_CONFIRMED |
Indicator identifying whether partially confirmed (Y/N). |
VARCHAR2 |
1 |
IS_PRINTED |
Indicator identifying whether printed (Y/N). |
VARCHAR2 |
1 |
IS_RELEASED |
Indicator identifying whether released (Y/N). |
VARCHAR2 |
1 |
IS_SETTLEMENT_RULE_CREATED |
Indicator identifying whether settlement rule created (Y/N). |
VARCHAR2 |
1 |
IS_SETTLE_RULE_CREATD_MANUALLY |
Indicator identifying whether settle rule creatd manually (Y/N). |
VARCHAR2 |
1 |
IS_TECHNICALLY_COMPLETED |
Indicator identifying whether technically completed (Y/N). |
VARCHAR2 |
1 |
IS_WORK_PERMIT_PRINTED |
Indicator identifying whether work permit printed (Y/N). |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WORK_ORDER_SYSTEM_STATUS_KEY |
Surrogate key identifying the work order system status. |
VARCHAR2 |
20 |