Share this page

# 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.

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: