Share this page

# KDLV_PACKAGE_NOTES_INT

The KDLV_PACKAGE_NOTES_INT interface table defines the notes attached to the new package. It can only be used when importing a new package and cannot be used to update the notes of an existing package.

Table A-23. KDLV_PACKAGE_NOTES_INT interface table
Column | Usage | Data Type | Description
--- | --- | --- | ---
PACKAGE_NOTE_INTERFACE_ID | I/O | NUMBER | Provides a unique identifier for the record. If left blank, the value is derived from the KDLV_INTERFACES_S sequence.
GROUP_ID | I | NUMBER | Groups all the records that should be processed at the same time. Use only one GROUP_ID each time you run a report. Derived from the KNTA_INTERFACE_GROUPS_S sequence.
PACKAGE_INTERFACE_ID | I | NUMBER | Provides a unique identifier for the each record. Derived from the KDLV_INTERFACES_S sequence. This is required if package lines exist. For new lines, this should be left blank. For lines tied to a new package, this can be used to tie the line record to the parent record in KDLV_PACKAGES_INT. The PACKAGE_NUMBER and PACKAGE_ID columns can be used for this tie as well.
PACKAGE_ID | I | NUMBER | Provides an identifier for a package and makes the association between the package and note. Derived from the KDLV_PACKAGES_S sequence. Identifies the package ID. This can be used to tie the note record to the parent record in KDLV_PACKAGES_INT. Either PACKAGE_INTERFACE_ID and PACKAGE_NUMBER can be used to tie the records.
PACKAGE_NUMBER | I | VARCHAR2 | Identifies the package number. This must use either the same value as PACKAGE_ID or a unique string. This can be used to tie the note record to the parent record in KDLV_PACKAGES_INT. The PACKAGE_INTERFACE_ID and PACKAGE_ID can be used for this tie as well.
PROCESS_PHASE | O | NUMBER | Indicates the current stage of the record as it is being processed. See Process State Information for details.
PROCESS_STATUS | O | NUMBER | Indicates the current disposition of the record. See Process State Information for details.
CREATED_BY | I/O | NUMBER | Identifies the USER_ID (from KNTA_USERS) for the user performing the transaction. If left blank, the value is derived from CREATED_BY_USERNAME. If both are left blank, the value is set to the user currently running the report.
CREATED_BY_USERNAME | I | VARCHAR2 | Identifies the USERNAME (from KNTA_USERS) for the user performing the transaction. This is used only if CREATED_BY is left blank.
CREATION_DATE | I/O | DATE | Indicates the transaction date. If left blank, the current date is used.
SOURCE_CODE | I | VARCHAR2 | Provides the identify of the source of the record. This value is not validated and is for informational purposes only.
NOTE | I | CLOB | Specifies the full text of the note.
REPLACE_NOTE_FLAG | Obsolete | VARCHAR2 | No longer used.

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: