Standard Linking Rules for Brazil (BR) - 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 Brazil (BR).

Description Comparison Routine (modifier) Attribute Name
Business Level 1    
Business_Name busname PR_BUSNAME_RECODED_01
Street_Name streets GA_GOUT_STREET_NAME
House_Number houseno GA_GOUT_HOUSE_NUMBER
Box_Number absolute PR_BOX1_NUMBER
Postal_Code partial1 GA_GOUT_POSTAL_CODE
City partial1 GA_GOUT_POSTAL_CITY
Business Level 2    
Match_Lev1 absolute PR_BUSNAME_RECODED_01
Consumer Level 1    
Street_Name streets GA_GOUT_STREET_NAME
Surname spelling PR_SURNAME1_RECODED_01
House_Number houseno GA_GOUT_HOUSE_NUMBER
Apartment

aptno

nonblank

GA_GOUT_SUB_BUILDING
Box_Number absolute PR_BOX1_NUMBER
Postal_Code partial1 GA_GOUT_POSTAL_CODE
City partial1 GA_GOUT_POSTAL_CITY
Hnumb_Apt substrng

GA_GOUT_SUB_BUILDING

GA_GOUT_HOUSE_NUMBER

Consumer Level 2    
Sequence_Number prevent SEQUENCE_NUMBER
Given_Name1 frstname

PR_GIVEN_NAME1_RECODED_01

Given_Name2

frstname

PR_GIVEN_NAME2_RECODED_01
Given_Name3 frstname PR_GIVEN_NAME3_RECODED_01
Given_Name4 frstname PR_GIVEN_NAME4_RECODED_01
Gender

partial1 (MF)

PR_NAME_GENDER_01
Given_Name2_Given_Name3 substrng

PR_GIVEN_NAME2_RECODED_01

PR_GIVEN_NAME3_RECODED_01

Given_Name2_Given_Name4 substrng

PR_GIVEN_NAME2_RECODED_01

PR_GIVEN_NAME4_RECODED_01

Given_Name3_Given_Name4 substrng

PR_GIVEN_NAME3_RECODED_01

PR_GIVEN_NAME4_RECODED_01

Given_Name2_Given_Name2 substrng

PR_GIVEN_NAME2_RECODED_01

PR_GIVEN_NAME2_RECODED_01

Given_Name3_Given_Name3 substrng

PR_GIVEN_NAME3_RECODED_01

PR_GIVEN_NAME3_RECODED_01

Given_Name4_Given_Name4 substrng

PR_GIVEN_NAME4_RECODED_01

PR_GIVEN_NAME4_RECODED_01

Given_Name2_Surname substrng

PR_GIVEN_NAME2_RECODED_01

PR_SURNAME1_RECODED_01

Given_Name3_Surname substrng

PR_GIVEN_NAME3_RECODED_01

PR_SURNAME1_RECODED_01

Given_Name4_Surname substrng

PR_GIVEN_NAME4_RECODED_01

PR_SURNAME1_RECODED_01