Share this page

# KDLV_TRANSACTIONS_INT

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.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KDLV_PACKAGES | PACKAGE_ID | PACKAGE_ID
KWFL_WORKFLOW_STEPS_NLS | WORKFLOW_STEP_ID | WORKFLOW_STEP_ID
KDLV_PACKAGE_LINES | PACKAGE_LINE_ID | PACKAGE_LINE_ID
KNTA_USERS | USER_ID | CREATED_BY
KWFL_WORKFLOW_INSTANCE_STEPS | WORKFLOW_INSTANCE_STEP_ID | WORKFLOW_INSTANCE_STEP_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
TRANSACTION_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
PROCESS_PHASE | NULLABLE | NUMBER | Common column, indicates which phase a record is at: Pending, Deriving, Validating, Importing or Completed
PROCESS_STATUS | NULLABLE | NUMBER | Common column, 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) | Common column, used to differentiate interface records by their point of origin
PACKAGE_ID | NULLABLE | NUMBER | ID of a Package
PACKAGE_NUMBER | NULLABLE | VARCHAR2(40) | Assigned number of a Package
PACKAGE_LINE_ID | NULLABLE | NUMBER | ID of a Package Line
PACKAGE_LINE_SEQ | NULLABLE | NUMBER | Sequence number of a Package Line
WORKFLOW_INSTANCE_STEP_ID | NULLABLE | NUMBER | ID of an instance of a specific workflow step
WORKFLOW_STEP_ID | NULLABLE | NUMBER | ID of a specific step in a workflow
WORKFLOW_STEP_NAME | NULLABLE | VARCHAR2(80) | Name of a step in a workflow
RESULT_VALUE | NULLABLE | VARCHAR2(200) | Hidden value of a workflow status
VISIBLE_RESULT_VALUE | NULLABLE | VARCHAR2(200) | Visible value of a workflow status
EXECUTE_FLAG | NULLABLE | VARCHAR2(1) | Whether or not a specific step is executable
COMMENTS | NULLABLE | VARCHAR2(2000) | Comments
SCHEDULE_DATE | NULLABLE | DATE | Scheduled date for transaction

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KDLV_TRANSACTIONS_INT_N1 | NONUNIQUE | 1 | TRANSACTION_INTERFACE_ID
KDLV_TRANSACTIONS_INT_N2 | NONUNIQUE | 1 | GROUP_ID
KDLV_TRANSACTIONS_INT_N2 | NONUNIQUE | 2 | TRANSACTION_INTERFACE_ID
KDLV_TRANSACTIONS_INT_N3 | NONUNIQUE | 1 | PACKAGE_NUMBER

## Sequences

This table uses no sequences.

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: