KNTA_FIELD_FILTERS

Field filters are mappings between fields (through their validation profiles) and filters (using validation) given the filter code. This table stores seed data only, and no data should be added to this table.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_VALIDATIONS_NLS

VALIDATION_ID

VALIDATION_ID

KNTA_VALIDATION_PROFILES_NLS

VALIDATION_PROFILE_ID

VALIDATION_PROFILE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

FIELD_FILTER_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

VALIDATION_ID

NULLABLE

NUMBER

Validation to be used for a selected filter

VALIDATION_PROFILE_ID

NOT NULL

NUMBER

Validation Profile of the field

FILTER_CODE

NOT NULL

VARCHAR2(30)

Filter Code for this particular relationship between Validation Profile and Validation

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_FIELD_FILTERS_N1

NONUNIQUE

1

VALIDATION_PROFILE_ID

KNTA_FIELD_FILTERS_U1

UNIQUE

1

FIELD_FILTER_ID

Sequences

Sequence Name

Sequence Type

KNTA_FIELD_FILTERS_S

FIELD_FILTER_ID