Share this page

# KDLV_PACKAGE_NOTES_INT

This table corresponds to the KNTA_NOTES (Notes for a Package) table. 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. PL/SQL package will query this table, validate against appropriate tables.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KDLV_PACKAGES | PACKAGE_ID | PACKAGE_ID
KDLV_PACKAGES_INT | PACKAGE_INTERFACE_ID | PACKAGE_INTERFACE_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
PACKAGE_NOTE_INTERFACE_ID | NULLABLE | NUMBER | System-generated identifier
GROUP_ID | NULLABLE | NUMBER | Common column among interface tables. This value is used to tie records in the interface tables together. Most of database processing is done based on this value
PACKAGE_INTERFACE_ID | NULLABLE | NUMBER | ID of a package
PACKAGE_ID | NULLABLE | NUMBER | If not null, used to validate against the package_id in KDLV_PACKAGES
PACKAGE_NUMBER | NULLABLE | VARCHAR2(40) | If not null, used to validate against the package_number in KDLV_PACKAGES
PROCESS_PHASE | NULLABLE | NUMBER | Common column among interface tables. Used to determine which phase a record is at: Pending, Deriving, Validating, Importing or Completed
PROCESS_STATUS | NULLABLE | NUMBER | Common column among interface tables. Used to determine 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 created this record
CREATION_DATE | NULLABLE | DATE | Date record was created
SOURCE_CODE | NULLABLE | VARCHAR2(30) | Common column among interface tables. Used to differentiate interface records by their point of origin
NOTE | NULLABLE | CLOB | Note for a particular package
REPLACE_NOTE_FLAG | NULLABLE | VARCHAR2(1) | Whether or not to replace the existing note

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KDLV_PACKAGE_NOTES_INT_N1 | NONUNIQUE | 1 | PACKAGE_NOTE_INTERFACE_ID
KDLV_PACKAGE_NOTES_INT_N1 | NONUNIQUE | 2 | GROUP_ID
KDLV_PACKAGE_NOTES_INT_N2 | NONUNIQUE | 1 | GROUP_ID
KDLV_PACKAGE_NOTES_INT_N2 | NONUNIQUE | 2 | PACKAGE_INTERFACE_ID
KDLV_PACKAGE_NOTES_INT_N3 | NONUNIQUE | 1 | PACKAGE_NUMBER

## Sequences

Sequence Name | Sequence Type
--- | ---
KDLV_INTERFACES_S | PACKAGE_NOTE_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: