KPFM_SCORE_CRITERIA

This table stores a list of scoring criteria. Each valid criterion must have a matching validation that starts with 'PFM Score -'.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KPFM_SCORE_DOMAINS_NLS

SCORE_DOMAIN_ID

SCORE_DOMAIN_ID

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

SCORE_CRITERION_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_WEIGHT

NOT NULL

NUMBER

This is the weight of score criterion

SCORE_DOMAIN_ID

NOT NULL

NUMBER

Score domain the criterion belongs to

SCORE_CRITERION_NAME

NULLABLE

VARCHAR2(150)

Name for the score criterion

VALIDATION_REFERENCE_CODE

NULLABLE

VARCHAR2(200)

Validation that the score criterion links to

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_CRITERIA_N1

NONUNIQUE

1

SCORE_DOMAIN_ID

KPFM_SCORE_CRITERIA_U1

UNIQUE

1

SCORE_CRITERION_ID

SYS_C005199277

UNIQUE

1

REFERENCE_CODE

Sequences

Sequence Name

Sequence Type

KPFM_SCORE_CRITERIA_S

SCORE_CRITERION_ID