Share this page

# PPM_PURGE_HISTORY

This table stores the audit trail for purging.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
ID | NOT NULL | NUMBER | System-generated identifier
REASON | NULLABLE | VARCHAR2 | Reason for the purging
CONTENT | NULLABLE | VARCHAR2 | Purging count by entities in JSON format
CREATED_BY | NOT NULL | NUMBER | User who created the record
CREATION_DATE | NOT NULL | DATE | Date when the record was created
LAST_UPDATED_BY | NULLABLE | NUMBER | User who last updated the record
LAST_UPDATE_DATE | NULLABLE | DATE | Date when the record was last updated
COMMIT_FLAG | NULLABLE | VARCHAR2 | Default N. N means that the marking phase is finished. Y means that the purging phase is finished.
CRITERIA | NULLABLE | BLOB | Stores the criteria `xml.` file.
PURGE_INFO | NULLABLE | CLOB | Purging report

## Indexes

This table does not have any indexes.

## Sequences

Sequence Name | Sequence Type
--- | ---
PPM_PURGE_HISTORY_S | 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: