A new database table or indexed file needs to be defined to hold the SSA-NAME3 Keys and other data. The SSA-NAME3 Keys are 8 bytes in length (by default) and consists of ASCII printable character values.

The minimum number of columns or fields in this new table or file is two - the SSA-NAME3 Key, and a foreign key to point back to the master record where the name or address was sourced from.

It is recommended, however, that for performance optimization, this table should be de-normalized to include the search fields, the data to be used for matching, any data to be used for filtering, and any data to appear on the user’s search results screen. For more information on this, see the

APPLICATION AND DATABASE DESIGN

manual.