Standard Linking Rules for Countries Supported by the Custom 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 these Custom Postal Matcher countries: Belgium (BE), Switzerland (CH), Spain (ES), France (FR), Luxembourg (LU), Malaysia (MY), Netherlands (NL), Portugal (PT), and Singapore (SG).

Note: XX indicates the country code.
Description Comparison Routine (modifier) Attribute Name
Business Level 1    
Business_Name busname PR_BUSNAME_RECODED_01
Street_Name streets TQ_GOUT_STREET_NAME
House_Number houseno TQ_GOUT_HOUSE_NUMBER
Box_Number absolute PR_BOX1_NUMBER
Postal_Code partial1 TQ_GOUT_POSTAL_CODE
City partial1 TQ_GOUT_POSTAL_CITY
Business Level 2    
Match_Lev1 absolute PR_BUSNAME_RECODED_01
Consumer Level 1    
Street_Name streets TQ_GOUT_STREET_NAME
Surname spelling PR_SURNAME1_RECODED_01
House_Number houseno TQ_GOUT_HOUSE_NUMBER
Apartment

aptno

nonblank

TQ_GOUT_SUB_BUILDING_VALUE
Box_Number absolute PR_BOX1_NUMBER
Postal_Code partial1 TQ_GOUT_POSTAL_CODE
City partial1 TQ_GOUT_POSTAL_CITY
Hnumb_Apt substrng

TQ_GOUT_SUB_BUILDING_VALUE

TQ_GOUT_HOUSE_NUMBER

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