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