Standardized Name

[U]

Can someone please explain how a standardized version gets into the {MatchFirstName} field?

For example, in USNAME rule set, first name BILL appears as WILLIAM in MatchFirstName, yet in the classification table the entry for BILL is "BILL BILL F". Where did the WILLIAM come from? There is no classification override.

We're looking to provide standardized versions of some other names, but can't work out how to implement it. COPY_A is very limited, because the first name can appear anywhere in the input string.

Thank you for your time.

[rjdickson]

Hi,

The 'MatchFirstName' comes from the USFIRSTN table. The second column in that table has the gender (first character) and the match first name. For example

Code: Select all

BILL MWILLIAM

This table is also used to assign gender, so any names that do not have (or do not need) a different match first name will have the following format:

Code: Select all

WILLIAM M

You can add/modify entries in a copy this table as you see fit.

I hope this helps!

[U]

Thank you. We've been able to get that to work as suggested.