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

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Topic type
Overview
Administration
Configuration
Installation
Reference
How Do I
First publish date
2008

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