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 |
|
PURGE_INFO |
NULLABLE |
CLOB |
Purging report |
Indexes
This table does not have any indexes.
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
PPM_PURGE_HISTORY_S |
ID |
