About the data model

AD
DM

Network MDM's flexible data model consists of domains, objects, and fields and their relationship to one another.

Key topics

  • Network MDM data model - Manage domains, objects, fields (legacy and CDA), and reference data.

  • Common Data Architecture for Life Sciences (CDA) - View and manage the HCP and HCO kernels. The kernels include entities (HCPs, HCOs, Addresses), attributes (fields), and picklists (reference data).

  • Custom domains - Create objects to store data that is essential to your business that is not part of the standard Network MDM data model.

Types of data model entities

  • Data domains - A logical grouping of objects for a specific area of activity or knowledge.

    Examples: Customer Master (default domain), Payer Master (custom domain), Product Master (custom domain)

  • Main objects - Objects that are independent of other objects. Main objects are directly associated to a data domain.

    Examples: Veeva standard objects - HCPs and HCOs, Custom objects - Employee, Payer, Plan, Product.

  • Sub-objects - Objects that must be associated to main objects. A sub-object cannot exist on its own.

    Examples: Veeva standard objects - Address and License, Custom sub-objects - Certification, Training.

  • Relationship objects - A many-to-many relationship between main objects.

    Examples: Veeva standard object - Parent HCO, Custom relationship objects - Employee-Employee, Payer-Plan, Product-Brand.

View the data model

In the Admin console, click Data Model > Data Domains.

The Data Domains page displays, showing the default Custom Master domain and any custom domains that you have created in your Network MDM instance.

Entity relationships

The following diagram illustrates the relationships between Network MDM objects:

Standard fields

Standard fields are fields in the Network MDM data model that are provided by Veeva. These fields have a suffix of "__v".

Field management

Most standard fields are managed by Veeva OpenData. These fields contain Veeva OpenData data and they are managed by Veeva OpenData data stewards.

Some CDA fields include the "__v" suffix but they are customer-managed. For the list of CDA fields and their field owner, see CDA kernels.

New standard fields

Every Veeva object and custom object is assigned a set of Veeva standard fields.

Veeva OpenData periodically adds standard fields for countries. Include the fields in your subscriptions so you receive the data. For more information, see Adding Veeva OpenData fields.

Viewing fields

The list of standard fields available varies by country.

To view the fields on an object:

  1. Open a data domain and select an object to open its configuration page.

  2. The Fields section displays all fields assigned to the object.

    Filter the list by country, by standard (__v) or custom fields (__c), or by type.

    To view enabled fields only, clear Show disabled fields.

  3. Review the fields for the object.

    The following information is available for each field:

    • Name and Label
    • Field Access - (Restricted or available to All Users)
    • Type - The type of field, for example, Reference Type, Text, or Checkbox.
    • Reference Type - The name of the associated reference type. Populated only for reference type fields.
    • Status
      • Disabled - The field if off and cannot be enabled.
      • Disabled - The field is off and can be enabled.
      • Enabled - The field is on and can be turned off.
      • Enabled - The field is on by default and cannot be turned off.

      For more information, see Enabling data model fields.

  4. Click the field name to open it and view more details.

About field lengths

Some field types have a maximum field length defined. Field lengths are suggestions only; they are not enforced in Network MDM.

Updates to OpenData managed field values

Changes to standard fields managed by Veeva OpenData are routed to Veeva data stewards for verification.

Updates to locally managed standard fields

Customer data can be loaded into the Veeva standard fields (__v) if the fields are not used by Veeva OpenData in the country.

Changes to customer data in Veeva fields are routed to customer data stewards to maintain.

For more information, see Enable data model fields.

Custom fields

You can extend the Network MDM data model by adding custom fields to any Veeva object or custom object.

Custom fields have a suffix of "__c". They can be configured as reference type fields to use a standard list of values.

Field management

Veeva OpenData does not provide data for custom fields; they are private to your Network MDM instance and are not shared with Veeva OpenData.

When you create a custom field, you can indicate whether changes initiated using the Network MDMAPI are accepted without data steward review, or must be reviewed by a data steward prior to the update being applied to the record.

For more information, see Creating custom fields.

Reference data types

Reference types enable you to use predefined lists of values (reference codes) for fields. When you add or edit records, select a field value from the list of accepted values (reference codes).

