French Definitions

In the SAS Quality Knowledge Base, the French definitions are shared by all French-language locales. Shared French definitions 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 (Name)
Description	The Case definition for Proper (Name) propercases names of individuals.
	Input	Output
Examples	MONSIEUR JEAN-JACQUES LANVIN	Monsieur Jean-Jacques Lanvin
	mme de la tour	Mme de la Tour
	JAN VAN DEN BRINK	Jan van den Brink
Remarks	Prepositions are lowercased.

Proper (Organization)
Description	The Case definition for Proper (Organization) propercases organization names.
	Input	Output
Examples	Bnp Paribas	BNP Paribas
	La maison de lucy	La Maison de Lucy
	SNCF	SNCF
Remarks	Acronyms are uppercased, while prepositions are lowercased.

Upper (Legal Form)
Description	The Case definition for Upper (Legal Form) uppercases organization legal forms.
	Input	Output
Examples	cie	CIE
	ei	EI
	gmbh	GmbH
	SPA	SpA
Remarks	The Case definition for Upper (Legal Form) is designed for use on the Legal Form token only. Legal forms are generally uppercased, but with exceptions like GmbH and SpA.

Upper (Organization)
Description	The Case definition for Upper (Organization) uppercases organization names.
	Input	Output
Examples	Bnp Paribas	BNP PARIBAS
	La Maison de Lucy	LA MAISON DE LUCY
	sncf	SNCF
	radin.com	radin.com
Remarks	Organization names are uppercased, unless they are web site names.

Gender Analysis Definitions

Name
Description	The Gender Analysis definition for Name determines an individual's gender based on a prefix or name.
Possible Outputs	M F U
	Input	Output
Examples	Mme Anne Chaumont	F
	Marc Daverat	M
	Dr Weissmann	U
	Jean-Marie Weber	M
	Marie-Jean Weber	F
Remarks

Identification Analysis Definitions

Field Name
Description	The Field Name identification analysis definition identifies database column names.
Possible Outputs	NAME ORGANIZATION ADDRESS CITY STATE/PROVINCE POSTALCODE COUNTRY PHONE EMAIL DATE UNKNOWN URL GENDER MATCHCODE PERSONAL_ID ORGANIZATION_ID GENERIC_ID COUNTY MARITAL_STATUS
	Input	Output
Examples	Company Name	ORGANIZATION
	NOM D'ENTREPRISE	ORGANIZATION
	Address	ADDRESS
	boite aux lettres	ADDRESS
	Telephone	PHONE
	Numero Telephone Mobile	PHONE
Remarks	This definition is recommended to determine the type of data stored in a database column based on the name of the column.
Remarks	The Field Name (v23) identification analysis definition is now deprecated and will be removed in a future release of the QKB. The Field Name identification analysis definition has been replaced with a copy of the Field Name (v23) definition which takes advantage of updated processing. If you changed your jobs to use the Field Name (v23) definition it is suggested that you change them back.

Field Name (v23)
Description	The Field Name (v23) identification analysis definition identifies database column names.
Possible Outputs	NAME ORGANIZATION ADDRESS CITY STATE/PROVINCE POSTALCODE COUNTRY PHONE EMAIL DATE UNKNOWN URL GENDER MATCHCODE PERSONAL_ID ORGANIZATION_ID GENERIC_ID COUNTY MARITAL_STATUS
	Input	Output
Examples	Company Name	ORGANIZATION
	NOM D'ENTREPRISE	ORGANIZATION
	Address	ADDRESS
	boite aux lettres	ADDRESS
	Telephone	PHONE
	Numero Telephone Mobile	PHONE
Remarks	This definition is recommended to determine the type of data stored in a database column based on the name of the column.
Remarks	The Field Name (v23) identification analysis definition is now deprecated and will be removed in a future release of the QKB. The Field Name identification analysis definition has been replaced with a copy of the Field Name (v23) definition which takes advantage of updated processing. If you changed your jobs to use the Field Name (v23) definition it is suggested that you change them back.

