KDEM_DEMAND_FIELDS

This table stores the details of demand fields. There will be one record in this table for each demand field in a demand set.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KDEM_DEMAND_SETS

DEMAND_SET_ID

DEMAND_SET_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_VALIDATIONS_NLS

VALIDATION_ID

SEARCH_VALIDATION_ID

Column Descriptions

Column Name

Null?

Data Type

Description

DEMAND_FIELD_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

DEMAND_SET_ID

NOT NULL

NUMBER

Identifier that identifies which set the demand belongs to

FIELD_NAME

NOT NULL

VARCHAR2(100)

Name of the demand field

PARAMETER_COLUMN_NUMBER

NOT NULL

NUMBER

Column number of the demand field in the demand table

SEARCH_VALIDATION_ID

NOT NULL

NUMBER

Identifier to identify which search validation to use for the demand field

Indexes

Index Name

Index Type

Sequence

Column Name

KDEM_DEMAND_FIELDS_U1

UNIQUE

1

DEMAND_FIELD_ID

KDEM_DEMAND_FIELDS_U3

UNIQUE

1

DEMAND_SET_ID

KDEM_DEMAND_FIELDS_U3

UNIQUE

2

PARAMETER_COLUMN_NUMBER

Sequences

Sequence Name

Sequence Type

KDEM_DEMAND_FIELDS_S

DEMAND_FIELD_ID