This table lists the Name and Address Linking Rules for Australia (AU), Canada (CA), Germany (DE), Hong Kong (HK), Italy (IT), and the United States (US).
Note: XX indicates the country code.
Description | Comparison Routine | Attribute Name |
---|---|---|
Business Level 1 | ||
Business_Name | busname | PR_BUSNAME_RECODED_01 |
Street_Name | streets | XX_GOUT_STREET_NAME |
House_Number | houseno | XX_GOUT_HOUSE_NUMBER |
Box_Number | absolute | PR_BOX1_NUMBER |
Postal_Code (Not used for HK) | partial1 | XX_GOUT_POSTAL_CODE |
City | partial1 |
IT_GOUT_POSTAL_CITY (IT) US_GOUT_POSTAL_CITY_NAME (US) XX_GOUT_CITY_NAME (AU, CA, DE, and HK) |
Business Level 2 | ||
Match_Lev1 | absolute | PR_BUSNAME_RECODED_01 |
Consumer Level 1 | ||
Street_Name | streets | XX_GOUT_STREET_NAME |
Surname | spelling | PR_SURNAME1_RECODED_01 |
House_Number | houseno | XX_GOUT_HOUSE_NUMBER |
Apartment | aptno nonblank |
PR_DWELLING1_NUMBER (HK) US_GOUT_SECONDARY_NUMBER (US) XX_GOUT_SUB_BUILDING_VALUE (AU, CA, DE, and IT) |
Box_Number | absolute | PR_BOX1_NUMBER |
Postal_Code (Not used for HK) | partial1 | XX_GOUT_POSTAL_CODE |
City | partial1 |
IT_GOUT_POSTAL_CITY (IT) US_GOUT_POSTAL_CITY_NAME (US) XX_GOUT_CITY_NAME (AU, CA, DE, and HK) |
Hnumb_Apt | substrng |
PR_DWELLING1_NUMBER (HK) US_GOUT_SECONDARY_NUMBER (US) XX_GOUT_SUB_BUILDING_VALUE (AU, CA, DE, and IT) XX_GOUT_HOUSE_NUMBER (all) |
Consumer Level 2 | ||
Sequence_Number | prevent | SEQUENCE_NUMBER |
Name_Prefix | prefix | PR_NAME_PREFIX_RECODED_01 |
Given_Name1 | frstname | PR_GIVEN_NAME1_ORIGINAL_01 |
Given_Name2 |
frstname nonblank |
PR_GIVEN_NAME2_RECODED_01 |
Generation |
gener nonblank |
PR_NAME_GENERATION_RECODED_01 |
Gender |
partial1 (MF) nonblank |
PR_NAME_GENDER_01 |
Root_Name | frstname | PR_GIVEN_NAME1_RECODED_01 |