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.