KWFL_STEP_TRANSITIONS_INT
This table stores data used for migrating the workflow definition between instances.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KWFL_TRANSACTIONS_INT |
TRANSACTION_ID |
PARENT_TRANSACTION_ID |
KWFL_WORKFLOW_STEPS_NLS |
WORKFLOW_STEP_ID |
DEST_TO_WORKFLOW_STEP_ID |
KWFL_WORKFLOW_STEPS_NLS |
WORKFLOW_STEP_ID |
DEST_FROM_WORKFLOW_STEP_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
TRANSACTION_ID |
NOT NULL |
NUMBER |
System-generated identifier |
PARENT_TRANSACTION_ID |
NOT NULL |
NUMBER |
Transaction ID of the parent table being imported |
GROUP_ID |
NOT NULL |
NUMBER |
This value is used to tie records in the interface tables together. Most of database processing is done based on this value |
EXISTS_FLAG |
NULLABLE |
VARCHAR2(1) |
If set to 'Y' then the record already exists in the database. |
PROCESS_PHASE |
NULLABLE |
NUMBER |
Indicates which phase a record is at: Pending, Deriving, Validating, Importing or Completed |
PROCESS_STATUS |
NULLABLE |
NUMBER |
Indicates the current status of the interface record: Pending, In Process, Errored or Completed |
CREATED_BY_USERNAME |
NULLABLE |
VARCHAR2(200) |
Username that creates the record |
CREATION_DATE |
NULLABLE |
DATE |
Date record was created |
DEST_CREATED_BY |
NULLABLE |
NUMBER |
Identifier for the user who created the record |
DEST_CREATION_DATE |
NULLABLE |
DATE |
Date record was created |
DEST_LAST_UPDATED_BY |
NULLABLE |
NUMBER |
Identifier for the user who last updated the record |
DEST_LAST_UPDATE_DATE |
NULLABLE |
DATE |
Date record was last updated |
STEP_TRANSITION_ID |
NULLABLE |
NUMBER |
Source System-generated identifier |
DEST_STEP_TRANSITION_ID |
NULLABLE |
NUMBER |
Destination System-generated identifier |
TRANSITION_TYPE_CODE |
NULLABLE |
VARCHAR2(30) |
Defined by the lookup type WF_TRANSITION_TYPE. One of the following values: "SPECIFIC_VALUES", "OTHER_VALUES", "ALL_VALUES", "SPECIFIC_ERROR", "OTHER_ERRORS", "ALL_ERRORS". |
OPERATOR_CODE |
NULLABLE |
VARCHAR2(30) |
Defined by the lookup type WF_TRANS_OPERATOR. One of the following "=", "!=". If the validation is a text field with the numeric mask set, or if it is a date field, then the following values are also possible: "<", ">", "<=", ">=". |
RESULT_VALUE |
NULLABLE |
VARCHAR2(200) |
A value that is defined by the validation. |
VISIBLE_RESULT_VALUE |
NULLABLE |
VARCHAR2(200) |
A value that is defined by the validation. This is the value that is shown to the user. |
FROM_WORKFLOW_STEP_ID |
NULLABLE |
NUMBER |
ID of the source workflow step |
FROM_WORKFLOW_STEP_NAME |
NULLABLE |
VARCHAR2(80) |
Name of the source workflow step |
DEST_FROM_WORKFLOW_STEP_ID |
NULLABLE |
NUMBER |
ID of the source workflow step in destination |
TO_WORKFLOW_STEP_ID |
NULLABLE |
NUMBER |
ID of the target workflow step |
TO_WORKFLOW_STEP_NAME |
NULLABLE |
VARCHAR2(80) |
Name of the target workflow step |
DEST_TO_WORKFLOW_STEP_ID |
NULLABLE |
NUMBER |
ID of the target workflow step in destination |
DRAW_LABEL_POS |
NULLABLE |
VARCHAR2(30) |
Relative position of where the label is displayed in the workflow layout. It is a real number between 0.0 and 1.0. |
DRAW_JOINT_COORDS |
NULLABLE |
VARCHAR2(1000) |
A list of coordinates separated by ";". Each coordinate is a pair of integers, separated by a comma. Example: "100,200;300,400" defines two joints at positions (100,200) and (300,400). If NULL, a straight line is drawn from the source to the target step figure. |
SOURCE_TYPE_CODE |
NULLABLE |
VARCHAR2(30) |
For records that have been updated by an interface or migrator, indicates the type of external update (specific interface or migrator name, and so on) |
SOURCE |
NULLABLE |
VARCHAR2(100) |
For records that have been updated by an interface or migrator, provides additional information about the source of the external update |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KWFL_STEP_TRANSITIONS_INT_N1 |
NONUNIQUE |
1 |
TRANSACTION_ID |
KWFL_STEP_TRANSITIONS_INT_N2 |
NONUNIQUE |
1 |
GROUP_ID |
KWFL_STEP_TRANSITIONS_INT_N2 |
NONUNIQUE |
2 |
PROCESS_STATUS |
Sequences
This table uses no sequences.