Share this page

# KDLV_PACKAGES_INT

The KDLV_PACKAGES_INT interface table is used to define header information for each new package. This interface table stores package header information for new packages to be generated. This includes information such as package number, priority, project name, and description. This table also holds columns to import user data information (custom fields attached to the packages).

Table A-21. KDLV_PACKAGES_INT interface table
Column | Usage | Data Type | Description
--- | --- | --- | ---
DATA_LANG | I | VARCHAR2 | Specifies the language of the data being imported, so it can be properly validated in the respective language. If no value is provided, then the language context is the same as the system language of the PPM instance into which the data is being imported.
PACKAGE_INTERFACE_ID | I | NUMBER | Provides a unique identifier for the each record. Derived from the KDLV_INTERFACES_S sequence. 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. This is required if package lines exist. For new lines, this should be left blank.
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.
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.
PACKAGE_ID | I | NUMBER | Provides an identifier for a package and makes the association between the package and package lines. Derived from the KDLV_PACKAGES_S sequence. For lines tied to a new package, this column can be used to tie the line record to the parent record in KDLV_PACKAGES_INT. Either PACKAGE_INTERFACE_ID and PACKAGE_NUMBER can be used to tie the records. For new lines to be imported into existing packages, this column should refer to the PACKAGE_ID of the existing package.
REQUESTED_BY | I | NUMBER | Identifies the USER_ID (from KNTA_USERS) for the user requesting the package. If left blank, the value is derived from REQUESTED_BY_USERNAME. If both are left blank, the value is set to the user currently running the report.
REQUESTED_BY_USERNAME | I | VARCHAR2 | Identifies the USERNAME (from KNTA_USERS) of the user requesting the package. This is used only if REQUESTED_BY is left blank.
PACKAGE_NUMBER | I | VARCHAR2 | Identifies the package number. This must use either the same value as PACKAGE_ID or a unique string.
ASSIGNED_TO_USER_ID | I/O | NUMBER | Specifies the USER_ID (from KNTA_USERS) that should initially be assigned the request. If left blank, the value is derived from ASSIGNED_TO_USERNAME. If both are left blank, the package will not have an initial value.
ASSIGNED_TO_USERNAME | I | VARCHAR2 | Specifies the USERNAME (from KNTA_USERS) that should initially be assigned the request. This is used only if ASSIGNED_TO_USER_ID is left blank.
ASSIGNED_TO_GROUP_ID | I/O | NUMBER | Specifies the SECURITY_GROUP_ID (from KNTA_SECURITY_GROUPS) that should initially be assigned to the package. If left blank, this value is derived from ASSIGNED_TO_GROUP_NAME. If both are left blank, the package will not have an initial value.
ASSIGNED_TO_GROUP_NAME | I | VARCHAR2 | Specifies the SECURITY_GROUP_ID (from KNTA_SECURITY_GROUPS) that should initially be assigned the package. This is used only if ASSIGNED_TO_GROUP_ID is left blank.
DESCRIPTION | I | VARCHAR2 | Specifies a user-visible description of the package.
PACKAGE_TYPE_CODE | I | VARCHAR2 | Provides a user-defined categorization of the package. Must be a valid LOOKUP_CODE from KNTA_LOOKUPS where `LOOKUP_TYPE = 'PACKAGE_TYPE'`.
PRIORITY_CODE | I | VARCHAR2 | Indicates the user-defined priority for the package. Must be a valid LOOKUP_CODE from KNTA_LOOKUPS where `LOOKUP_TYPE = 'PACKAGE_PRIORITY'`.
STATUS_CODE | O | VARCHAR2 | Indicates the status of the package.
PROJECT_CODE | I | VARCHAR2 | Indicates the user-defined project for the package. This should be a valid value from KNTA_LOOKUPS where `LOOKUP_TYPE = 'PROJECT'`.
WORKFLOW_ID | I | NUMBER | Specifies the workflow that the package should follow. Derived from WORKFLOW_NAME. Either WORKFLOW_ID or WORKFLOW_NAME must be entered.
WORKFLOW_NAME | I | VARCHAR2 | Specifies the workflow that the package should follow. This is used only if WORKFLOW_ID is left blank.
PRIORITY_SEQ | I/O | NUMBER | Provides a sequence number used to determine the relative priority of packages that are scheduled to process at the same time. If left blank, the value is set to 10.
RELEASE_FLAG | I | VARCHAR2 | Indicates whether or not the interface program will release the package once it imports in into the standard Deployment Management tables. Valid values are: Yes No The default is No.
USER_DATA_SET_CONTEXT_ID | I/O | NUMBER | Sets the context identifier for the USER_DATA fields. If left blank, the value is set to 1202.
USER_DATA1 VISIBLE_USER_DATA1 through USER_DATA20 VISIBLE_USER_DATA20 | I | VARCHAR2 | Specifies the user-defined fields attached to the user screen. This is required only if user data is defined. This information is not validated nor does it have a default value.
SOURCE_PACKAGE_ID | I | NUMBER | Identifies the original package for this distribution package.
DISTPKG_STATUS_MEANING | I | VARCHAR2 | Provides a user-visible status for this distribution package.
RUN_GROUP | I | NUMBER | Provides a run group number of a specific distribution package.
DISTRIBUTION_ID | I | NUMBER | Identifies the distribution associated with the package.
ENABLED_FLAG | I | VARCHAR2 | Indicates whether or not the distribution package is enabled upon import. (Applies to distribution packages only.) Valid values are: Y N The default values is Y.
DIST_STEP_TRANSACTION_ID | I | NUMBER | Specifies the path of the distribution workflow step that was run in the transaction with DIST_STEP_TRANSACTION_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: