Share this page
KWFL_WORKFLOW_STEPS_TEMP
This is a temporary table that stores information about workflow steps (especially copy/move).
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
|
KWFL_WORKFLOW_STEPS_NLS |
WORKFLOW_STEP_ID |
STEP_TYPE_CODE |
|
KWFL_WORKFLOW_STEPS_NLS |
WORKFLOW_STEP_ID |
OLD_STEP_SOURCE_ID |
|
KNTA_USERS |
USER_ID |
CREATED_BY |
|
KWFL_WORKFLOW_STEPS_NLS |
WORKFLOW_STEP_ID |
NEW_STEP_SOURCE_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
GROUP_ID |
NOT NULL |
NUMBER |
System-generated identifier |
|
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
|
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
|
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
|
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
|
STEP_TYPE_CODE |
NOT NULL |
VARCHAR2(30) |
Unique identifier that identifies the type of workflow step |
|
OLD_STEP_SOURCE_ID |
NOT NULL |
NUMBER |
Identifier that uniquely identifies the source workflow step |
|
NEW_STEP_SOURCE_ID |
NOT NULL |
NUMBER |
Identifier that uniquely identifies the destination workflow step |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
KWFL_WORKFLOW_STEPS_TEMP_U1 |
UNIQUE |
1 |
GROUP_ID |
|
KWFL_WORKFLOW_STEPS_TEMP_U1 |
UNIQUE |
2 |
STEP_TYPE_CODE |
|
KWFL_WORKFLOW_STEPS_TEMP_U1 |
UNIQUE |
3 |
OLD_STEP_SOURCE_ID |
|
KWFL_WORKFLOW_STEPS_TEMP_U1 |
UNIQUE |
4 |
NEW_STEP_SOURCE_ID |
Sequences
This table uses no sequences.
