KPFM_SCORE_SELECTIONS

This table stores selections of each score criterion.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KPFM_SCORE_CRITERIA_NLS

SCORE_CRITERION_ID

SCORE_CRITERION_ID

Column Descriptions

Column Name

Null?

Data Type

Description

SCORE_SELECTION_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

SCORE_CRITERION_ID

NOT NULL

NUMBER

Score criterion that the selection links to

SCORE_SELECTION_VALUE

NOT NULL

NUMBER

Integer value of the selection

SCORE_SELECTION_NAME

NOT NULL

VARCHAR2(200)

Name or description of the selection

DEFINITION_LANGUAGE

NOT NULL

VARCHAR2(40)

Language this row was defined in

REFERENCE_CODE

NOT NULL

VARCHAR2(200)

Reference code used to distinguish between different records

Indexes

Index Name

Index Type

Sequence

Column Name

KPFM_SCORE_SELECTIONS_N1

NONUNIQUE

1

SCORE_CRITERION_ID

KPFM_SCORE_SELECTIONS_U1

UNIQUE

1

SCORE_SELECTION_ID

SYS_C005199307

UNIQUE

1

REFERENCE_CODE

Sequences

Sequence Name

Sequence Type

KPFM_SCORE_SELECTIONS_S

SCORE_SELECTION_ID