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 |