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 |