KPFM_SCENARIO_CONTENTS

Each scenario contains a list of PFM entities and each scenarios include or exclude them. This table stores the content of the PFM entities and whether they are included in the scenario. Note that if a scenario comparison contains 10 entities, you will have 30 rows in this table since there are always 3 scenarios per comparison.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KPFM_SCENARIO_COMPARISONS

SCEN_COMPARISON_ID

SCEN_COMPARISON_ID

KNTA_USERS

USER_ID

CREATED_BY

KPFM_SCENARIOS

SCENARIO_ID

SCENARIO_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KCRT_REQUESTS

REQUEST_ID

REQUEST_ID

Column Descriptions

Column Name

Null?

Data Type

Description

SCENARIO_CONTENT_ID

NOT NULL

NUMBER

System-generated identifier

SCEN_COMPARISON_ID

NOT NULL

NUMBER

Scenario comparison ID the content belongs to.

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

SCENARIO_ID

NOT NULL

NUMBER

Scenario ID

REQUEST_ID

NOT NULL

NUMBER

PFM Center entity ID

INCLUDE_IN_SCENARIO_FLAG

NOT NULL

VARCHAR2(1)

Whether or not the scenario (specified in SCENARIO_ID column) includes the PFM entity (specified in REQUEST_ID) column. The value in this column is Y or N.

PLAN_PERIOD_OFFSET

NOT NULL

NUMBER

Offset between the scenario start and the what-if start

Indexes

Index Name

Index Type

Sequence

Column Name

KPFM_SCENARIO_CONTENTS_N1

NONUNIQUE

1

SCEN_COMPARISON_ID

KPFM_SCENARIO_CONTENTS_N2

NONUNIQUE

1

REQUEST_ID

KPFM_SCENARIO_CONTENTS_N3

NONUNIQUE

1

SCENARIO_ID

KPFM_SCENARIO_CONTENTS_U2

UNIQUE

1

SCENARIO_CONTENT_ID

KPFM_SCENARIO_CONTENTS_U2

UNIQUE

2

REQUEST_ID

Sequences

Sequence Name

Sequence Type

KPFM_SCENARIO_CONTENTS_S

SCENARIO_CONTENT_ID