KWFL_VERIFICATION_TEMP

This table stores the list of errors and warnings generated during the Verify Workflow process.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KWFL_STEP_TRANSITIONS_NLS

STEP_TRANSITION_ID

STEP_TRANSITION_ID

KWFL_WORKFLOW_STEPS_NLS

WORKFLOW_STEP_ID

WORKFLOW_STEP_ID

Column Descriptions

Column Name

Null?

Data Type

Description

WORKFLOW_ID

NOT NULL

NUMBER

Unique identifier for the workflow being verified

ERROR_TYPE_CODE

NOT NULL

VARCHAR2(30)

One of "Error" or "Warning"

ERROR_CATEGORY_CODE

NOT NULL

VARCHAR2(30)

One of "WORKFLOW", "STEP", or "TRANSITION"

WORKFLOW_STEP_ID

NULLABLE

NUMBER

Relevant only when ERROR_CATEGORY_CODE == "STEP"

STEP_TRANSITION_ID

NULLABLE

NUMBER

Relevant only when ERROR_CATEGORY_CODE == "TRANSITION"

ERROR

NULLABLE

VARCHAR2(200)

Error message

Indexes

Index Name

Index Type

Sequence

Column Name

KWFL_VERIFICATION_TEMP_N1

NONUNIQUE

1

WORKFLOW_ID

Sequences

This table uses no sequences.