RPT_FCT_REQUEST_TRANSACTIONS

This table holds workflow transaction history derived from PPM tables. All the fields are derived from PPM workflow transaction tables.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

STEP_TRANSACTION_ID

NOT NULL

NUMBER

ID of the step transaction to which this history row belongs

REQUEST_ID

NULLABLE

NUMBER

ID of the request

TIME_INTERVAL

NULLABLE

NUMBER

Time interval between the first step and the final step

FIRST_STEP_DATE

NULLABLE

DATE

Date of the first step transaction

FINAL_STEP_DATE

NULLABLE

DATE

Date of the last step transaction

USER_ID

NULLABLE

NUMBER

User ID derived from KWFL_STEP_TRANSACTION_HISTORY.LAST_UPDATED_BY

STEP_IDENTIFIER

NULLABLE

VARCHAR2(200)

ID of the step transaction

ID format: Sort Order-Step ID. For example, 2-1001-3-5004-6-7003

WORKFLOW_STEP_ID

NULLABLE

NUMBER

ID of the workflow step that needs to be processed

FIRST_STEP_STATUS

NULLABLE

VARCHAR2(30)

Status of the first step transaction

FINAL_STEP_STATUS

NULLABLE

VARCHAR2(30)

Status of the final step transaction

RESULT_VALUE

NULLABLE

VARCHAR2(200)

Result of the step transaction when this history row was created

VISIBLE_ERROR_VALUE

NULLABLE

VARCHAR2(200)

Error value of the step transaction when this history row was created

ERROR_MESSAGE

NULLABLE

VARCHAR2(240)

Error message for the step transaction when this history row was created

USER_COMMENT

NULLABLE

VARCHAR2(240)

Comments within the step transaction when this history row was created

Indexes

Index Name Index Type Sequence Column Name
FCT_REQUEST_TRANSACTIONS_IDX_1 NONUNIQUE 1 REQUEST_ID
FCT_REQUEST_TRANSACTIONS_IDX_2 NONUNIQUE 1 USER_ID
FCT_REQUEST_TRANSACTIONS_IDX_3 NONUNIQUE 1 WORKFLOW_STEP_ID
SYS_C009015322 UNIQUE 1 STEP_TRANSACTION_ID

Sequences

This table uses no sequences.