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