KWFL_WORKFLOW_INSTANCE_PARMS
This table stores the actual values for each parameter defined for a given workflow instance. The parameter names are defined at the workflow level, but each workflow instance can have its own set of values for these parameters.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KNTA_USERS |
USER_ID |
CREATED_BY |
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
KWFL_WORKFLOW_INSTANCES |
WORKFLOW_INSTANCE_ID |
WORKFLOW_INSTANCE_ID |
KWFL_WORKFLOW_PARAMETERS_NLS |
WORKFLOW_PARAMETER_ID |
WORKFLOW_PARAMETER_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
INSTANCE_PARAMETER_ID |
NOT NULL |
NUMBER |
System-generated identifier |
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
WORKFLOW_INSTANCE_ID |
NOT NULL |
NUMBER |
References the originating workflow instance for this instance step |
WORKFLOW_PARAMETER_ID |
NULLABLE |
NUMBER |
References the parameter in the workflow definition for this instance |
PARAMETER_VALUE |
NULLABLE |
VARCHAR2(200) |
Contains the actual value defined for the workflow instance parameter (this is the code, or ID, portion of the value) |
VISIBLE_PARAMETER_VALUE |
NULLABLE |
VARCHAR2(200) |
Contains the visible value defined for the workflow instance parameter |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KWFL_WORKFLOW_INSTANCE_PARM_N1 |
NONUNIQUE |
1 |
WORKFLOW_INSTANCE_ID |
KWFL_WORKFLOW_INSTANCE_PARM_U1 |
UNIQUE |
1 |
INSTANCE_PARAMETER_ID |
Sequences
Sequence Name |
Sequence Type |
---|---|
KWFL_WORKFLOW_INSTANCE_PARMS_S |
INSTANCE_PARAMETER_ID |