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 |