Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: