22R3 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 22R3.

Data Model Updates

The following changes were made to PromoMats Vaults to support the Add Supporting Documents to eCTD Compliance Packages feature:

  • Added the inactive document type Supporting Documents with the following subtypes: 
    • eCTD Compliance Annotated Material 
    • eCTD Compliance Annotated Label 
    • eCTD Compliance Annotated Reference 
    • eCTD Compliance Clean Material
  • Added the inactive document field Main Promotional Piece?
  • Added the inactive document relationship eCTD Support Documents (ectd_support_documents__v)

The following changes were made to PromoMats and Multichannel Vaults to support the Product & Country Become Shared Fields feature:

  • Country (country__v) document field is now a shared document field
  • Product (product__v) document field is now a shared document field

The following changes were made to PromoMats Vaults:

  • Added the Related ISI (related_isi__v) relationship type to the Base document type
  • Added the Related PI (related_pi__v) relationship type to the Base document type

The following changes were also made to PromoMats Vaults:

  • Source Content Module (source_content_module__v) is now a shared document field
  • Added the following fields to the Country (country__v) object
    • PromoMats UUID (promomats_uuid__v)
    • Language (language__v)
    • Country Code (country_code__v)
  • Added the Language (language__v) object
  • Added the Country Language object
  • Added the field  (source_text_asset__v) to the Claims (annotation_keywords__sys) object
  • Added the Claim Type (object_type__v) field

The following changes will be active in PromoMats Vaults that have no Claims (annotation_keywords__sys) object records. If your Vault contains Claims records these changes can be activated and configured:

  • Claims (annotation_keywords__sys) object is relabeled to Text Asset
  • Added the Claims and Reusable Text object types to the Text Asset (annotation_keywords__sys) object and inactivated the Base object type
  • Added the field Reusable Text Type (resuable_text_type__v) to the Reusable Text object type 
  • Relabeled fields on the the Text Asset (annotation_keyword_category__v) object as follows:
    • Category field relabeled to Channel
    • Country (country__v) field relabeled to Primary Country
    • Product (product__v) field relabeled to Primary Product
    • Claim (annotation_keyword__v) field relabeled to Text Asset on Match Text Variation (match_text_variation__sys) 
  • Relabeled the Claim Targets (annotation_keyword_targets__sys) object to Text Asset Targets
  • Relabled Claims Object Lifecycle to Text Asset Lifecycle
  • Relabeled Claims (related_claims__v) document field to Text Assets
  • Relabled Document Field Layout Section Claims to Text Assets

The following changes will be active in PromoMats Vaults that have no Content Module (content_module__v) object records. If your Vault contains Content Module records these changes can be activated, inactivated, and configured:

  • Relabeled fields on the Content Module (content_module__v) object as follows:
    • Category (category__v) field relabeled to Channel
    • Country (country__v) field relabeled to Primary Country
    • Product (product__v) field relabeled to Primary Product
  • Inactivated the Text Element Content (text_element_content__v) field on the Content Module Asset object
  • Inactivated the Text Element Type (text_element_type__v) field on the Content Module Asset object
  • Relabeled the Claim (claim__v) field on the Content Module Asset object to Text Asset
  • Relabeled the Claim Match Text (claim_match_text__v) field on the Content Module Asset object to Match Text
  • Added the Reusable Text Type (reusable_text_type__v) field to the Content Module Asset object
  • Added the Text Asset, Match Text, and Reusable Text Type object fields to the Text (text__v) object type on the Content Module Asset object and its Page Layout
  • Added Criteria VQL to the Text Asset object field on the Claim object type:
    • object_type__vr.name__v = 'Claim' OR object_type__vr.name__v = 'Base'
  • Added Criteria VQL to the Text Asset object field on the Text object type:
    • object_type__vr.name__v = 'Reusable Text'

The following change was made to PromoMats Vaults to support the eCTD Submission Package feature:

  • Added the eCTD Submission Package rendition type
  • Added the Submission Ready Copy Type document field and picklist

The following change was made to PromoMats Vaults to support the Vault CRM to PromoMats Connection feature:

  • Added the Vault CRM to PromoMats Connection document type group

The following change was made to PromoMats Vaults to support future functionality:

  • Added the My Schedule Template (my_schedule_template__v) value to the Email Template Type picklist