KWFL_TRANSACTIONS_INT

This table is used when you are migrating a Workflow from one instance to another.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KWFL_STEP_TRANSACTIONS

STEP_TRANSACTION_ID

CURRENT_STEP_TRANSACTION_ID

KNTA_USERS

USER_ID

DELEGATED_TO_USER_ID

KCRT_REQUESTS

REQUEST_ID

INSTANCE_SOURCE_ID

KDLV_PACKAGE_LINES

PACKAGE_LINE_ID

INSTANCE_SOURCE_ID

KCRT_REQUESTS

REQUEST_ID

INSTANCE_SOURCE_SET_ID

KDLV_PACKAGES

PACKAGE_ID

INSTANCE_SOURCE_SET_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KWFL_WORKFLOWS_NLS

WORKFLOW_STEP_ID

TO_WORKFLOW_STEP_ID

KWFL_WORKFLOWS_NLS

WORKFLOW_ID

WORKFLOW_ID

KWFL_WORKFLOW_INSTANCES

WORKFLOW_INSTANCE_ID

WORKFLOW_INSTANCE_ID

KWFL_WORKFLOW_INSTANCE_STEPS

WORKFLOW_INSTANCE_STEP_ID

WORKFLOW_INSTANCE_STEP_ID

KWFL_WORKFLOW_STEPS_NLS

WORKFLOW_STEP_ID

WORKFLOW_STEP_ID

Column Descriptions

Column Name

Null?

Data Type

Description

TRANSACTION_ID

NOT NULL

NUMBER

System-generated identifier

CREATION_DATE

NULLABLE

DATE

Date record was created

CREATED_USERNAME

NOT NULL

VARCHAR2(200)

User that created the record

CREATED_BY

NULLABLE

NUMBER

Identifier for the user who created the record

LAST_UPDATE_DATE

NULLABLE

DATE

Date record was last updated

LAST_UPDATED_USERNAME

NOT NULL

VARCHAR2(200)

User that last updated the record

LAST_UPDATED_BY

NULLABLE

NUMBER

Identifier for the user who last updated the record

EVENT

NOT NULL

VARCHAR2(40)

Identifies the transaction that the record is indented to perform

GROUP_ID

NULLABLE

NUMBER

Typical use is that a group_id is returned to the caller of run_interface procedure. This can be used to re-submit the records.

WORKFLOW_ENGINE_BATCH_ID

NULLABLE

NUMBER

Internal use only

PROCESS_PHASE

NOT NULL

NUMBER

Internal use only

PROCESS_STATUS

NOT NULL

NUMBER

Describes the current status of the record. For example, In Progress and Error.

SOURCE_TYPE_CODE

NULLABLE

VARCHAR2(30)

Internal use only

SOURCE

NULLABLE

VARCHAR2(100)

A alpha-numeric string can be provided to indicate a group of records that need to be processed.

INSTANCE_SOURCE_TYPE_CODE

NULLABLE

VARCHAR2(30)

Describes the product that the interface is invoked on. Typically internal use only.

INSTANCE_SOURCE_SET_NUMBER

NULLABLE

VARCHAR2(40)

Describes the source set number. For example, request number and package number.

INSTANCE_SOURCE_SET_ID

NULLABLE

NUMBER

Identifier for the source set. For example, request ID and package ID.

INSTANCE_SOURCE_LINE_SEQ

NULLABLE

NUMBER

Line sequence number for the package lines

INSTANCE_SOURCE_ID

NULLABLE

NUMBER

Identifier for the source line such as package line ID.

WORKFLOW_STEP_NAME

NULLABLE

VARCHAR2(80)

Step name of the workflow that needs to be processed.

WORKFLOW_STEP_SEQ

NULLABLE

VARCHAR2(30)

Step sequence of the workflow that needs to be processed.

RESULT_VALUE

NULLABLE

VARCHAR2(200)

Hidden result value of the workflow transaction that user is initiating.

VISIBLE_RESULT_VALUE

NULLABLE

VARCHAR2(200)

Visible result value of the workflow transaction that user is initiating.

USER_COMMENTS

NULLABLE

VARCHAR2(200)

Comments that the user wants to attach to the notes field while processing the transaction.

DELEGATED_TO_USERNAME

NULLABLE

VARCHAR2(200)

Describes the user name who this step needs to be delegated (In case the transaction is a delegation)

DELEGATED_TO_USER_ID

NULLABLE

NUMBER

Describes the user ID who this step needs to be delegated (In case the transaction is a delegation)

SCHEDULE_DATE

NULLABLE

DATE

While scheduling a task, this field will specify the date/time the task should start.

WORKFLOW_ID

NULLABLE

NUMBER

Internal use only

WORKFLOW_INSTANCE_ID

NULLABLE

NUMBER

Internal use only

WORKFLOW_STEP_ID

NULLABLE

NUMBER

Identifier of the workflow step that needs to be processed.

WORKFLOW_INSTANCE_STEP_ID

NULLABLE

NUMBER

Internal use only

CURRENT_STEP_TRANSACTION_ID

NULLABLE

NUMBER

Internal use only

APPROVALS_REQUIRED_CODE

NULLABLE

VARCHAR2(30)

Internal use only

EVENT_GROUP_ID

NULLABLE

NUMBER

Internal use only

CMD_EXECUTION_SCHD_TASK_ID

NULLABLE

NUMBER

Internal use only

TO_WORKFLOW_STEP_SEQ

NULLABLE

VARCHAR2(30)

In case of force transition event, this describes the workflow step sequence to transition to.

TO_WORKFLOW_STEP_NAME

NULLABLE

VARCHAR2(80)

In case of force transition event, this describes the workflow step name to transition to.

TO_WORKFLOW_STEP_ID

NULLABLE

NUMBER

In case of force transition event, this describes the workflow ID sequence to transition to.

DATA_LANG

NULLABLE

VARCHAR2(40)

Internal use only

Indexes

Index Name

Index Type

Sequence

Column Name

KWFL_TRANSACTIONS_INT_N1

NONUNIQUE

1

CMD_EXECUTION_SCHD_TASK_ID

KWFL_TRANSACTIONS_INT_N1

NONUNIQUE

2

PROCESS_STATUS

KWFL_TRANSACTIONS_INT_N2

NONUNIQUE

1

GROUP_ID

KWFL_TRANSACTIONS_INT_N2

NONUNIQUE

2

PROCESS_PHASE

KWFL_TRANSACTIONS_INT_N2

NONUNIQUE

3

PROCESS_STATUS

KWFL_TRANSACTIONS_INT_N2

NONUNIQUE

4

EVENT

KWFL_TRANSACTIONS_INT_N3

NONUNIQUE

1

WORKFLOW_ENGINE_BATCH_ID

KWFL_TRANSACTIONS_INT_U1

UNIQUE

1

TRANSACTION_ID

Sequences

This table uses no sequences.