KPFM_CONFIGURATIONS

This table stores the configuration for PFM product. The configuration applies to the entire product for every user. There is currently only 1 row in this table.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

CONFIGURATION_ID

NOT NULL

NUMBER

System-generated identifier

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

RETURN_ON_INVESTMENT_FLAG

NOT NULL

VARCHAR2(1)

Keeps track of whether users use ROI. Default is Y.

NET_PRESENT_VALUE_FLAG

NOT NULL

VARCHAR2(1)

Keeps track of whether users use NPV. Default is N.

CUSTOM_FIELD_VALUE_FLAG

NOT NULL

VARCHAR2(1)

Keeps track of whether users need to use a custom financial metric. Default is N.

PROJECT_CLASS_FLAG

NOT NULL

VARCHAR2(1)

Keeps track of whether users want to track entities in project class. Default is U.

ASSET_CLASS_FLAG

NOT NULL

VARCHAR2(1)

Keeps track of whether users want to track entities in asset class. Default is U.
ENABLE_OVERVIEW_FLAG NOT NULL VARCHAR2(1) Keeps track of whether users enable portfolio overview customization.

Indexes

This table uses no indexes.

Sequences

Sequence Name

Sequence Type

KPFM_CONFIGURATIONS_S

CONFIGURATION_ID