Using the REDEFINES-WORD-LIST Table - VeriMove - 4.0

VeriMove Guide

Product type
Software
Portfolio
Verify
Product family
Data Quality - Postals
Product
VeriMove
Version
4.0
Language
English
Product name
VeriMove
Title
VeriMove Guide
Copyright
2023
First publish date
2002
Last updated
2024-05-15
Published on
2024-05-15T01:25:15.950712

VeriMove uses the REDEFINES-WORD-LIST table during Business Name Matching to convert common business abbreviations to standard accepted full business words to bridge the gap between how business names are stored in your input file and how the USPS stores business names in the NCOALink database.

For example, a small portion of the REDEFINES-WORD-LIST table is shown below. In this example, if the input file contains "ATTNY", the Business Name Matching process internally converts "ATTNY" to "ATTORNEY" to determine a Business Name Match against the NCOALink database.

This conversion is performed for the sole purpose of determining a Business Name Match. This process does not change your input file or job output and does not extend beyond the scope of the Business Name Matching process.



Figure 1. Editing the REDEFINES-WORD-LIST Table

To edit the REDEFINES-WORD-LIST table:

  1. Add the abbreviated word from your input file in the first column. For any words less than 20 characters in length, you must insert blank spaces as placeholders so that every word entered in the table occupies the full 20 characters allowed. Do not exceed 20 characters.

    For example:

    Table Entry Description
    ACCOUNTING<End of Line> This entry is incorrect because it does not fill the entire 20 characters allowed.
    ACCOUNTING..........<End of Line> This entry is correct. This table entry fills all 20 characters. The last 10 characters are spaces.
  2. Add the standard accepted full business word to the second column. For any words less than 20 characters in length, you must insert blank spaces as placeholders so that every word entered in the table occupies the full 20 characters allowed. Do not exceed 20 characters.
  3. After adding entries, sort the table alphabetically in ascending order.
    Note: The Business Name Matching tables are copied to the "Tables" directory during VeriMove installation. Each time you explode the NCOA files to your database location, these files are copied from the "Tables" directory to your database location. Subsequent VeriMove installations will overwrite these tables with the tables VeriMove used to certify with the USPS. If you customize these tables, be sure to backup these files before installing a new VeriMove release. After installing a new VeriMove release, replace the installed VeriMove USPS-certified tables with the backed up versions of your customized tables.