Name/Organization
Description	The Name/Organization identification analysis definition determines whether a string represents the name of an individual or an organization.
Possible Outputs	NAME ORGANIZATION NAME/ORGANIZATION UNKNOWN
	Input	Output
Examples	Monsieur Henri Dumont	NAME
	Henri Dumont SA	ORGANIZATION
	SNCF	ORGANIZATION
	Monsieur Rejany	NAME
	Monsieur Rejany, SOLVEO	NAME/ORGANIZATION
	Rejany	UNKNOWN
Remarks

Match Definitions

Field Name
Description	The Field Name match definition generates match codes which can be used to cluster records containing database field names.
Max Length of Match Code	15 characters
	Input	Cluster ID
Examples	Company Name	0
	NOM D'ENTREPRISE	0
	boite aux lettres	1
	Address	1
	Telephone	2
	Numero Telephone Mobile	2
Remarks	This definition should be used to find potential matches between database column names. Note: The results listed above reflect the default match sensitivity (85).

Name
Description	The Name match definition generates match codes which can be used to cluster records containing names of individuals.
Max Length of Match Code	26 characters
	Input	Cluster ID
Examples	Anne Christin Chaumont	0
	Anne Charlotte Chaumont	0
	Docteur Anne Christin Chaumont	0
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	35 characters
	Input	Cluster ID
Examples	La banque postale	0
	Banque postale, la	0
	La lyonnaise de banque	1
Remarks	Note: The results listed above reflect the default match sensitivity (85).

Parse Definitions

Name
Description	The Parse definition for Name parses names of individuals into a set of tokens.
Output Tokens	Prefix Given Name Family Name Suffix Title/Additional Info
	Input	Output
Example 1	Monsieur Jean Pierre Lacombe	Prefix	Monsieur
		Given Name	Jean Pierre
		Family Name	Lacombe
		Suffix
		Title/Additional Info
	Input	Output
Example 2	M J Pierre Lacombe Jr, PDG	Prefix	M
		Given Name	J Pierre
		Family Name	Lacombe
		Suffix	Jr
		Title/Additional Info	PDG
	Input	Output
Example 3	Mlle Floriane de la Tour, Directrice Ressources Humaines	Prefix	Mlle
		Given Name	Floriane
		Family Name	de la Tour
		Suffix
		Title/Additional Info	Directrice Ressources Humaines
Remarks

Name (Global)
Description	The Parse definition for Name (Global) parses names of individuals into a globally recognized set of tokens.
Output Tokens	Prefix Given Name Middle Name Family Name Suffix Title/Additional Info
	Input	Output
Example 1	Monsieur Jean Pierre Lacombe	Prefix	Monsieur
		Given Name	Jean Pierre
		Middle Name
		Family Name	Lacombe
		Suffix
		Title/Additional Info
	Input	Output
Example 2	M J Pierre Lacombe Jr, PDG	Prefix	M
		Given Name	J Pierre
		Middle Name
		Family Name	Lacombe
		Suffix	Jr
		Title/Additional Info	PDG
	Input	Output
Example 3	Mlle Floriane de la Tour, Directrice Ressources Humaines	Prefix	Mlle
		Given Name	Floriane
		Middle Name
		Family Name	de la Tour
		Suffix
		Title/Additional Info	Directrice Ressources Humaines
Remarks	The Middle Name token is not populated in this definition. 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.

Name (Multiple Name)
Description	The Parse definition for Name (Multiple Name) parses names of multiple individuals into a set of tokens.
Output Tokens	Name 1 Name 2
	Input	Output
Example 1	Valérie Brua et Marc Daudin	Name 1	Valérie Brua
Example 1	Valérie Brua et Marc Daudin	Name 2	Marc Daudin
	Input	Output
Example 2	M et Mme Daudin Marc	Name 1	M Marc Daudin
Example 2	M et Mme Daudin Marc	Name 2	Mme Daudin
	Input	Output
Example 3	Valérie & Marc Daudin	Name 1	Valérie Daudin
Example 3	Valérie & Marc Daudin	Name 2	Marc Daudin
Remarks

