Share this page

# PFM_KPI_IMPACTS

This table contains the KPI Impact values defined in the Strategy section of request details of a Proposal/Asset/Project/Program, when it’s in a Portfolio for which at least one Business Goal is defined.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
PFM_KPIS | KPI_ID | KPI_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
KI_ID | NOT NULL | NUMBER | System-generated identifier
KI_VALUE | NOT NULL | NUMBER | Value of the KPI Impact, meaning by how much it’s likely to impact the related KPI when the initiative gets delivered
KI_EFFECT_OFFSET | NULLABLE | NUMBER | If the Initiative has a finish date (Project/Proposal), stores the number of months before (negative) or after (positive) finish date at which KPI Impact should occur.
KI_EFFECT_DATE | NULLABLE | DATE | If the initiative doesn’t have a finish date (Program/Asset), stores the date at which KPI Impact should occur
KI_COMMENTS | NULLABLE | VARCHAR2(4000 CHAR) | Comments for this KPI Impact
KPI_ID | NOT NULL | NUMBER | ID of KPI
ENTITY_TYPE_ID | NOT NULL | NUMBER | ID of the type of entity storing the KPI Impact (6 for Project, 67 for Program, etc.)
ENTITY_PK | NOT NULL | NUMBER | Primary Key of the entity Storing the KPI Impact (Request ID, Project ID, Program ID, etc.)
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
VERSION | NOT NULL | NUMBER | Version
KI_ASSUMPTIONS | NULLABLE | VARCHAR2(4000 CHAR) | Assumptions for the KPI Impact
KI_STATUS | NULLABLE | VARCHAR2(20 BYTE) | KPI Impact status: ACCOMPLISHED MISSED UNKNOWN

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
PFM_KI_N1 | UNIQUE | 1 | ENTITY_TYPE_ID, ENTITY_PK, KPI_ID
PFM_KPI_IMPACTS_N1 | NONUNIQUE | 1 | KPI_ID
PFM_KPI_IMPACTS_PK | UNIQUE | 1 | KPI_ID

## Sequences

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