Standard Linking Rules for Brunei Darussalam (BN) - 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 Brunei Darussalam (BN).

Description Comparison Routine Attribute Name
Business Level 1    
Business_Name busname PR_BUSNAME_RECODED_01
Street_Name streets PR_BEST_STREET_NAME
House_Number houseno PR_BEST_STREET_NUMBER
Box_Number absolute PR_BOX1_NUMBER
City partial1 PR_CITY_NAME_RECODED
Apartment 1

aptno

nonblank

PR_DWELLING1_NUMBER
Apartment 2

aptno

nonblank

PR_DWELLING2_NUMBER
Apartment 3

aptno

nonblank

PR_DWELLING3_NUMBER
Complex_Name streets PR_COMPLEX1_NAME_RECODED
Apt1_Housenum substrng

PR_DWELLING1_NUMBER

PR_BEST_STREET_NUMBER

Apt2_Apt3 substrng

PR_DWELLING2_NUMBER

PR_DWELLING3_NUMBER

Apt3_Apt2 substrng

PR_DWELLING3_NUMBER

PR_DWELLING2_NUMBER

Business Level 2    
Match_Lev1 absolute PR_BUSNAME_RECODED_01
Consumer Level 1    
Street_Name streets PR_BEST_STREET_NAME
House_Number houseno PR_BEST_STREET_NUMBER
Apartment 1

aptno

nonblank

PR_DWELLING1_NUMBER
Apartment 2

aptno

nonblank

PR_DWELLING2_NUMBER
Apartment 3

aptno

nonblank

PR_DWELLING3_NUMBER
Complex_Name streets PR_COMPLEX1_NAME_RECODED
Box_Number partial1 PR_BOX1_NUMBER
City partial1 PR_CITY_NAME_RECODED
Apt1_Apt2 substrng

PR_DWELLING1_NUMBER

PR_DWELLING2_NUMBER

Apt1_Apt3 substrng

PR_DWELLING1_NUMBER

PR_DWELLING3_NUMBER

Apt2_Apt1 substrng

PR_DWELLING2_NUMBER

PR_DWELLING1_NUMBER

Apt3_Apt1 substrng

PR_DWELLING3_NUMBER

PR_DWELLING1_NUMBER

Apt2_Apt3 substrng

PR_DWELLING2_NUMBER

PR_DWELLING3_NUMBER

Apt3_Apt2 substrng

PR_DWELLING3_NUMBER

PR_DWELLING2_NUMBER

Postal_Code partial2 PR_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_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
Surname spelling PR_SURNAME1_RECODED_01
Given_Name1_Surname substrng

PR_GIVEN_NAME1_RECODED_01

PR_SURNAME1_RECODED_01

Surname_Given_Name1 substrng

PR_SURNAME1_RECODED_01

PR_GIVEN_NAME1_RECODED_01

Given_Name1_Given_Name2 substrng

PR_GIVEN_NAME1_RECODED_01

PR_GIVEN_NAME2_RECODED_01

Given_Name2_Given_Name1 substrng

PR_GIVEN_NAME2_RECODED_01

PR_GIVEN_NAME1_RECODED_01