Network MDM includes reference codes and descriptions for reference data fields, localized for supported regions.

Custom reference types and codes

You can create reference types for your business needs and add custom codes.

Custom reference codes can also be added to Veeva reference types.

Example

The Veeva reference type, HCPEducationLevel, contains code values for College (C), Doctorate (D), Medical School (MS), and so on. You can add a custom value if a degree or school isn't available in the list.

Naming convention

  • Custom codes added to Veeva reference types include the "__c" suffix. For example, T__c.

  • Custom codes added to custom reference types do not include the "__c" suffix.

Groups of fields

Some standard fields (__v) in the Network MDM data model are grouped within a set; for example, Specialty, Phones, and Focus Areas.

In Network MDM features where you can filter or search for data within fields, it's useful to work with the fields as a group instead of having to choose individual fields. For example, if you are searching for HCPs that specialize in stroke medicine, you can select the All Focus Areas group of fields so Network MDM searches the 36 fields in that set: (hcp_focus_area_1__v to hcp_focus_area_36__v).

Available field groups

Group Name Data Model Fields Included
All Accreditations hco_accreditation_area_1__v through hco_accreditation_10__v

Note: These fields are not grouped for Japan.
All Address Lines (reporting only) address_line_1__v through address_line_3__v
All Alternate Names alternate_name_1__v through alternate_name_10__v
All Credentials credentials_1__v through credentials_10__v
All Delivery Address Lines (reporting only) delivery_address_line__v through delivery_address_line_3__v
All Emails email_1__v through email_10__v
All Faxes fax_1__v through fax_10__v
All HCO Focus Areas hco_focus_area_1__v through hco_focus_area_10__v
All HCP Focus Areas hcp_focus_area_1__v through hcp_focus_area_36__v
All Medical Degrees medical_degree_1__v through medical_degree_5__v
All National IDs national_id__v through national_id_5__v
All Old CIP ID End Dates cip_id_old_end_date__v through cip_old_end_date_5__v
All Old CIP IDs cip_id_old__v through cip_id_old_5__v
All Phones phone_1__v through phone_10__v
All Specialties specialty_1__v through specialty_10__v
All URLs URL_1__v through URL_2__v

Typically, grouped fields are enabled or disabled as a set, but there are some exceptions. For more information, see Enabling grouped fields.

Features that use field sets

Grouped field sets are available in the following features:

  • Profile validation rules - all grouped field sets
  • Advanced search - all grouped field sets
  • Ad hoc queries (includes data maintenance jobs and reporting) - all grouped field sets (including All Address Lines and All Delivery Address Lines). For more information, see Reporting on fields sets.
  • Veeva OpenData Subscriptions - All Specialties only.
  • Target subscriptions - all grouped field sets
  • Search API - all grouped field sets
  • Hierarchy Explorer widget - All Specialties, All Medical Degrees, and All HCP Focus Areas only.

Network ID field (vid__v)

The primary key for each object in a Network MDM instance is called the Network ID (vid__v).

The vid__v key contains a unique, automatically generated, 18-digit value for each object in a Network MDM instance. The primary key might not be unique outside of a instance; two Network MDM instances could potentially have the same vid__v value, but for different objects.

The master_vid__v field is only populated for records in Veeva OpenData; the field is null for records that are locally managed.

Extended data model

The data model supports using Veeva standard fields (__v) for any country to manage local or third-party data. Data can be loaded into __v fields without a Veeva OpenData subscription, or in countries where the Veeva OpenData team does not manage that field.

Support for using __v fields in the extended data model includes the following considerations:

  • Administrators can enable __v fields and load customer-owned data when the fields are not used by Veeva OpenData in the country, even with a Veeva OpenData subscription enabled.
  • Changes to __v fields are routed to the appropriate data stewards, either customer or Veeva OpenData, to maintain.

  • If a field in a set is enabled, for example specialty_1__v, all fields in the set are enabled (specialty_1__v through specialty_10__v).

    There are some exceptions. For more information, see Enabling grouped fields.

  • Management of fields for the country is reflected by the color of the field label on record profiles:

    • Orange - Managed by Veeva OpenData.

    • Gray - Managed by customers (green, in China).

    • Blue - Managed by a third-party data provider.

  • Management of the fields is reflected on field configuration (Data Model).

    There are separate sections to show the field ownership for countries:

    • Managed by a Master Data Source - The field is managed by a OpenData or a third party source for the defined countries.

    • Managed by Customer - The field is managed locally for the defined countries.

