Formatted name
DM
A formatted name displays for health care providers (HCPs) in the Network user interface on the profile page and in search results.
The formatted_name__v field uses values from several name fields to display a complete name for an HCP. (For HCOs, the corporate_name__v field is used on the profile page and for search results).
Whenever records are loaded in your Network instance or DCRs are submitted, if there isn't a value for the formatted_name__v field, Network will calculate the value using the available name fields. Internal rules are defined to identify the fields that are used to calculate the formatted name for a specific country. For example, most countries use the first name and last name but some countries also include a middle name, prefix (Hr.), or suffix (Jr.) for an HCP.
Example
| Country | prefix__v | medical_degree_1__v | first_name__v | middle_name__v | last_name__v |
|---|---|---|---|---|---|
| Germany | Hr. | Prof. Dr. med. | Felix | Jonas | Meyer |
The formatted name displays on the profile page.
Formatted name calculation rules
Default rule
For countries that do not have specific rules, the default rule is used to calculate the formatted_name__v field for HCPs.
| Country | Name Calculation |
|---|---|
| All countries that do not have country-specific rules | first_name + last_name |
Country-specific rules
Review the fields that each country uses to calculate the formatted_name__v field for HCPs.
Fields
The following HCP fields can be used for formatted name calculations. Not all fields are used for every country.
-
prefix__v
-
medical_degree_1__v
-
first_name__v
-
middle_name__v
-
last_name__v
-
nickname__v
-
suffix__v
-
full_name__v
Field order
The name is calculated using the Veeva (__v) fields in the order that they display in the table below.
The formatted name is recalculated when any of the fields in the country formula change on the HCP.
Language
The Language column identifies the translation language for the reference fields (Prefix and Medical Degree) that are included in the name calculation formula. If a language isn’t specified, the reference data is localized in that country’s language.
| Country | Name Calculation | Language |
|---|---|---|
| Andorra (AD) | prefix + first_name + last_name | Spanish |
| Armenia (AM) | first_name + middle_name + last_name | Russian |
| Austria (AT) | prefix + medical_degree_1 + first_name + middle_name + last_name | German |
| Australia (AU) | prefix + first_name + last_name | English-Australian |
| Azerbaijan (AZ) | first_name + middle_name + last_name | |
| Belarus (BY) | first_name + middle_name + last_name | |
| Belgium (BE) | prefix + first_name + middle_name + last_name | French |
| Brazil (BR) | first_name + middle_name + last_name | |
| Bulgaria (BG) | prefix + medical_degree_1 + first_name + middle_name + last_name | |
| Canada (CA) | first_name + middle_name + last_name | |
| China (CN) | full_name Note: If there is no value for full_name, last_name + first_name is used. |
|
| Czech Republic (CZ) | prefix + first_name + middle_name + last_name | |
| Denmark (DK) | first_name + middle_name + last_name | |
| Finland (FI) | first_name + middle_name + last_name | |
| France (FR) | prefix + first_name + middle_name + last_name | |
| Georgia (GE) | first_name + middle_name + last_name | Russian |
| Germany (DE) | prefix + medical_degree_1 + first_name + middle_name + last_name | |
| Greece (GR) | last_name + first_name | |
| Hong Kong (HK) | full_name
Note: If there is no value for full_name, last_name + first_name is used. |
|
| Hungary (HU) | prefix + last_name + first_name + middle_name | |
| Ireland (IE) | prefix + first_name + middle_name + last_name | English - British |
| Italy (IT) | prefix + first_name + last_name | |
| Japan (JP) | full_name
Note: If there is no value for full_name, last_name + first_name is used. |
|
| Kazakhstan (KZ) | first_name + middle_name + last_name | |
| Kyrgyzstan (KG) | first_name + middle_name + last_name | Russian |
| Liechtenstein (LI) | prefix + medical_degree_1 + first_name + middle_name + last_name | German |
| Luxembourg (LU) | prefix + first_name + middle_name + last_name | French |
| Macao (MO) | full_name Note: If there is no value for full_name, last_name + first_name is used. |
|
| Malaysia (MY) | first_name + middle_name + last_name | |
| Moldova (MD) | first_name + middle_name + last_name | Russian |
| Monaco (MC) | prefix + first_name + middle_name + last_name | French |
| Netherlands (NL) | prefix + first_name + last_name | |
| Norway (NO) | first_name + middle_name + last_name | |
| Poland (PL) | prefix + first_name + middle_name + last_name | |
| Portugal (PL) | prefix + first_name + last_name | |
| Russia (RU) | first_name + middle_name + last_name | |
| Singapore (SG) | prefix + first_name + middle_name + nickname + last_name | English-Australian |
| Slovakia (SK) | prefix + first_name + middle_name + last_name | |
| South Korea (KR) | last_name + middle_name | |
| Spain (ES) | prefix + first_name + last_name | |
| Sweden (SE) | first_name + middle_name + last_name | |
| Switzerland (CH) | prefix + medical_degree_1 + first_name + middle_name + last_name | German |
| Taiwan (TW) | full_name Note: If there is no value for full_name, last_name + first_name is used. |
|
| Tajikistan (TJ) | first_name + middle_name + last_name | Russian |
| Turkey (TR) | first_name + last_name | |
| Turkmenistan (TM) | first_name + middle_name + last_name | Russian |
| Ukraine (UA) | first_name + middle_name + last_name | |
| United Kingdom (GB) | prefix + first_name + middle_name + last_name | English - British |
| United States (US) | first_name + last_name + suffix | |
| Uzbekistan (UZ) | first_name + middle_name + last_name | Russian |
| Vietnam (VN) | last_name + middle_name + first_name |
Chinese names
Chinese full names that contain the special interpunct (.) character are split into the first name and last name fields.
The full name is split at the special (.) character. The last name is the full name value before the interpunct character (.) and the first name is populated with the value after the special character.
| Full Name | Last Name | First Name |
|---|---|---|
| 阿达莱提.夏吾东(Ada Lai Ti. Xia Wu Dong) | 阿达莱提 (Ada Lai Ti) | .夏吾东 (.Xia Wu Dong) |
Note: This does not impact Chinese names that do not contain the special character.