Updates for Schema 16 in the UDM and CDM for SAS Customer Intelligence 360

[Will_F_SAS]

Starting with the release for July 31, 2024, SAS Customer Intelligence 360 includes updates to the Unified Data Model (UDM) and Common Data Model (CDM) for schema 16. Schema 16 contains enhancements to support these features:

• The CDM is updated with support for audiences, contextual identities, and time zone information for contact events.
• The UDM is updated with support for these features:
  • Variants that are used in an A/B task
  • Contextual identities
  • Miscellaneous updates to column lengths for longer values

Contextual identities is a feature planned for a later release that enables an organization to designate the context for why an individual is contacted (such as whether they belong to a specific account or household). This contextual data allows organizations to understand why individuals are contacted and can utilize the data in creating contact policies.

Updates to the CDM

New Tables

These tables are new:

• CDM_AUDIENCE_DETAIL - This table contains metadata about audiences.
• CDM_AUD_OCCURR_DETAIL - This table contains metadata about published audiences.

Updated Tables

These tables are updated:

Table	Updates
CDM_CONTACT_HISTORY	These columns are added: audience_id aud_occurrence_id contact_dttm_tz context_type_nm context_val
CDM_RESPONSE_HISTORY	These columns are added: audience_id aud_occurrence_id context_type_nm context_val response_dttm_tz
CDM_CONTENT_DETAIL CDM_TASK_DETAIL	The length of these columns are changed to VARCHAR(256) for these columns: created_user_nm owner_nm

Updates to the UDM

New Tables

There is a new table in the UDM:

• MD_TASK_X_VARIANT – this table contains information about the variants that are used in an A/B test task.

Updated Tables

These are updates to the existing tables in the UDM:

Table	Updates
AB_TEST_PATH_ASSIGNMENT ACTIVITY_CONVERSION ACTIVITY_FLOW_IN ACTIVITY_START ADVERTISING_CONTACT CONTACT_HISTORY CONVERSION_MILESTONE DIRECT_CONTACT EMAIL_BOUNCE EMAIL_CLICK EMAIL_COMPLAINT EMAIL_OPEN EMAIL_OPTOUT EMAIL_OPTOUT_DETAILS EMAIL_REPLY EMAIL_SEND EMAIL_VIEW EXTERNAL_EVENT IMPRESSION_DELIVERED IMPRESSION_SPOT_VIEWABLE IN_APP_FAILED IN_APP_MESSAGE IN_APP_SEND IN_APP_TARGETING_REQUEST MOBILE_SPOTS NOTIFICATION_FAILED NOTIFICATION_OPENED NOTIFICATION_SEND NOTIFICATION_TARGETING_REQUEST OUTBOUND_SYSTEM RESPONSE_HISTORY SPOT_CLICKED SPOT_REQUESTED	These tables have the following two columns added: context_type_nm context_val These columns will be used in the future with contextual identities.
MD_AUDIENCE_DETAIL	The length of the created_user_nm column is changed to VARCHAR(256).
MD_AUDIENCE_OCCURRENCE	The length of the started_by_nm column is changed to VARCHAR(256).
MD_ASSET MD_BUSINESS_CONTEXT MD_CREATIVE MD_DATAVIEW MD_EVENT MD_MESSAGE MD_SEGMENT MD_SEGMENT_MAP MD_SPOT MD_TASK	The length of the following columns is updated to VARCHAR(256): created_user_nm owner_nm
MD_SEGMENT	The length of the segment_cd column is updated to VARCHAR(60).
MD_SEGMENT_MAP	The length of the segment_map_cd column is updated to VARCHAR(60).
MD_TASK	The length of the send_notification_locale_cd is updated to VARCHAR(5).

Deprecations

The following tables are being deprecated and removed:

• CUSTOM_ATTRIBUTES. Custom properties are now available in the properties_map_doc column of the table for the corresponding event or task.
• GOAL_DETAILS and GOAL_DETAILS_EXT. These events are collected in the CUSTOM_EVENTS table.