Tip: If you add a field that is not used by Veeva OpenData in that country, the field is not included in the profile layout for that country. For help adding the field to the layout, see Configuring profile layouts.

About data privacy

You can extend the standard Network MDM data modelClosed The organization of Network data, including objects, individual fields, field attributes, and data relationships. by adding custom fieldsClosed Controls (similar to SQL queries) for using available keywords, tables, fields, and operators to analyze data in a Network instance. in your Network instance. Custom fields are always private and are never sent to Veeva OpenData. A custom field might be used for storing an ID field for matched records from a third-party proprietary data source.

You can load data into your Network MDM instance from other systems (internal data sources or licensed third-party data sources) to match and link that data with Veeva OpenData data.

When you add a data source in your instance, you can explicitly set a Proprietary flag to indicate whether sharing the data with Veeva OpenData will violate third-party agreements (TPAs). If a source is flagged as containing proprietary data, any add or change requests created through an API call to Network MDM will not be forwarded to Veeva OpenData.

For more information about third party and locally managed data, see Sources of data.

Physical environments

Veeva OpenData is in a separate database schema from the Network MDM Customer Master tenants, and cannot be directly accessed by a tenant. Communication between Veeva OpenData and a Network MDM Customer Master tenant can only happen through a change request API call.

Communication between Veeva OpenData and a customer instance only occurs when Veeva OpenData subscriptions are enabled for the instance, and includes the following types of communication:

  • Veeva OpenData Subscriptions
  • the change request process
  • search and download from Veeva OpenData through the Network MDM UI

Export the data model

The data model can be exported locally as a Microsoft Excel® file from each data domain. Country filters applied in the UI also apply to the data model export.

  • To export, select a data domain and click Export Data Model.

The data model downloads to your local file system with the following naming convention "Data Domain as of <date>.xlsx".

Click the tabs at the bottom of the file to open different objects.

The exported data includes the following details for each field:

Column Name Possible Values More Information
Field Name   The field name.
Localized UI Label   The label used in the Network MDM UI for the language defined in your profile.
Effective Version Version number The first time the field was created for at least one country.
Status Active / Deactivated Active if the field is enabled in your Network MDM instance.
Type Reference, Set, String, Alternatekey, Date, Year, Boolean, Number, Datetime. The type of data in the field.
Reference Type Reference type For Reference and Boolean type fields only. If the field does not have a reference type, the column is empty.
Length 10, 20, 100, 500 ... The field length.
Important: Field lengths are suggestions only. They are not enforced in Network MDM.
Default Value True / False True if the field has a default value in at least one OpenData country.
Custom Field? True / False True if you have created the field in your Network MDM instance. The field name must contain the "__c" suffix.
Network System Field? True / False True if the field is populated automatically by Network MDM; for example, record_state__v, created_date__v, record_owner_type__v.
Field Description   Description in the field configuration.
HCP Opt Out Behavior Retain - The field value remains on the record.
Blank - The field value is removed.
Mask - The field value is replaced with "Data Privacy" on OpenData records or "Customer Data Privacy".		 Indicates what happens to the field value when the record is exported if the data_privacy_opt_out field is set to Yes/True.
  • Veeva opt out (data_privacy_opt_out__v) - The opt out behavior occurs when the record is exported from OpenData to your Network MDM instance.
  • Local opt out (data_privacy_opt_out__c) - The opt out behavior occurs when the record is exported from your Network instance to downstream systems.
Default Rankings Default/Overridden Identifies if the field rankings have been overridden.
See the Source Rankings section on each data model field page.
CRM Field Group Name   The name used by the CRM bridge.
Read Only in (country/region) True/False The value is determined per country. If the field is not available in a country, the column value is always False.
Required in (country/region) True/False The value is determined per country. If the field is not available in a country, the column value is always False.

