KDLV_PACKAGES_INT

This table corresponds to KDLV_PACKAGES (Packages). This table as well as other interface tables will be processed through the java report that calls a PL/SQL package that can be run either from the command line or through the report job scheduler. This allows the user to immediately run the interface but also allow for scheduled processing. The PL/SQL package will query this table, validate against appropriate tables and call the necessary package.

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

KDLV_PACKAGES

PACKAGE_ID

PACKAGE_ID

KNTA_USERS

USER_ID

REQUESTED_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_INTERFACE_ID

NULLABLE

NUMBER

System-generated identifier

GROUP_ID

NULLABLE

NUMBER

This value is used to tie records in the interface tables together. Most of database processing is done based on this value from KNTA_INTERFACE_GROUPS_S.

PROCESS_PHASE

NULLABLE

NUMBER

Indicates which phase a record is at: Pending, Deriving, Validating, Importing or Completed

PROCESS_STATUS

NULLABLE

NUMBER

Indicates the current status of the interface record: Pending, In Process, Errored or Completed

CREATED_BY

NULLABLE

NUMBER

Identifier for the user who created the record

CREATED_BY_USERNAME

NULLABLE

VARCHAR2(200)

Username that creates the record

CREATION_DATE

NULLABLE

DATE

Date record was created

SOURCE_CODE

NULLABLE

VARCHAR2(30)

Used to differentiate interface records by their point of origin

PACKAGE_ID

NULLABLE

NUMBER

Refers to the package_id in KDLV_PACKAGES table

REQUESTED_BY

NULLABLE

NUMBER

ID of the user who requests the record

REQUESTED_BY_USERNAME

NULLABLE

VARCHAR2(200)

Name of the user who requests the record

PACKAGE_NUMBER

NULLABLE

VARCHAR2(40)

Assigned number of the package

ASSIGNED_TO_USER_ID

NULLABLE

NUMBER

ID of the user assigned to this record

ASSIGNED_TO_USERNAME

NULLABLE

VARCHAR2(200)

Username assigned to this record

ASSIGNED_TO_GROUP_ID

NULLABLE

NUMBER

ID of the group assigned to this record

ASSIGNED_TO_GROUP_NAME

NULLABLE

VARCHAR2(30)

Name of the group assigned to this record

DESCRIPTION

NULLABLE

VARCHAR2(400)

Description of the record entered by user

PACKAGE_TYPE_CODE

NULLABLE

VARCHAR2(30)

Type of the package: customization, setup...

PRIORITY_CODE

NULLABLE

VARCHAR2(30)

Priority of the package: low, normal, high or critical

STATUS_CODE

NULLABLE

VARCHAR2(30)

Status of the package

PROJECT_CODE

NULLABLE

VARCHAR2(30)

Project used for this package

WORKFLOW_ID

NULLABLE

NUMBER

ID of the workflow used for this package

WORKFLOW_NAME

NULLABLE

VARCHAR2(80)

Name of the workflow used for this package

PRIORITY_SEQ

NULLABLE

NUMBER

Priority sequence of a package

RELEASE_FLAG

NULLABLE

VARCHAR2(1)

Flag (Y/N) to indicate whether this package is released or not

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(80)

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

NULLABLE

VARCHAR2(1)

Denote whether this Distribution Package is enabled or disabled

DIST_STEP_TRANSACTION_ID

NULLABLE

NUMBER

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

DATA_LANG

NULLABLE

VARCHAR2(40)

Data language

Indexes

Index Name

Index Type

Sequence

Column Name

KDLV_PACKAGES_INT_N1

NONUNIQUE

1

PACKAGE_INTERFACE_ID

KDLV_PACKAGES_INT_N1

NONUNIQUE

2

GROUP_ID

KDLV_PACKAGES_INT_N2

NONUNIQUE

1

GROUP_ID

KDLV_PACKAGES_INT_N3

NONUNIQUE

1

PACKAGE_NUMBER

KDLV_PACKAGES_INT_N4

NONUNIQUE

1

PACKAGE_ID

Sequences

Sequence Name

Sequence Type

KDLV_INTERFACES_S

PACKAGE_INTERFACE_ID

KNTA_INTERFACE_GROUPS_S

GROUP_ID