System Administration

Index Columns

Use this page to Add a Column to an Index.

To access this page:

  1. Select Admin > Data Sources in the Navigation pane.
  2. Click the Index icon for a data source.
  3. Click the Columns icon for a table.

Field

Description

COLUMN

Displays the name of the column that is indexed.

NOTE: An encrypted column cannot be indexed. 

DICTIONARY ID

Displays the name of the dictionary used when searching on this column. Dictionaries contain words and their synonyms that are used to resolve abbreviations or to normalize common industry or company-specific abbreviations. Refer to Create Dictionaries for more information.

SEARCHABLE

If enabled, the column is searchable for indexing. 

NOTE: If a field must be marked as a key field in the Stewardship Tier, even though it is not a key field in the underlying table, this check box is disabled.

DUPLICATE DETECTION

If enabled, the column can be searched during the Duplicate Detection process, used to identify and resolve duplicate data. Refer to Find Duplicates Overview in Common help for more information.

KEY

If enabled, the column is the primary key on the table.