Page 1 of 1

Standardized Name

Posted: Wed Jun 25, 2014 12:45 am
by 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.

Posted: Wed Jun 25, 2014 9:57 am
by 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!

Posted: Wed Jun 25, 2014 11:34 pm
by U
Thank you. We've been able to get that to work as suggested.