Share this page

# KWFL_TRANSACTIONS_INT

The KWFL_TRANSACTIONS_INT interface table is used to set workflow decision steps and store the specific transaction that is to be performed at a workflow step for a package line or a request. This information includes the transaction type, package number, request number, and the workflow step.

Table A-31. KWFL_TRANSACTIONS_INT interface table
Column | Usage | Data Type | Description
--- | --- | --- | ---
TRANSACTION_ID | I | NUMBER | Uniquely identifies each transaction.
CREATION_DATE | I/O | DATE | The date/time for the step transaction cannot be set via this interface table. Instead, the value is taken from the LAST_UPDATE_DATE.
CREATED_USERNAME | I | VARCHAR2 | Identifies the USERNAME (from KNTA_USERS) for the user performing the transaction. Supply this or CREATED_BY.
CREATED_BY | I | NUMBER | Identifies the USER_ID (from KNTA_USERS) for the user performing the transaction. Supply this or CREATED_USERNAME.
LAST_UPDATE_DATE | I/O | DATE | This value is taken from the report execution date/time, which is transferred to the date/time for the step transaction. If left blank, the current date is used.
LAST_UPDATED_USERNAME | I | VARCHAR2 | Identifies the USERNAME (from KNTA_USERS) for the user performing the transaction. Supply this or LAST_UPDATED_BY.
LAST_UPDATED_BY | I/O | NUMBER | Identifies the USER_ID (from KNTA_USERS) for the user performing the transaction. Supply this or LAST_UPDATED_USERNAME. If both are left blank, the value is derived from CREATED_USERNAME.
EVENT | I | VARCHAR2 | Specifies the type of workflow transaction.
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.
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.
WORKFLOW_ENGINE_BATCH_ID | O | NUMBER | Specifies the batch in which the workflow engine carried out this transaction.
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.
SOURCE_TYPE_CODE | I | VARCHAR2 | Specifies the type of external update. This should be a left blank or have a value of INTERFACE_WF.
SOURCE | I | VARCHAR2 | Specifies the source of the information. This information is not validated during an import. For example, the name of the third-party application or a value of CONVERSION.
INSTANCE_SOURCE_TYPE_CODE | I | VARCHAR2 | Indicates whether or not the transaction is for a package line (CR) or a request (IR).
INSTANCE_SOURCE_SET_NUMBER | I | VARCHAR2 | Specifies the package number (PACKAGE_NUMBER from KDLV_PACKAGES) or request number (REQUEST_NUMBER from KCRT_REQUESTS). Supply this or INSTANCE_SOURCE_SET_ID.
INSTANCE_SOURCE_SET_ID | I | NUMBER | Specifies the package ID (PACKAGE_ID from KDLV_PACKAGES) or request ID (REQUEST_ID from KCRT_REQUESTS). Supply this or INSTANCE_SOURCE_SET_NUMBER.
INSTANCE_SOURCE_LINE_SEQ | I | NUMBER | Specifies the package line sequence number (SEQ from KDLV_PACKAGE_LINES). Supply this or INSTANCE_SOURCE_ID.
INSTANCE_SOURCE_ID | I | NUMBER | Specifies the package line ID (PACKAGE_LINE_ID from KDLV_PACKAGE_LINES) or request ID (REQUEST_ID from KCRT_REQUESTS). Supply this or INSTANCE_SOURCE_LINE_SEQ (for package lines) or INSTANCE_SOURCE_SET_NUMBER (for requests).
WORKFLOW_STEP_NAME | I | VARCHAR2 | Specifies the name of the workflow step (STEP_NAME from KWFL_WORKFLOW_STEPS). Supply this or WORKFLOW_STEP_ID.
WORKFLOW_STEP_SEQ | I | VARCHAR2 | Specifies the sequence number of the workflow step. Supply this or WORKFLOW_STEP_ID. For subworkflows, the sequence numbers of the workflow steps could be in the form of 2.4.5 and so forth.
RESULT_VALUE | I | VARCHAR2 | Indicates the result of the step. This is normally not displayed to the user; therefore it may be an ID or internal code.
VISIBLE_RESULT_VALUE | I | VARCHAR2 | Indicates the result of the step. This is the result value that a user normally sees.
USER_COMMENTS | I | VARCHAR2 | Specifies comments for the transaction. Any comments are appended to the notes for the package or request.
DELEGATED_TO_USERNAME | I | VARCHAR2 | Specifies the USERNAME (from KNTA_USERS) for the user that the decision is being delegated to. Supply this or DELEGATED_TO_USER_ID.
DELEGATED_TO_USER_ID | I | NUMBER | Specifies the USER_ID (from KNTA_USERS) for the user that the decision is being delegated to. Supply this or DELEGATED_TO_USERNAME.
SCHEDULE_DATE | I | DATE | Indicates the date that the execution step is scheduled to run.
WORKFLOW_ID | O | NUMBER | Specifies the workflow that the package should follow.
WORKFLOW_INSTANCE_ID | O | NUMBER | Specifies the instance ID.
WORKFLOW_STEP_ID | I | NUMBER | Specifies the workflow step ID (WORKFLOW_STEP_ID from KWFL_WORKFLOW_STEPS). Supply this, WORKFLOW_STEP_NAME, or WORKFLOW_STEP_SEQ.
WORKFLOW_INSTANCE_STEP_ID | O | NUMBER | Specifies the instance step ID.
CURRENT_STEP_TRANSACTION_ID | O | NUMBER | Specifies the current step transaction ID.
APPROVALS_REQUIRED_CODE | O | NUMBER | Specifies the code for the required approvals.
EVENT_GROUP_ID | O | NUMBER | Specifies the group ID for the event.
CMD_EXECUTION_SCHD_TASK_ID | O | NUMBER | Specifies the execution step and the command that has been scheduled. This will specify the identified for the scheduled task.
TO_WORKFLOW_STEP_SEQ | I | VARCHAR2 | Specifies the sequence number of the workflow step for the step that the package line or request should transition to. Supply this, TO_WORKFLOW_STEP_ID, or TO_WORKFLOW_STEP_NAME.
TO_WORKFLOW_STEP_NAME | I | VARCHAR2 | Specifies the name of the workflow step (STEP_NAME from KWFL_WORKFLOW_STEPS) for the step that the package line or request should transition to. Supply this, TO_WORKFLOW_STEP_SEQ, or TO_WORKFLOW_STEP_ID.
TO_WORKFLOW_STEP_ID | I | NUMBER | Specifies the workflow step ID (WORKFLOW_STEP_ID from KWFL_WORKFLOW_STEPS) for the step that the package line or request should transition to. Supply this, TO_WORKFLOW_STEP_NAME, or TO_WORKFLOW_STEP_SEQ.

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: