PFM_KPIS

This table stores the KPIs information.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

KPI_ID

NOT NULL

NUMBER

System-generated identifier

CREATION_ DATE

NOT NULL

DATE

Date when the KPI was created

CREATED_ BY

NOT NULL

NUMBER

Identifier for the user who created the KPI

LAST_ UPDATE_ DATE

NOT NULL

DATE

Date when the KPI was last updated

LAST_ UPDATED_ BY

NOT NULL

NUMBER

Identifier for the user who last updated the KPI

KPI_NAME

NULLABLE

VARCHAR2(255 CHAR)

Name of the KPI

KPI_TYPE

NOT NULL

VARCHAR2(20 CHAR)

Type of the KPI

  • NUMBER
  • MONEY
  • PERCENTAGE

KPI_DIRECTION

NULLABLE

VARCHAR2(3 BYTE)

Optimization direction of the KPI

  • MAX
  • MIN

CURRENCY_ID

NULLABLE

NUMBER

ID of the currency if the KPI is of the money type

KPI_DESCRIPTION

NULLABLE

VARCHAR2(4000 CHAR)

KPI description

KPI_STATUS

NOT NULL

VARCHAR2(20 BYTE)

KPI Status:

  • DRAFT
  • ACTIVE
  • RETIRED
  • DELETED

VERSION

NOT NULL

NUMBER

Version
BG_ID NULLABLE NUMBER If the KPI is a private KPI, this column stores the ID of the business goal for which the KPI was created

Indexes

Index Name

Index Type

Sequence

Column Name

PFM_KPIS_PK

UNIQUE

1

KPI_ID

SYS_C00152007

UNIQUE

1

KPI_NAME

PFM_KPIS_N1

NONUNIQUE

1

CURRENCY_ID

Sequences

This table does not have any sequences.