Standard Linking Rules for the United Kingdom (GB) - 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 the United Kingdom (GB).

Description Comparison Routine (modifier) Attribute Name
Business Level 1    
Business_Name busname PR_BUSNAME_RECODED_01
Thorough_Name streets GB_GOUT_THOROUGH_NAME
Thorough_Desc streets GB_GOUT_THOROUGH_DESC
Box

houseno (01)

nonblank

GB_GOUT_POBOX
House_Number houseno (01) GB_GOUT_HOUSE_NUMBER
Apartment1 houseno (01) PR_DWELLING1_NUMBER

House_number

apartment1

substrng

GB_GOUT_HOUSE_NUMBER

PR_DWELLING1_NUMBER

Complex_Name1

spelling

partial1

PR_COMPLEX1_NAME_RECODED
Complex_Name2

spelling

partial1

PR_COMPLEX2_NAME_RECODED
Complex_Type1 partial1 PR_COMPLEX1_TYPE_RECODED
Complex_Type2 partial1 PR_COMPLEX2_TYPE_RECODED

Complex_Name1

Complex_Name2

substrng

PR_COMPLEX1_NAME_RECODED

PR_COMPLEX2_NAME_RECODED

Postal_Code postcode GB_GOUT_POSTAL_CODE
Business Level 2    
Match_Lev1 absolute PR_BUSNAME_RECODED_01
Consumer Level 1    
Surname spelling PR_SURNAME1_RECODED_01
Thorough_Name streets GB_GOUT_THOROUGH_NAME
Thorough_Desc streets GB_GOUT_THOROUGH_DESC
Box

houseno (01)

nonblank

GB_GOUT_POBOX
House_Number houseno (01) GB_GOUT_HOUSE_NUMBER
Apartment1 houseno (01) PR_DWELLING1_NUMBER

House_Number_

Apartment1

substrng

GB_GOUT_HOUSE_NUMBER

PR_DWELLING1_NUMBER

Complex_Name1

spelling

partial1

PR_COMPLEX1_NAME_RECODED
Complex_Name2

spelling

partial1

PR_COMPLEX2_NAME_RECODED
Complex_Type1 partial1 PR_COMPLEX1_TYPE_RECODED
Complex_Type2 partial1 PR_COMPLEX2_TYPE_RECODED

Complex_Name1_

Complex_Name2

 

substrng

PR_COMPLEX1_NAME_RECODED

PR_COMPLEX2_NAME_RECODED

Postal_Code postcode GB_GOUT_POSTAL_CODE
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_Name1_2on frstname PR_GIVEN_NAME1_A
Given_Name2 frstname PR_GIVEN_NAME2_RECODED_01
Gender partial1 (MF) PR_NAME_GENDER_01
Root_Name frstname PR_GIVEN_NAME1_RECODED_01