Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: