ZCH_PROCESS_TAGS
This table stores the process step data which will be moved to either conflict table or history table once the process is failed or completed.
Details
-
Schema: FUSION
-
Object owner: ZCH
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
Name | Datatype | Length | Precision | Comments |
---|---|---|---|---|
AREA_LOCATION | VARCHAR2 | 250 | Area in which tag applies | |
AREA_TYPE | VARCHAR2 | 15 | Type of area | |
AREA_USAGE | VARCHAR2 | 250 | Usage of area during processing | |
CONTENT_BINARY | BLOB | Binary content being tagged | ||
CONTENT_XML | XMLTYPE | XML content being tagged | ||
CONTENT_TYPE | VARCHAR2 | 250 | Type of content | |
CONTENT_LOCATION | VARCHAR2 | 1024 | Location of content being tagged. | |
CONTENT_TEXT | CLOB | Text content being tagged. | ||
POSITION_ID | NUMBER | 18 | Data instance where tag was applied | |
POSITION_ID2 | NUMBER | 18 | Store the data instance numeric key where tag was applied. It is added for possible composite numeric key for a data instance. | |
POSITION_ID3 | NUMBER | 18 | Store the data instance numeric key where tag was applied. It is added for possible composite numeric key for a data instance. | |
POSITION_ID4 | NUMBER | 18 | Store the data instance numeric key where tag was applied. It is added for possible composite numeric key for a data instance. | |
POSITION_ID5 | NUMBER | 18 | Store the data instance numeric key where tag was applied. It is added for possible composite numeric key for a data instance. | |
POSITION_KEY_1 | VARCHAR2 | 250 | Data instance key value | |
POSITION_KEY_2 | VARCHAR2 | 250 | Data instance key value | |
POSITION_KEY_3 | VARCHAR2 | 250 | Data instance key value | |
POSITION_KEY_4 | VARCHAR2 | 250 | Data instance key value | |
POSITION_KEY_5 | VARCHAR2 | 250 | Data instance key value | |
POSITION_SEQUENCE | NUMBER | 9 | Data instance version number. | |
PROCESS_SEQUENCE | NUMBER | 9 | Process instance version number. | |
PROCESS_ID | NUMBER | 18 | Process instance where tag was applied | |
PROCESS_ID2 | NUMBER | 18 | Store the process instance numeric key where tag was applied. It is added for possible composite numeric key for a process instance. | |
PROCESS_ID3 | NUMBER | 18 | Store the process instance numeric key where tag was applied. It is added for possible composite numeric key for a process instance. | |
PROCESS_ID4 | NUMBER | 18 | Store the process instance numeric key where tag was applied. It is added for possible composite numeric key for a process instance. | |
PROCESS_ID5 | NUMBER | 18 | Store the process instance numeric key where tag was applied. It is added for possible composite numeric key for a process instance. | |
PROCESS_KEY_1 | VARCHAR2 | 250 | Process instance key value | |
PROCESS_KEY_2 | VARCHAR2 | 250 | Process instance key value | |
PROCESS_KEY_3 | VARCHAR2 | 250 | Process instance key value | |
PROCESS_KEY_4 | VARCHAR2 | 250 | Process instance key value | |
PROCESS_KEY_5 | VARCHAR2 | 250 | Process instance key value | |
SITE_LOCATION | VARCHAR2 | 250 | Site at which tag applies | |
SITE_TYPE | VARCHAR2 | 15 | Type of site | |
SITE_USAGE | VARCHAR2 | 250 | Usage of site during processing | |
TAG_SEQUENCE | NUMBER | 18 | Sequence of applied tags | |
TAG_SOURCE | VARCHAR2 | 250 | Source of tag | |
TAG_TIME | TIMESTAMP | Time when tag was applied | ||
TAG_TYPE | VARCHAR2 | 15 | Type of tag | |
TAG_USAGE | VARCHAR2 | 250 | Usage of tag during processing | |
TRANSITION_SEQUENCE | NUMBER | 18 | Transition in which tag was applied | |
TRANSITION_TYPE | VARCHAR2 | 15 | Type of transition | |
VALUE_DATE | DATE | Date being tagged | ||
VALUE_DATE_TIME | TIMESTAMP | Date and time being tagged | ||
VALUE_DECIMAL | NUMBER | Decimal number being tagged | ||
VALUE_INT | NUMBER | 9 | Integer number being tagged | |
VALUE_LONG | NUMBER | 18 | Long integer number being tagged | |
VALUE_REF_CODE | VARCHAR2 | 30 | Type being tagged | |
VALUE_REF_ID | NUMBER | 18 | Instance being tagged | |
VALUE_REF_KEY_1 | VARCHAR2 | 250 | Instance key value | |
VALUE_REF_KEY_2 | VARCHAR2 | 250 | Instance key value | |
VALUE_REF_KEY_3 | VARCHAR2 | 250 | Instance key value | |
VALUE_REF_KEY_4 | VARCHAR2 | 250 | Instance key value | |
VALUE_REF_KEY_5 | VARCHAR2 | 250 | Instance key value | |
VALUE_REF_LOCATION | VARCHAR2 | 250 | Location being tagged | |
VALUE_REF_SEQUENCE | NUMBER | 9 | Instance version number. | |
VALUE_STRING | VARCHAR2 | 1000 | String literal being tagged | |
VALUE_SEQUENCE | NUMBER | 9 | Sequence of tagged values | |
VALUE_TYPE | VARCHAR2 | 250 | Type of value | |
VALUE_REF_ID2 | NUMBER | 18 | Store the instance numeric key of the tag value. It is added for possible composite numeric key for an instance. | |
VALUE_REF_ID3 | NUMBER | 18 | Store the instance numeric key of the tag value. It is added for possible composite numeric key for an instance. | |
VALUE_REF_ID4 | NUMBER | 18 | Store the instance numeric key of the tag value. It is added for possible composite numeric key for an instance. | |
VALUE_REF_ID5 | NUMBER | 18 | Store the instance numeric key of the tag value. It is added for possible composite numeric key for an instance. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
ZCH_PROCESS_TAGS_N1 | Non Unique | Default | PROCESS_ID, AREA_LOCATION |
ZCH_PROCESS_TAGS_N2 | Non Unique | Default | SITE_LOCATION, POSITION_ID |