Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: