Share this page

# KCRT_TRANSACTIONS

This table stores the audit trail for the PARAMETER field values and its prompt. When creating/editing fields in the request type screen, you have a capability to indicate if the "transaction history" (audit trail) should be maintained for the field. If transaction history is turned on in a request type field, when ever the value of that field changes in a request, a record is logged in this table.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KCRT_REQUESTS | REQUEST_ID | REQUEST_ID
KCRT_REQUEST_TYPES_NLS | REQUEST_TYPE_ID | REQUEST_TYPE_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
TRANSACTION_ID | NOT NULL | NUMBER | System-generated identifier
REQUEST_ID | NOT NULL | NUMBER | Request for which this audit trail is created.
CREATION_DATE | NOT NULL | DATE | Date record was created
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
REQUEST_TYPE_ID | NOT NULL | NUMBER | Request type used by the request.
COLUMN_NAME | NULLABLE | VARCHAR2(30) | Column that is being audited in this record (PARAMETER1 - 50)
OLD_VISIBLE_COLUMN_VALUE | NULLABLE | VARCHAR2(4000) | Visible original column value.
OLD_COLUMN_VALUE | NULLABLE | VARCHAR2(4000) | Original column value.
NEW_VISIBLE_COLUMN_VALUE | NULLABLE | VARCHAR2(4000) | Visible new column value.
NEW_COLUMN_VALUE | NULLABLE | VARCHAR2(4000) | New column value
COLUMN_PROMPT | NULLABLE | VARCHAR2(100) | Current prompt for the column.
BATCH_NUMBER | NULLABLE | NUMBER | Batch number of the request detail where this PARAMETER field is found
TABLE_NAME | NULLABLE | VARCHAR2(30) | Table that is being audited in this record

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KCRT_TRANSACTIONS_N1 | NONUNIQUE | 1 | REQUEST_ID
KCRT_TRANSACTIONS_N2 | NONUNIQUE | 1 | REQUEST_TYPE_ID
KCRT_TRANSACTIONS_U1 | UNIQUE | 1 | TRANSACTION_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KCRT_TRANSACTIONS_S | TRANSACTION_ID

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: