PFM_KPI_VALUES

This table stores KPI values.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

PFM_KPI_VALUES

 

KPI_ID, KPI_DATE

 

KPI_ID, KPI_DATE

 

PFM_KPIS

 

KPI_ID

 

KPI_ID

 

Column Descriptions

Column Name

Null?

Data Type

Description

KPI_ID

NOT NULL

NUMBER

Id of KPI

KPI_DATE

NOT NULL

DATE

Business goal name

KPI_VALUE

NOT NULL

NUMBER

Business goal description

LAST_ UPDATE_ DATE

NULLABLE

DATE

Date when the record was last updated

LAST_ UPDATED_ BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

SOURCE

NULLABLE

VARCHAR2

(50)

An optional value, shows where the KPI value comes from

Indexes

Index Name

Index Type

Sequence

Column Name

PFM_KPI_VALUES_PK

UNIQUE

1

KPI_ID, KPI_DATE

Sequences

This table does not have any sequences.