KDLV_WORKFLOW_EXTN

This table stores additional information for Deployment Management Packages. This information is configured through Workflow. The information stored here relates to Participant Restrictions and Key Fields Segmentation.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KWFL_WORKFLOWS_NLS

WORKFLOW_ID

WORKFLOW_ID

Column Descriptions

Column Name

Null?

Data Type

Description

WORKFLOW_EXTN_ID

NOT NULL

NUMBER

System-generated identifier

CREATION_DATE

NOT NULL

DATE

Date record was created

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

WORKFLOW_ID

NOT NULL

NUMBER

Identifier for Workflow ID

RESTRICTION_CODE

NOT NULL

VARCHAR2(30)

Code that specifies whether the Workflow security is restricted to a particular group(s)

ASSIGNED_TO_FILTER_CODE

NOT NULL

VARCHAR2(30)

Code that specifies what the Workflow Assigned To filter is set to

ASSIGNED_GRP_FILTER_CODE

NOT NULL

VARCHAR2(30)

Code that specifies what the Workflow Assigned To Group filter is set to

SOURCE_TYPE_CODE

NULLABLE

VARCHAR2(30)

Used to differentiate interface records by their point of origin.

SOURCE

NULLABLE

VARCHAR2(100)

Denotes the external source of the workflow

AUDIT_FLAG

NOT NULL

VARCHAR2(1)

If Y, audit changes

Indexes

Index Name

Index Type

Sequence

Column Name

KDLV_WORKFLOW_EXTN_U1

UNIQUE

1

WORKFLOW_EXTN_ID

KDLV_WORKFLOW_EXTN_U2

UNIQUE

1

WORKFLOW_ID

Sequences

Sequence Name

Sequence Type

KDLV_WORKFLOW_EXTN_S

WORKFLOW_EXTN_ID