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 |