KWFL_WORKFLOW_INSTANCES
This table stores header information for a workflow instance. A workflow instance essentially defines a copy of a workflow that transactions are executed against. Each request has its own workflow instance, for example, as does each package line.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KNTA_USERS |
USER_ID |
CREATED_BY |
KNTA_REPORT_SUBMISSIONS |
REPORT_SUBMISSION_ID |
INSTANCE_SOURCE_ID |
KCRT_REQUESTS |
REQUEST_ID |
INSTANCE_SOURCE_ID |
KREL_DISTRIBUTIONS |
DISTRIBUTION_ID |
INSTANCE_SOURCE_ID |
KWFL_STEP_TRANSACTIONS |
STEP_TRANSACTION_ID |
INSTANCE_SOURCE_ID |
KREL_DISTRIBUTIONS |
DISTRIBUTION_ID |
TOP_INSTANCE_SOURCE_SET_ID |
KDLV_PACKAGE_LINES |
PACKAGE_LINE_ID |
TOP_INSTANCE_SOURCE_ID |
KNTA_REPORT_SUBMISSIONS |
REPORT_SUBMISSION_ID |
TOP_INSTANCE_SOURCE_ID |
KDLV_PACKAGES |
PACKAGE_ID |
TOP_INSTANCE_SOURCE_SET_ID |
KWFL_STEP_TRANSACTIONS |
STEP_TRANSACTION_ID |
INSTANCE_SOURCE_SET_ID |
KREL_DISTRIBUTIONS |
DISTRIBUTION_ID |
TOP_INSTANCE_SOURCE_ID |
KCRT_REQUESTS |
REQUEST_ID |
TOP_INSTANCE_SOURCE_ID |
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
KDLV_PACKAGE_LINES |
PACKAGE_LINE_ID |
INSTANCE_SOURCE_ID |
KNTA_REPORT_SUBMISSIONS |
REPORT_SUBMISSION_ID |
TOP_INSTANCE_SOURCE_SET_ID |
KCRT_REQUESTS |
REQUEST_ID |
TOP_INSTANCE_SOURCE_SET_ID |
KNTA_REPORT_SUBMISSIONS |
REPORT_SUBMISSION_ID |
INSTANCE_SOURCE_SET_ID |
KCRT_REQUESTS |
REQUEST_ID |
INSTANCE_SOURCE_SET_ID |
KREL_DISTRIBUTIONS |
DISTRIBUTION_ID |
INSTANCE_SOURCE_SET_ID |
KDLV_PACKAGES |
PACKAGE_ID |
INSTANCE_SOURCE_SET_ID |
KWFL_WORKFLOWS_NLS |
WORKFLOW_ID |
WORKFLOW_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
WORKFLOW_INSTANCE_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_ID |
NOT NULL |
NUMBER |
ID of the workflow that serves as the reference for this instance |
INSTANCE_SOURCE_SET_ID |
NOT NULL |
NUMBER |
This denormalized column identifies the ID of the entity to which this step transaction belongs. This is a foreign key into KDLV_PACKAGES, KREL_DISTRIBUTIONS, KCRT_REQUESTS, KNTA_REPORT_SUBMISSIONS, or KWFL_STEP_TRANSACTIONS. |
INSTANCE_SOURCE_TYPE_CODE |
NOT NULL |
VARCHAR2(30) |
This denormalized column identifies whether the type of the entity using the workflow. Choices are "CR", "DIST", "IR", "REPORT", and "WORKFLOW" as specified by the lookup WF_INSTANCE_SOURCE_TYPE. |
INSTANCE_SOURCE_ID |
NOT NULL |
NUMBER |
This denormalized column identifies the ID of the detail entity using the workflow. In the case of "IR", "DIST", "PI", "REPORT" and "WORKFLOW", the value in this column is identical to that in INSTANCE_SOURCE_SET_ID. |
TOP_INSTANCE_SOURCE_TYPE_CODE |
NOT NULL |
VARCHAR2(30) |
This denormalized column identifies whether the type of the entity using the Top-Level workflow (Non-Subworkflow). Choices are "CR", "DIST", "IR", and "REPORT". |
TOP_INSTANCE_SOURCE_SET_ID |
NOT NULL |
NUMBER |
This denormalized column identifies the ID of the detail entity using the Top-Level workflow (Non-Subworkflow). This is a foreign key into KDLV_PACKAGES, KREL_DISTRIBUTIONS, KCRT_REQUESTS, KNTA_REPORT_SUBMISSIONS. |
TOP_INSTANCE_SOURCE_ID |
NOT NULL |
NUMBER |
This denormalized column identifies the ID of the detail entity using the Top-Level workflow (Non-Subworkflow). In the case of "IR", "DIST", "PI" and "REPORT", the value in this column is identical to that in TOP_INSTANCE_SOURCE_SET_ID. |
INSTANCE_NAME |
NULLABLE |
VARCHAR2(30) |
Not currently used |
STATUS |
NULLABLE |
VARCHAR2(30) |
Current status of the entity within the workflow instance |
COMPLETION_DATE |
NULLABLE |
DATE |
Timestamp on which a close step was reached in the workflow instance |
CURRENT_FLAG |
NOT NULL |
VARCHAR2(1) |
Indicates whether the workflow instance matches the current workflow definition |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KWFL_WORKFLOW_INSTANCES_N1 |
NONUNIQUE |
1 |
INSTANCE_SOURCE_SET_ID |
KWFL_WORKFLOW_INSTANCES_N1 |
NONUNIQUE |
2 |
INSTANCE_SOURCE_TYPE_CODE |
KWFL_WORKFLOW_INSTANCES_N1 |
NONUNIQUE |
3 |
INSTANCE_SOURCE_ID |
KWFL_WORKFLOW_INSTANCES_N2 |
NONUNIQUE |
1 |
WORKFLOW_ID |
KWFL_WORKFLOW_INSTANCES_N3 |
NONUNIQUE |
1 |
INSTANCE_SOURCE_ID |
KWFL_WORKFLOW_INSTANCES_N3 |
NONUNIQUE |
2 |
INSTANCE_SOURCE_TYPE_CODE |
KWFL_WORKFLOW_INSTANCES_N4 |
NONUNIQUE |
1 |
COMPLETION_DATE |
KWFL_WORKFLOW_INSTANCES_N5 |
NONUNIQUE |
1 |
TOP_INSTANCE_SOURCE_SET_ID |
KWFL_WORKFLOW_INSTANCES_N5 |
NONUNIQUE |
2 |
TOP_INSTANCE_SOURCE_TYPE_CODE |
KWFL_WORKFLOW_INSTANCES_N5 |
NONUNIQUE |
3 |
TOP_INSTANCE_SOURCE_ID |
KWFL_WORKFLOW_INSTANCES_N6 |
NONUNIQUE |
1 |
TOP_INSTANCE_SOURCE_TYPE_CODE |
KWFL_WORKFLOW_INSTANCES_N6 |
NONUNIQUE |
2 |
TOP_INSTANCE_SOURCE_ID |
KWFL_WORKFLOW_INSTANCES_U1 |
UNIQUE |
1 |
WORKFLOW_INSTANCE_ID |
Sequences
Sequence Name |
Sequence Type |
---|---|
KWFL_WORKFLOW_INSTANCES_S |
WORKFLOW_INSTANCE_ID |