PVO_SETTINGS_ATTRIBUTES

This table stores the settings of tables in what-if analysis scenarios.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

SETTINGS_ATTRIBUTES_ID

NOT NULL

NUMBER

Identifier for the table settings

VERSION

NOT NULL

VARCHAR2

System-generated version, used for hibernate version control.

NAME

NOT NULL

VARCHAR2

Name of the table settings

For example, "TABLE_SETTING_SCENARIO_DETAIL_CONTENTS" refers to the table settings of the Contents tab in the scenario details page.

VALUE

NULLABLE

VARCHAR2

Values of the table settings

SETTING_PATH

NOT NULL

VARCHAR2

Scenario ID and user ID

CREATION_DATE

NOT NULL

DATE

Date when the scenario was created

CREATED_BY

NOT NULL

NUMBER

User that created the scenario

LAST_UPDATED_BY

NOT NULL

NUMBER

User that last updated the scenario

LAST_UPDATE_DATE

NOT NULL

DATE

Date when the scenario was last updated

Indexes

There are no indexes for this table.

Sequences

Sequence Name

Sequence Type

PVO_SETTINGS_ATTRIBUTES_S

SETTINGS_ATTRIBUTES_ID