Share this page

# PPM_INT_AGILE_PORTFOLIO_AUDIT

This table stores the audit trail for the integration between PPM portfolio and OpenText Software Delivery Management entities.

## Foreign keys

There are no foreign keys for this table.

## Column descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
AUDIT_ID | NOT NULL | NUMBER | System-generated identifier.
REPORT_ID | NOT NULL | NUMBER | The report ID in knta_report_submissions.
PORTFOLIO_NAME | NULLABLE | VARCHAR | The portfolio name synced to agile system.
PARENT_PORTFOLIO_NAME | NULLABLE | VARCHAR | The parent portfolio name synced to agile system.
PROCESS_STATUS | NOT NULL | VARCHAR | Whether the integration succeeded or failed. The values include: SUCCESS, FAILED.
ERROR_CODE | NULLABLE | VARCHAR | Error code returned from the agile system.
ERROR_MESSAGE | NULLABLE | VARCHAR | Error message returned from the agile system.
ACTION | NOT NULL | NUMBER | Whether a PPM request or an OpenText Software Delivery Management entity is created, updated, or deleted. The values include: CREATE, UPDATE, or DELETE.
NOTE | NULLABLE | CLOB | Notes if the integration was rejected.
AGILE_ENTITY_ID | NOT NULL | NUMBER | The ID of the agile entity in the agile system.
PORTFOLIO_UPDATED_BY | NULLABLE | NUMBER | The user who updated the portfolio.
PORTFOLIO_UPDATE_DATE | NULLABLE | DATE | The time when the portfolio was updated.

## Indexes

This table has no indexes.

## Sequences

This table uses no sequences.

Sequence Name | Sequence Type
--- | ---
ppm_int_agile_pf_audit_s | Auto-increment

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: