KPPO_OPT_RESULT_PROJECTS

This table stores the portfolio items that the optimizer chose for its solution and a period offset if it recommends shifting the proposal or project.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KPPO_OPT_RESULTS

OPT_RESULTS_ID

OPT_RESULTS_ID

KCRT_REQUESTS

REQUEST_ID

REQUEST_ID

KCRT_FG_PFM_ASSET

REQUEST_ID

REQUEST_ID

KCRT_FG_PFM_PROJECT

REQUEST_ID

REQUEST_ID

KCRT_FG_PFM_PROPOSAL

REQUEST_ID

REQUEST_ID

Column Descriptions

Column Name

Null?

Data Type

Description

OPT_RESULT_PROJECT_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_RESULTS_ID

NOT NULL

NUMBER

foreign key reference to KPPO_OPT_RESULTS which is the parent of this row

REQUEST_ID

NOT NULL

NUMBER

the proposal, project or asset request ID that is selected by the optimizer

PERIOD_OFFSET

NOT NULL

NUMBER

the number of periods the optimizer recommends to shift the proposal or project (months). 0 means no shift.

Indexes

Index Name

Index Type

Sequence

Column Name

KPPO_OPT_RESULT_PROJECTS_N1

NONUNIQUE

1

OPT_RESULTS_ID

KPPO_OPT_RESULT_PROJECTS_U1

UNIQUE

1

OPT_RESULT_PROJECT_ID

Sequences

Sequence Name

Sequence Type

KPPO_OPT_RESULT_PROJECTS_S

OPT_RESULT_PROJECT_ID