Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: