22R2 Data Model Changes: Commercial

With every release, we update the data model to better support evolving needs and new feature functionality. With this release, we’ve added the following components to the Commercial data model. These data model updates are automatically included in all Commercial Vaults, but Admins must make configuration changes to make them available. For information on feature functionality, see What’s New in 22R2.

Data Model Updates

The following changes were made to MedComms and PromoMats Vaults to support the Packaging of CLM Content on CDN (Engage Share) feature:

  • Added the shared field Publish for Veeva CRM (Remote CLM) (publish_for_veeva_crm_remote_clm__v)

The following changes were made to PromoMats and MedComms Vaults to support the Auto Publish to CRM for Approved Email Fragments feature:

  • Added the shared document field Publish for Veeva CRM (Email) (email_content__v)
  • Added the document field Targeted Document Type (targeted_doc_type__v)
  • Added the Deleted (deleted__v) state to the Approved Email lifecycle
  • Added the Language (language__v) field to the Country (country__v) object

The following changes were made to MedComms Vaults to support the Data Agnostic MedComms to CRM Connection for Medical Inquiry and Network (OpenData) Connection to Look Up HCP Reference Data for Medical Inquiry features:

  • Added the following fields to the Case (case__v) object:
    • Last Modified in CRM Date (crm_last_modified_date__v)
    • Response Contact (response_contact__v)
  • Added the Response Contact (response_contact__v) field to the Case Response (case_response__v) object
  • Added the Connection (connect__v) field to the CRM Org (crm_org__v) object
  • Added the OpenData Healthcare Provider ID (opendata_healthcare_provider_id__v) field to the Person (person__v) object
  • Added the Veeva OpenData (veeva_opendata__v) value to the Source (source__v) picklist

The following changes were also made to MedComms and PromoMats Vaults:

  • Added the shared field Publish for Veeva CRM (Web link) (publish_for_veeva_crm_web_link__v)
  • Added object CRM EM Event Configuration (crm_em_event_configuration__v)
  • Added object CRM EM Event Topic (crm_em_event_topic__v)
  • Added document field CRM EM Event Configuration (crm_em_event_configuration__v)
  • Added document field CRM EM Event Topic (crm_em_event_topic__v)

The following changes were made to PromoMats Vaults:

  • Relabelled the PromoMats to RIM connection as RIM to PromoMats
  • Relabelled the PromoMats to RIM Connection document type group as RIM to PromoMats Connection
  • Added the Pre-Dissemination Review of Television Ads object record to the Promotional Material Document Type object

The following changes were made to MedComms Vaults:

  • Added the Response Contact (response_contact_v) field