IM Relationship Resolution Information Center, Version 4.2

DQM function 255: Name standardization

DQM function 255 generates a name hash, by standardizing the name and building a hash of the standardized parts.

The function generates a name key by standardizing the name and building a name key of the standardized parts. If the source does not already provide a name's gender, and the Gender Characteristic Type parameter is configured in the function's parameter 5, this function creates a new UMF Attribute segment of type "GENDER" and supplies the incoming name's gender (Male/Female).

This function does not have any correction procedures.

If you are using the DQM 160 rule to check a LAST_NAME attribute value length, make sure to run a DQM 255 rule (name standardization) first before running the DQM 160 rule. This will prevent the LAST_NAME length from being increased after the DQM 160 rule (maximum length check) runs, when the other parts are present.

Parameters

Last Name Hash Length
Length of the first part in a two-part key.
First/Mid Hash Length
Length of the second part in a two-part key.
Company Hash Length
Length of the company name used in the key.
Remove Dashes
Should dashes be removed from the key value?
Y
Removes hyphens / dashes from the key. A dash is replaced with space and uses the entire name component in the key. In this case, the names are also stored in the database without dashes. For example:

<LAST_NAME>CASE-JONES</LAST NAME>
<FIRST_NAME>BILL<FIRST_NAME>
becomes
<LFN_HASH>CASJNS  WILM</LFN_HASH>

N
Does not remove hyphens / dashes from the key. Name components (first_name, last_name, or mid_name) are hashed up to the first dash, unless any name component contains a name part that is recognized as Muslim and stored in the DQM_NAME_DICT table. For example:

<LAST_NAME>CASE-JONES</LAST NAME>
<FIRST_NAME>BILL<FIRST_NAME>
becomes
<LFN_HASH>CAS     WILM</LFN_HASH>

C
The setting is only valid if a connector word is present. If the name component has a dash in it,and one part is a connector, then the whole name component is used in the key. If the name component does not have a connector, the system stops hashing at the first dash. For example:

<LAST_NAME>BIN-CASE</LAST NAME>
<FIRST_NAME>JOHN<FIRST_NAME>
becomes
<LFN_HASH>BINCS   JOHN</LFN_HASH>

Gender Characteristic Type
This parameter indicates if the automatic insertion of gender should be disabled or not. This parameter is optional.
NONE
Used to disable automatic insertion of the gender characteristic. Any other value leaves the automatic insertion enabled.

Exception codes

Exception Code Description Severity*
-1 The first and last name values are empty after processing 3


Feedback

Last updated: 2009