KPPO_OPT_MIX_ENTRIES

This is a child of KPPO_OPT_PARAMETERS and stores the details of the mix thresholds for Business Objectives, Project class, and asset class.

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_PARAMETERS

OPT_PARAMETERS_ID

OPT_PARAMETERS_ID

Column Descriptions

Column Name

Null?

Data Type

Description

OPT_MIX_ENTRY_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

Key in KPPO_OPT_PARAMETERS that is the parent of this row

MIX_TYPE_CODE

NOT NULL

VARCHAR2(30)

BUSINESS_OBJECTIVE, PROJECT_CLASS, or ASSET_CLASS indicates which of the three this entry relates to

MIX_CODE

NOT NULL

VARCHAR2(30)

Code for the sub item of the class, for example if the mix type is BUSINESS_OBJECTIVE, this would be the business objective ID

THRESHOLD

NULLABLE

NUMBER

Value of the threshold (0-100%)

Indexes

Index Name

Index Type

Sequence

Column Name

KPPO_OPT_MIX_ENTRIES_N1

NONUNIQUE

1

OPT_PARAMETERS_ID

KPPO_OPT_MIX_ENTRIES_U1

UNIQUE

1

OPT_MIX_ENTRY_ID

Sequences

Sequence Name

Sequence Type

KPPO_OPT_MIX_ENTRIES_S

OPT_MIX_ENTRY_ID