Name/Organization
Description	The Parse definition for Name/Organization parses names and organizations into a set of tokens.
Output Tokens	Name Organization
	Input	Output
Example 1	Monsieur Jean Pierre Lacombe	Name	Monsieur Jean Pierre Lacombe
Example 1	Monsieur Jean Pierre Lacombe	Organization
	Input	Output
Example 2	SNCF	Name
Example 2	SNCF	Organization	SNCF
	Input	Output
Example 3	Monsieur Jean Pierre Lacombe, SNCF	Name	Monsieur Jean Pierre Lacombe
Example 3	Monsieur Jean Pierre Lacombe, SNCF	Organization	SNCF
Remarks

Organization
Description	The Parse definition for Organization parses organization names into a set of tokens.
Output Tokens	Name Legal Form Site Additional Info
	Input	Output
Example 1	SOLVEO SA, Lyon	Name	SOLVEO
		Legal Form	SA
		Site	Lyon
		Additional Info
	Input	Output
Example 2	SOLVEO, Lyon, Service Informatique	Name	SOLVEO
		Legal Form
		Site	Lyon
		Additional Info	Service Informatique
	Input	Output
Example 3	SOLVEO Paris	Name	SOLVEO Paris
		Legal Form
		Site
		Additional Info
Remarks

Organization (Global)
Description	The Parse definition for Organization (Global) parses organization names into a globally recognized set of tokens.
Output Tokens	Name Legal Form Site Additional Info
	Input	Output
Example 1	SOLVEO SA, Lyon	Name	SOLVEO
		Legal Form	SA
		Site	Lyon
		Additional Info
	Input	Output
Example 2	SOLVEO, Lyon, Service Informatique	Name	SOLVEO
		Legal Form
		Site	Lyon
		Additional Info	Service Informatique
	Input	Output
Example 3	SOLVEO Paris	Name	SOLVEO Paris
		Legal Form
		Site
		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

Country
Description	The Standardization definition for Country standardizes country names.
	Input	Output
Examples	etats-unis	États-Unis
Examples	GÉORGIE	Géorgie
Remarks

Country (ISO 2 Char)
Description	The Standardization definition for Country (ISO 2 Char) standardizes country names into the 2-character ISO standard.
	Input	Output
Examples	etats-unis	US
Examples	GÉORGIE	GE
Remarks

Country (ISO 3 Char)
Description	The Standardization definition for Country (ISO 3 Char) standardizes country names into the 3-character ISO standard.
	Input	Output
Examples	etats-unis	USA
Examples	GÉORGIE	GEO
Remarks

Name
Description	The Standardization definition for Name standardizes names of individuals.
	Input	Output
Examples	Docteur Marc Weissmann Junior	Dr Marc Weissmann, Jr
Examples	Mademoiselle Jacqueline DE LA SALLE, Directrice de centre	Mlle Jacqueline de la Salle, Directrice de Centre
Remarks

Organization
Description	The Standardization definition for Organization standardizes organization names.
	Input	Output
Examples	Secam Entreprise Individuelle, alby	Secam EI, Alby
Examples	Kaufman and Broad SA Marseille	Kaufman & Broad SA, Marseille
Remarks	Some organization names, especially those containing many words, might require setting the Parse Resource Limit to MEDIUM to parse correctly. If the parsing is not successful, this impacts the output of the Organization definition.

Organization (Upper)
Description	The Standardization definition for Organization (Upper) standardizes and uppercases organization names.
	Input	Output
Examples	Secam Entreprise Individuelle, alby	SECAM EI, ALBY
	Kaufman and Broad SA Marseille	KAUFMAN & BROAD SA, MARSEILLE
	radin.com	radin.com
Remarks	The Standardization definition for Organization (Upper) uppercases all organization names except those that are web site names. Some organization names, especially those containing many words, might require setting the Parse Resource Limit to MEDIUM to parse correctly. If the parsing is not successful, this impacts the output of the Organization (Upper) definition.

Inherited Definitions

In addition to the definitions listed on this page, all French-language locales also inherit all Global definitions.