KDLV_PACKAGES

This table stores all of the header information for each Package defined in Deliver.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_SECURITY_GROUPS_NLS

SECURITY_GROUP_ID

ASSIGNED_TO_GROUP_ID

KNTA_USERS

USER_ID

ASSIGNED_TO_USER_ID

KNTA_USERS

USER_ID

CREATED_BY

KWFL_STEP_TRANSACTIONS

STEP_TRANSACTION_ID

PARENT_STEP_TRANSACTION_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_PARAMETER_SET_CONTEXTS

PARAMETER_SET_CONTEXT_ID

USER_DATA_SET_CONTEXT_ID

KWFL_WORKFLOWS_NLS

WORKFLOW_ID

WORKFLOW_ID

Column Descriptions

Column Name

Null?

Data Type

Description

PACKAGE_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

ENTITY_LAST_UPDATE_DATE

NOT NULL

DATE

Date a record in the entity was last updated

PACKAGE_NUMBER

NOT NULL

VARCHAR2(40)

User-defined Package number for the Package

ASSIGNED_TO_USER_ID

NULLABLE

NUMBER

ID of the user to which this Package is assigned to

ASSIGNED_TO_GROUP_ID

NULLABLE

NUMBER

ID of the group to which this Package is assigned to

DESCRIPTION

NULLABLE

VARCHAR2(400)

Short description of the Package

RELEASE_DATE

NULLABLE

DATE

Date Package is released (sets status to in-progress)

PRIORITY_CODE

NULLABLE

VARCHAR2(30)

Lookup code for 'REQUEST_PRIORITY'

PRIORITY_SEQ

NULLABLE

NUMBER

Tasks with smaller priority sequence are run earlier

STATUS_CODE

NOT NULL

VARCHAR2(30)

Lookup code for 'REQUEST_STATUS'

PROJECT_CODE

NULLABLE

VARCHAR2(30)

Project that this Package belongs to

WORKFLOW_ID

NULLABLE

NUMBER

Workflow being used to route this Package

PARENT_STEP_TRANSACTION_ID

NULLABLE

NUMBER

Reference ID of parent Request

PACKAGE_TYPE_CODE

NULLABLE

VARCHAR2(30)

Lookup code for 'REQUEST_TYPE'

USER_DATA_SET_CONTEXT_ID

NULLABLE

NUMBER

Parameter set context identifier for the user data fields

USER_DATA1-20

NULLABLE

VARCHAR2(200)

User data segment

VISIBLE_USER_DATA1-20

NULLABLE

VARCHAR2(200)

User data segment

SOURCE_PACKAGE_ID

NULLABLE

NUMBER

Identifier of the original Package for this Distribution placeholder Package

DISTPKG_STATUS_MEANING

NULLABLE

VARCHAR2(200)

Displayed status of this Distribution Package

RUN_GROUP

NULLABLE

NUMBER

Run group number of this Distribution Package

DISTRIBUTION_ID

NULLABLE

NUMBER

Identifier of the Distribution that this Package belongs to

ENABLED_FLAG

NOT NULL

VARCHAR2(1)

Denote whether this Distribution Package is enabled or disabled

DIST_STEP_TRANSACTION_ID

NULLABLE

NUMBER

Identifier for the Package-level subworkflow step transaction of the Distribution that this Package belongs to

DIST_WORKFLOW_STEP_ID_PATH

NULLABLE

VARCHAR2(200)

Path of the Distribution Workflow Step that was executed in the transaction with DIST_STEP_TRANSACTION_ID

PERCENT_COMPLETE

NOT NULL

NUMBER

Percent complete of this Package (100 if the Package is closed)

Indexes

Index Name

Index Type

Sequence

Column Name

KDLV_PACKAGES_N1

NONUNIQUE

1

ASSIGNED_TO_USER_ID

KDLV_PACKAGES_N11

NONUNIQUE

1

DISTRIBUTION_ID

KDLV_PACKAGES_N11

NONUNIQUE

2

DIST_WORKFLOW_STEP_ID_PATH

KDLV_PACKAGES_N12

NONUNIQUE

1

SOURCE_PACKAGE_ID

KDLV_PACKAGES_N2

NONUNIQUE

1

CREATED_BY

KDLV_PACKAGES_N3

NONUNIQUE

1

ASSIGNED_TO_GROUP_ID

KDLV_PACKAGES_N4

NONUNIQUE

1

WORKFLOW_ID

KDLV_PACKAGES_N5

NONUNIQUE

1

CREATION_DATE

KDLV_PACKAGES_N6

NONUNIQUE

1

PACKAGE_NUMBER

KDLV_PACKAGES_N7

NONUNIQUE

1

PROJECT_CODE

KDLV_PACKAGES_N8

NONUNIQUE

1

STATUS_CODE

KDLV_PACKAGES_N9

NONUNIQUE

1

RELEASE_DATE

KDLV_PACKAGES_U1

UNIQUE

1

PACKAGE_ID

Sequences

Sequence Name

Sequence Type

KDLV_PACKAGES_S

PACKAGE_ID