Configuring Database Keys

Database keys are used throughout RPI to define the manner in which records are deduplicated. configuration of database keys is carried out in the Database Keys configuration interface.

All existing database keys are presented in alphabetical order by name. The following editable columns are displayed:

• Name: the name of the database key, by which it is referenced throughout RPI.  Name is a text field, may be a maximum of 100 characters and is mandatory.  Name must be unique across all database keys.

• Column Name: the name of the database column that is referenced by the database key.  Column name is a text field, may be a maximum of 100 characters and is mandatory.  It may not contain any characters that are unsuitable for database use.

• State: one of Unchanged, Added, Edited or Deleted.