Standard Linking Rules for Countries Supported by the Independent Postal Matcher - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

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