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_PACAKGES, 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