Formatted name


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 first_name__v last_name__v
All countries that do not have country-specific rules

Country-specific rules

Review the fields that each country uses to calculate the formatted_name__v field for HCPs.

Field order

The name is calculated using the Veeva (__v) fields in the order that they display in the table below. For a few countries, the field order is not the same as they display in the table. For these countries, the number beside the field indicates the order that it is used in the name calculation.

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 prefix medical_degree_1 first_name middle_name nickname last_name full_name suffix Language
Default rule              
Andorra           Spanish
Armenia            
Austria       German
Australia            
Azerbaijan            
Belarus            
Belgium         French
Brazil            
Bulgaria        
China                
Czech Republic          
Denmark            
Finland            
France          
Georgia            
Germany        
Greece     (2)     (1)      
Hong Kong                
Hungary (1)   (3) (4)   (2)      
Ireland         English - British
Italy            
Japan                
Kazakhstan            
Kyrgyzstan            
Liechtenstein       German
Luxembourg         French
Macao                
Moldova            
Monaco         French
Netherlands              
Norway            
Poland          
Portugal            
Russia            
Singapore       English-Australian
Slovakia          
South Korea       (2)   (1)      
Spain            
Sweden            
Switzerland       German
Taiwan                
Tajikistan            
Turkey              
Turkmenistan            
Ukraine            
United Kingdom         English - British
United States            
Uzbekistan            

Note: (China, Hong Kong, Japan, Macao, and Taiwan) If there is no value for full_name__v, Network uses last_name__v and first_name__v (in that order) to calculate the formatted 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 enhancement does not impact Chinese names that do not contain the special character.