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.