In the Read Only/Required country columns, TRUE indicates the field is being managed in the country, and FALSE indicates that the field is not being managed in the country. You can confirm who is managing a field by reviewing the field list on the object page or on the field configuration page.

On the field's configuration page, when a field is removed from the Managed by Customer section for a country and object, FALSE is shown for that country and that object in the exported file.

Country support

The following list of countries have their own data model. Countries that are not listed use the Other Countries data model.

  • Albania (AL)

  • Algeria (DZ)

  • Andorra (AD)

  • Angola (AO)

  • Argentina (AR)

  • Armenia (AM)

  • Australia (AU)

  • Austria (AT)

  • Azerbaijan (AZ)

  • Bahamas (BS)

  • Bahrain (BH)

  • Barbados (BB)

  • Belarus (BY)

    (Data no longer provided by OpenData)

  • Belgium (BE)

  • Bermuda (BM)

  • Bolivia (BO)

  • Bosnia and Herzegovina (BA)

  • Botswana (BW)

  • Brazil (BR)

  • Bulgaria (BG)

  • Burkina Faso (BF)

  • Cameroon (CM)

  • Canada (CA)

  • Cayman Islands (KY)

  • Chile (CL)

  • China (CN)

  • Colombia (CO)

  • Costa Rica (CR)

  • Cote d'Ivoire (CI)

  • Croatia (HR)

  • Curacao (CW)

  • Cyprus (CY)

  • Czech Republic (CZ)

  • Denmark (DK)

  • Dominican Republic (DO)

  • Ecuador (EC)

  • Egypt (EG)

  • El Salvador (SV)

  • Estonia (EE)

  • Ethiopia ( ET)

  • Finland (FI)

  • France (FR)

  • Georgia (GE)

  • Germany (DE)

  • Ghana (GH)

  • Greece (GR)

  • Guatemala (GT)

  • Honduras (HN)

  • Hong Kong (HK)

  • Hungary (HU)

  • Iceland (IS)

  • India (IN)

  • Indonesia (ID)

  • Iraq (IQ)

  • Ireland (IE)

  • Israel (IL)

  • Italy (IT)

  • Jamaica (JM)

  • Japan (JP)

  • Jordan (JO)

  • Kazakhstan (KZ)

  • Kenya (KE)

  • Kuwait (KU)

  • Kyrgyzstan (KG)

  • Latvia (LV)

  • Lebanon (LB)

  • Liechtenstein (LI)

  • Lithuania (LT)

  • Luxembourg (LU)

  • Macao (MO)

  • Macedonia (MK)

  • Madagascar (MG)

  • Malaysia (MY)

  • Mali (ML)

  • Malta (MT)

  • Mauritius (MU)

  • Mexico (MX)

  • Moldova (MD)

  • Monaco (MC)

  • Montenegro (ME)

  • Morocco (MA)

  • Namibia (NA)

  • Netherlands (NL)

  • New Zealand (NZ)

  • Nicaragua (NI)

  • Nigeria (NG)

  • Norway (NO)

  • Oman (OM)

  • Pakistan (PK)

  • Panama (PA)

  • Paraguay (PY)

  • Peru (PE)

  • Philippines (PH)

  • Poland (PL)

  • Portugal (PT)

  • Qatar (QA)

  • Romania (RO)

  • Russia (RU)

    (Data no longer provided by OpenData)

  • Saudi Arabia (SA)

  • Serbia (RS)

  • Senegal (SN)

  • Sierra Leone (SL)

  • Singapore (SG)

  • Slovakia (SK)

  • Slovenia (SI)

  • South Africa (ZA)

  • South Korea (KR)

  • Spain (ES)

  • Sweden (SE)

  • Switzerland (CH)

  • Taiwan (TW)

  • Tajikistan (TJ)

  • Thailand (TH)

  • Trinidad and Tobago (TT)

  • Tunisia (TN)

  • Turkey (TR)

  • Turkmenistan (TM)

  • Ukraine (UA)

  • United Arab Emirates (AE)

  • United Kingdom (UK)

  • United States (US)

  • Uruguay (UY)

  • Uzbekistan (UZ)

  • Vietnam (VN)

  • Other Countries (ZZ)