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.