KPPO_PER_PROJECT_SETTINGS

The optimization wizard allows the user to choose which proposals, projects, and assets get special treatment. This table stores those settings, with one row for each portfolio item.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KCRT_FG_PFM_PROPOSAL

REQUEST_ID

REQUEST_ID

KNTA_USERS

USER_ID

CREATED_BY

KCRT_REQUESTS

REQUEST_ID

REQUEST_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KCRT_FG_PFM_ASSET

REQUEST_ID

REQUEST_ID

KCRT_FG_PFM_PROJECT

REQUEST_ID

REQUEST_ID

KPPO_OPT_PARAMETERS

OPT_PARAMETERS_ID

OPT_PARAMETERS_ID

Column Descriptions

Column Name

Null?

Data Type

Description

PER_PROJECT_SETTINGS_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

OPT_PARAMETERS_ID

NOT NULL

NUMBER

Foreign key to KPPO_OPT_PARAMETERS which is the parent of this row

REQUEST_ID

NOT NULL

NUMBER

ID of the proposal, project, or asset that this row is for

REQUIRED_FLAG

NOT NULL

VARCHAR2(1)

'Y' or 'N', if Y, the portfolio item must be included in the suggested scenario

ALLOW_TIME_SHIFT_FLAG

NOT NULL

VARCHAR2(1)

'Y' or 'N', if 'Y', the optimizer can suggest moving the project up to 6 months to get a better budget or resource fit

Indexes

Index Name

Index Type

Sequence

Column Name

KPPO_PER_PROJECT_SETTINGS_N1

NONUNIQUE

1

OPT_PARAMETERS_ID

KPPO_PER_PROJECT_SETTINGS_U1

UNIQUE

1

PER_PROJECT_SETTINGS_ID

Sequences

Sequence Name

Sequence Type

KPPO_PER_PROJECT_SETTINGS_S

PER_PROJECT_SETTINGS_ID