WORK ORDER USER STATUS Table
View exposing user-defined status reference values used to describe facilities work order processing state.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
IS_CANCELLED |
Indicator identifying whether cancelled (Y/N). |
VARCHAR2 |
1 |
IS_CLOSED |
Indicator identifying whether closed (Y/N). |
VARCHAR2 |
1 |
IS_IN_PROGRESS |
Indicator identifying whether in progress (Y/N). |
VARCHAR2 |
1 |
IS_NEW |
Indicator identifying whether new (Y/N). |
VARCHAR2 |
1 |
IS_OUT_OF_COMMISSION |
Indicator identifying whether out of commission (Y/N). |
VARCHAR2 |
1 |
IS_TRANSFERRED |
Indicator identifying whether transferred (Y/N). |
VARCHAR2 |
1 |
IS_WAITING_FOR_CONTRACTOR |
Indicator identifying whether waiting for contractor (Y/N). |
VARCHAR2 |
1 |
IS_WAITING_FOR_CUSTOMER |
Indicator identifying whether waiting for customer (Y/N). |
VARCHAR2 |
1 |
IS_WAITING_FOR_PARTS |
Indicator identifying whether waiting for parts (Y/N). |
VARCHAR2 |
1 |
IS_WAITING_FOR_SCHEDULE_DATE |
Date associated with is waiting for schedule. |
VARCHAR2 |
1 |
IS_WAITING_TO_BE_ASSIGNED |
Indicator identifying whether waiting to be assigned (Y/N). |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WORK_ORDER_USER_STATUS_KEY |
Surrogate key identifying the work order user status. |
VARCHAR2 |
20 |