You are here: Definitions>Dutch Definitions>Dutch, Belgium Definitions

SAS Quality Knowledge Base for Contact Information 25

Dutch, Belgium Definitions

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

Case 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  

Gender Analysis Definitions

None.

Identification Analysis Definitions

None.

Match Definitions

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

NoteNote: 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

NoteNote: 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

NoteNote: 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

NoteNote: 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

NoteNote: 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

NoteNote: 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

NoteNote: 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).

Parse Definitions

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.

Pattern Analysis Definitions

None.

Standardization Definitions

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  

Inherited Definitions

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.