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 |