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 |