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
|