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 |
