Share this page

# KWFL_STEP_TRANSITIONS_INT

This table is used to migrate the workflow definition between instances.

Table A-30. KWFL_STEP_TRANSITIONS_INT interface table
Column | Usage | Data Type | Description
--- | --- | --- | ---
TRANSACTION_ID | I | NUMBER | Uniquely identifies each transaction. If left blank, the value is generated by the system.
PARENT_TRANSACTION_ID | I | NUMBER | Provides the transaction ID (from KCRT_REQUESTS_INT) of the parent table being imported.
GROUP_ID | I | NUMBER | Groups all the records that should be processed at the same time. Use only one GROUP_ID for each batch of imported users when running the User Open Interface report. Derived from the KNTA_INTERFACE_GROUPS_S sequence. This value should be the same as the parent's GROUP_ID in KCRT_REQUEST_INT.
EXISTS_FLAG | I/O | VARCHAR2 | If set to 'Y' then the record already exists in the database.
PROCESS_PHASE | I/O | NUMBER | Indicates the current stage of the record as it is being processed. Indicates which phase a record is at: Pending, Deriving, Validating, Importing or Completed See Process State Information for details.
PROCESS_STATUS | I/O | NUMBER | Indicates the current status of the interface record: Pending, In Process, Errored or Completed See Process State Information for details.
CREATED_BY_USERNAME | I/O | VARCHAR2 | Identifies the USERNAME (from KNTA_USERS) for the user performing the transaction. This is used only if CREATED_BY is left blank. If both are left blank, the value is set to the user currently running the report.
CREATION_DATE | I/O | DATE | Indicates the date that the record was created. If left blank, the current date is used.
DEST_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.
DEST_CREATION_DATE | I/O | DATE | 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.
DEST_LAST_UPDATED_BY | I/O | NUMBER | Identifies the USER_ID (from KNTA_USERS) for the user that last updated the data. If left blank, the value is set to the user currently running the report.
DEST_LAST_UPDATE_DATE | I/O | DATE | Indicates the date that the user data was last updated. If left blank, the current date is used.
STEP_TRANSITION_ID | I/O | NUMBER | Identifier for the source, system-generated.
DEST_STEP_TRANSITION_ID | I/O | NUMBER | Identifier for destination, system-generated.
TRANSITION_TYPE_CODE | I/O | VARCHAR2 | Defined by the lookup type WF_TRANSITION_TYPE. One of the following values: "SPECIFIC_VALUES", "OTHER_VALUES", "ALL_VALUES", "SPECIFIC_ERROR", "OTHER_ERRORS", "ALL_ERRORS".
OPERATOR_CODE | I/O | VARCHAR2 | Defined by the lookup type WF_TRANS_OPERATOR. One of the following "=", "!=". If the validation is a text field with the numeric mask set, or if it is a date field, then the following values are also possible: "<", ">", "<=", ">=".
RESULT_VALUE | I/O | 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/O | VARCHAR2 | Indicates the result of the step. This is the result value that a user normally sees.
FROM_WORKFLOW_STEP_ID | I/O | NUMBER | Identifies the source workflow step.
FROM_WORKFLOW_STEP_NAME | I/O | VARCHAR2 | Provides the name of the source workflow step.
DEST_FROM_WORKFLOW_STEP_ID | I/O | NUMBER | Identifies of the source workflow step in destination.
TO_WORKFLOW_STEP_ID | I/O | NUMBER | Identifies the target workflow step.
TO_WORKFLOW_STEP_NAME | I/O | VARCHAR2 | Provides the name of the target workflow step.
DEST_TO_WORKFLOW_STEP_ID | I/O | NUMBER | Identifies the target workflow step in destination.
DRAW_LABEL_POS | I/O | VARCHAR2 | The relative position of where the label is displayed in the workflow layout. It is a real number between 0.0 and 1.0.
DRAW_JOINT_COORDS | I/O | VARCHAR2 | A list of coordinates separated by ";". Each coordinate is a pair of integers, separated by a comma. Example: "100,200;300,400" defines two joints at positions (100,200) and (300,400). If NULL, a straight line is drawn from the source to the target step figure.
SOURCE_TYPE_CODE | I/O | VARCHAR2 | Specifies the type of external update. This should be a left blank or have a value of INTERFACE_WF.
SOURCE | I/O | 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.

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: