SAS Quality Knowledge Base for Contact Information 25
Definitions for the Dutch, Belgium locale are described below.
Case Definitions
Gender Analysis Definitions
Identification Analysis Definitions
Match Definitions
Parse Definitions
Pattern Analysis Definitions
Standardization Definitions
Inherited Definitions
Proper (Address) | ||
---|---|---|
Description | The Proper (Address) case definition propercases addresses. | |
Input | Output | |
Examples | Av. De L'Exposition Universelle 62 B | Avenue de l'Exposition Universelle 62 B |
Louis Socquetstr 47 BOITE3 | Louis Socquetstr 47 Boite3 | |
Remarks |
Proper (Name) | ||
---|---|---|
Description | The Proper (Name) case definition propercases names of individuals. | |
Input | Output | |
Examples | Vincent Moins | Vincent Moins |
Cindy VAN DE WALLE | Cindy van de Walle | |
ANNE-MARIE MOTTE | Anne-Marie Motte | |
Remarks |
Proper (Organization) | ||
---|---|---|
Description | The Proper (Organization) case definition propercases organization names. | |
Input | Output | |
Examples | ABN AMRO BANK N.V | ABN AMRO Bank N.V |
SAS INSTITUE SA/NV | SAS Institute sa/nv | |
Remarks |
Proper (Title) | ||
---|---|---|
Description | The Proper (Title) case definition propercases titles. | |
Input | Output | |
Examples | ANALYSTE-PROGRAMMEUR | Analyste-Programmeur |
lid van directiecomité | Lid van Directiecomité | |
Remarks |
Upper (State/Province) | ||
---|---|---|
Description | The Upper (State/Province) case definition uppercases State/Provinces. | |
Input | Output | |
Examples | Bruxelles | (BRUXELLES) |
(Saint-Nicolas) | (SAINT-NICOLAS) | |
Remarks |
None.
None.
Address | ||
---|---|---|
Description | The Address match definition generates match codes which can be used to cluster records containing addresses. | |
Max Length of Match Code | 19 characters | |
Input | Cluster ID | |
Example 1 | Av. du Castel, 89 B5 | 0 |
Example 2 | Appelboomstraat 10 | 1 |
Example 3 - French variant (misspelled) | Apelbomstraat 10 bus 2 | 1 |
Example 4 | Rue du Pommier 10/2 | 1 |
Example 5 - Dutch variant (misspelled) | Rue du Pomie 10/bte2 | 2 |
Remarks |
Note: The results listed above reflect the default match sensitivity (85). |
|
This definition uses Dutch phonetic reduction to match words with similar
sounds and spellings in Dutch (see examples 2 and 3). Some translation of French
data is performed to enable matching across languages (see example 4). Note that translations cannot be performed for French words that are
misspelled in the input string (see example 5). To match misspellings for French, we recommend setting up a job using a scheme to correct misspellings in French before generating match codes with this definition. For more details, see the Remarks for the Street Name match definition below. |
City | ||
---|---|---|
Description | The City match definition generates match codes which can be used to cluster records containing city names. | |
Max Length of Match Code | 16 characters | |
Input | Cluster ID | |
Examples | HASSELT | 0 |
WATERMAEL-BOISFORT | 1 | |
WATERMAEL-BOITSFORT | 1 | |
WATERMAAL-BOSVOORDE | 1 | |
Remarks |
Note: The results listed above reflect the default match sensitivity (85). |
City - State/Province - Postal Code | ||
---|---|---|
Description | The City - State/Province - Postal Code match definition generates match codes which can be used to cluster records containing last line address information. | |
Max Length of Match Code | 20 characters | |
Input | Cluster ID | |
Examples | 1070 Anderlecht (BRUXELLES) | 0 |
1640 RHODE-SAINT-GENESE | 1 | |
1640 RHODE ST GENESE | 1 | |
1640 SINT-GENESIUS-RODE | 1 | |
Remarks |
Note: The results listed above reflect the default match sensitivity (85). |
Organization | ||
---|---|---|
Description | The Organization match definition generates match codes which can be used to cluster records containing organization names. | |
Max Length of Match Code | 20 characters | |
Input | Cluster ID | |
Examples | M.I.V.B | 0 |
NV SAS Institute SA | 1 | |
ABN AMRO Holding n.v. | 1 | |
ABN AMRO Bank NV | 1 | |
Remarks |
Note: The results listed above reflect the default match sensitivity (85). |
Phone | ||
---|---|---|
Description | The Phone match definition generates match codes which can be used to cluster records containing phone numbers. | |
Max Length of Match Code | 15 characters | |
Input | Cluster ID | |
Examples | 081 987654 | 0 |
02/ 766.07.00 | 1 | |
+32 (0)2 76607-00 | 1 | |
Remarks |
Note: The results listed above reflect the default match sensitivity (85). |
Postal Code | ||
---|---|---|
Description | The Postal Code match definition generates match codes which can be used to cluster records containing postal codes. | |
Max Length of Match Code | 15 characters | |
Input | Cluster ID | |
Examples | 1070 | 0 |
3048 | 1 | |
B-3048 | 1 | |
Remarks |
Note: The results listed above reflect the default match sensitivity (85). |
Street Name | ||
---|---|---|
Description | The Street Name match definition generates match codes which can be used to cluster records containing addresses. | |
Max Length of Match Code | 15 characters | |
Input | Cluster ID | |
Examples | appelboom | 0 |
apelbom | 0 | |
du pommier | 1 | |
du pomie | 1 | |
Remarks |
Note: The results listed above reflect the default match sensitivity (85). |
|
This match definition is intended solely to populate the NLBEL Street Name Match Pre-Processing standardization scheme that can be used as a pre-processing step before the Address match definition. The scheme standardizes French street name word variants to valid words, which will be translated to Dutch (when necessary). |
Address | |||
---|---|---|---|
Description | The Address parse definition parses addresses into a set of tokens. | ||
Output Tokens | Building Name Street Building Number Extension Additional Info |
||
Input | Output | ||
Example 1 | Hertenbergstraat, 6 Bus 1 | Building Name | |
Street | Hertenbergstraat | ||
Building Number | 6 | ||
Extension | Bus 1 | ||
Additional Info | |||
Input | Output | ||
Example 2 | Chaussée de Bruxelles, 5/2a 1er étage | Building Name | |
Street | Chaussée de Bruxelles | ||
Building Number | 5 | ||
Extension | /2a | ||
Additional Info | 1er étage | ||
Remarks |
Address (Full) | |||
---|---|---|---|
Description | The Address (Full) parse definition parses full two-line addresses. | ||
Output Tokens | Building Name Building Number Street Extension Additional Info Postal Code City State/Province |
||
Input | Output | ||
Example 1 | Hertenbergstraat 6/1, 3048 Tervuren | Building Name | |
Building Number | 6 | ||
Street | Hertenbergstraat | ||
Extension | /1 | ||
Additional Info | |||
Postal Code | 3048 | ||
City | Tervuren | ||
State/Province | |||
Input | Output | ||
Example 2 | A. Puesstraat 59 Bus 11, CHAPELLE-LEZ-HERLAIMONT 7160 | Building Name | |
Building Number | 59 | ||
Street | A. Puesstraat | ||
Extension | Bus 11 | ||
Additional Info | 7160 | ||
Postal Code | 7160 | ||
City | CHAPELLE-LEZ-HERLAIMONT | ||
State/Province | |||
Remarks |
Address (Global) | |||
---|---|---|---|
Description |
The Address (Global) parse definition parses addresses into a globally recognized set of tokens. |
||
Output Tokens | Recipient Building/Site Street Extension PO Box Additional Info |
||
Input | Output | ||
Example | Boulevard de la Woluwe 10 B2 | Recipient | |
Building/Site | |||
Street | Boulevard de la Woluwe 10 | ||
Extension | B2 | ||
PO Box | |||
Additional Info | |||
Remarks |
Parse definitions named with the Global keyword use a set of output tokens that is consistent across every locale. Results obtained from these definitions can be stored in the same database fields as the results obtained from definitions of the same name in other locales. |
||
The Address (Global) (v23) parse definition is now deprecated and will be removed in a future release of the QKB. The Address (Global) parse definition has been replaced with a copy of the Address (Global) (v23) definition which takes advantage of the new tokens and updated processing. If you changed your jobs to use Address (Global) (v23) it is suggested that you change them back. |
Address (Global) (v23) | |||
---|---|---|---|
Description | The Address (Global) (v23) parse definition parses addresses into a globally recognized set of tokens. | ||
Output Tokens | Recipient Building/Site Street Extension PO Box Additional Info |
||
Input | Output | ||
Example | Boulevard de la Woluwe 10 B2 | Recipient | |
Building/Site | |||
Street | Boulevard de la Woluwe 10 | ||
Extension | B2 | ||
PO Box | |||
Additional Info | |||
Remarks |
Parse definitions named with the Global keyword use a set of output tokens that is consistent across every locale. Results obtained from these definitions can be stored in the same database fields as the results obtained from definitions of the same name in other locales. |
||
The Address (Global) (v23) parse definition is now deprecated and will be removed in a future release of the QKB. The Address (Global) parse definition has been replaced with a copy of the Address (Global) (v23) definition which takes advantage of the new tokens and updated processing. If you changed your jobs to use Address (Global) (v23) it is suggested that you change them back. |
City - State/Province - Postal Code | |||
---|---|---|---|
Description | The City - State/Province - Postal Code parse definition parses last line address information into a set of tokens. | ||
Output Tokens | Postal Code City State/Province |
||
Input | Output | ||
Example | 3048 Tervuren (BRUSSEL) | Postal Code | 3048 |
City | Tervuren | ||
State/Province | BRUSSEL | ||
Remarks |
City - State/Province - Postal Code (Global) | |||
---|---|---|---|
Description | The City - State/Province - Postal Code (Global) parse definition parses last line address information into a globally recognized set of tokens. | ||
Output Tokens | City State/Province Postal Code Additional Info |
||
Input | Output | ||
Example | B-1080 Sint-Jans-Molenbeek (BRUX.) | City | Sint-Jans-Molenbeek |
State/Province | BRUX. | ||
Postal Code | B-1080 | ||
Additional Info | |||
Remarks |
Parse definitions named with the Global keyword use a set of output tokens that is consistent across every locale. Results obtained from these definitions can be stored in the same database fields as the results obtained from definitions of the same name in other locales. |
Phone | |||
---|---|---|---|
Description | The Phone parse definition parses phone numbers. | ||
Output Tokens | Country Code Area Code Base Number Extension Prefix |
||
Input | Output | ||
Example 1 | Phone: 02/ 7660700 | Country Code | |
Area Code | 02 | ||
Base Number | 7660700 | ||
Extension | |||
Prefix | Phone | ||
Input | Output | ||
Example 2 | FAX +32 2 766-07-00(77) | Country Code | +32 |
Area Code | 2 | ||
Base Number | 766-07-00 | ||
Extension | (77) | ||
Prefix | FAX | ||
Remarks |
Phone (Global) | |||
---|---|---|---|
Description | The Phone (Global) parse definition parses phone numbers into a globally recognized set of tokens. | ||
Output Tokens | Country Code Area Code Base Number Extension Line Type Additional Info |
||
Input | Output | ||
Example 1 | 02 766 07 00 (Phone) | Country Code | |
Area Code | 02 | ||
Base Number | 766 07 00 | ||
Extension | |||
Line Type | (Phone) | ||
Additional Info | |||
Input | Output | ||
Example 2 | GSM: 0032 477 947 193 | Country Code | 0032 |
Area Code | |||
Base Number | 477 947 193 | ||
Extension | |||
Line Type | GSM | ||
Additional Info | |||
Remarks |
Parse definitions named with the Global keyword use a set of output tokens that is consistent across every locale. Results obtained from these definitions can be stored in the same database fields as the results obtained from definitions of the same name in other locales. |
None.
Address | ||
---|---|---|
Description | The Address standardization definition standardizes addresses. | |
Input | Output | |
Examples | AVENUE DE LA CHARMILLE 20 B36 | Avenue de la Chamille 20 B36 |
HENRI DUNANTLAAN 15 BUS 4 | Henri Dunantlaan 15 Bus 4 | |
Remarks |
City | ||
---|---|---|
Description | The City standardization definition standardizes city names. | |
Input | Output | |
Examples | ANNEVOIE-ROUILLON | Annevoie-Rouillon |
KAPELLE-O/D-BOS | Kapelle-op-den-Bos | |
Remarks |
City - State/Province - Postal Code | ||
---|---|---|
Description | The City - State/Province - Postal Code standardization definition standardizes last line address information. | |
Input | Output | |
Examples | BARVAUX-S-OURTHE 6940 | 6940 Barvaux-sur-Ourthe |
9111 BELSELE (SINT-NIKLAAS) | 9111 Belsele (SINT-NIKLAAS) | |
Remarks |
Name | ||
---|---|---|
Description | The Name standardization definition standardizes names of individuals. | |
Input | Output | |
Examples | Cindy VAN DE WALLE | Cindy van de Walle |
Moins, Mm. Marie | Heren Marie Moins | |
Remarks | Name prefixes are translated to Dutch. |
Name (No Translation) | ||
---|---|---|
Description | The Name (No Translation) standardization definition standardizes names of individuals. | |
Input | Output | |
Examples | Cindy VAN DE WALLE | Cindy van de Walle |
Moins, Monsieur Vincent | M Vincent Moins | |
Moins, De heer Vincent | Mijinheer Vincent Moins | |
Remarks | Name prefixes are standardized, but not translated. |
Organization | ||
---|---|---|
Description | The Organization standardization definition standardizes organization names. | |
Input | Output | |
Examples | AKZO NOBEL N.V. | Akzo Nobel nv |
ABN AMRO BANK N.V | ABN AMRO Bank nv | |
Remarks |
Phone | ||
---|---|---|
Description | The Phone standardization definition standardizes phone numbers. | |
Input | Output | |
Examples | +32 2 7660700 | (0)2 766 07 00 |
081/ 223687 | (0)81 22 36 87 | |
Remarks |
Phone (with Country Code) | ||
---|---|---|
Description | The Phone (with Country Code) standardization definition standardizes phone numbers for international use. | |
Input | Output | |
Examples | 02/7660739 | +32 (0)2 766 07 39 |
0032 2 766-07-77 | +32 (0)2 766 07 77 | |
Remarks |
Postal Code | ||
---|---|---|
Description | The Postal Code standardization definition standardizes postal codes. | |
Input | Output | |
Example | B-1070 | 1070 |
Remarks |
In addition to the definitions listed on this page, the Dutch, Belgium locale also inherits all definitions for the Dutch language and all Global definitions.
Documentation Feedback: yourturn@sas.com
|
Doc ID: QKBCI_NLBEL_defs.html |