Updates for Schema 17 in the UDM for SAS Customer Intelligence 360

Will_F_SAS · Posted 01-28-2025 01:09 PM

Starting with the release for January 29, 2025, SAS Customer Intelligence 360 includes updates to the Unified Data Model (UDM) for schema 17. Schema 17 contains enhancements to support these features:

New tables to support journeys
New tables to support SMS communications
Updated category values to include the Foundations license
Additional columns for events and journeys to enhance cross-table integration

New UDM Tables for Journeys

Note: These tables will not be populated until a later release.

These are the tables that are added to support journeys:

New UDM Tables for SMS Communications

These are the tables that are added to support SMS communications:

Updated Tables

These are updates to the existing tables in the UDM:

Table	Updates
ADVERTISING_CONTACT CONTACT_HISTORY CONVERSION_MILESTONE EMAIL_BOUNCE EMAIL_CLICK EMAIL_COMPLAINT EMAIL_OPEN EMAIL_OPTOUT EMAIL_OPTOUT_DETAILS EMAIL_REPLY EMAIL_SEND NOTIFICATION_FAILED NOTIFICATION_OPENED NOTIFICATION_SEND NOTIFICATION_TARGETING_REQUEST OUTBOUND_SYSTEM RESPONSE_HISTORY	Added these columns: journey_id journey_occurrence_id Note: These columns will not be populated until a later release.
BUSINESS_PROCESS_DETAILS CART_ACTIVITY_DETAILS DOCUMENT_DETAILS FORM_DETAILS MEDIA_DETAILS ORDER_DETAILS ORDER_SUMMARY PAGE_DETAILS PAGE_ERRORS PRODUCT_VIEWS PROMOTION_DISPLAYED PROMOTION_USED SEARCH_RESULTS	Added these columns: event_id event_source_cd
CUSTOM_EVENTS IMPRESSION_DELIVERED IMPRESSION_SPOT_VIEWABLE SPOT_CLICKED SPOT_REQUESTED	Added the event_source_cd column.
MD_CREATIVE	Added the creative_txt column.
MD_TASK	Added the subject_line_source_nm column.
PAGE_DETAILS	Added the event_nm column.
SESSION_DETAILS	Added these columns: event_id parent_event_id
VISIT_DETAILS	Added the event_id column.
AB_TEST_PATH_ASSIGNMENT ACTIVITY_CONVERSION ACTIVITY_FLOW_IN ACTIVITY_START ADVERTISING_CONTACT AUDIENCE_MEMBERSHIP_CHANGE CONTACT_HISTORY CONVERSION_MILESTONE EMAIL_BOUNCE EMAIL_CLICK EMAIL_COMPLAINT EMAIL_OPEN EMAIL_OPTOUT EMAIL_REPLY EMAIL_SEND EMAIL_VIEW IMPRESSION_DELIVERED IMPRESSION_SPOT_VIEWABLE IN_APP_FAILED IN_APP_MESSAGE IN_APP_SEND IN_APP_TARGETING_REQUEST JOURNEY_ENTRY JOURNEY_EXIT JOURNEY_HOLDOUT JOURNEY_NODE_ENTRY JOURNEY_SUCCESS JOURNEY_SUPPRESSION MD_ACTIVITY MD_ACTIVITY_ABTESTPATH MD_ACTIVITY_CUSTOM_PROP MD_ACTIVITY_NODE MD_ACTIVITY_X_ACTIVITY_NODE MD_ACTIVITY_X_TASK MD_ASSET MD_AUDIENCE MD_AUDIENCE_OCCURRENCE MD_CREATIVE MD_CREATIVE_CUSTOM_PROP MD_CREATIVE_X_ASSET MD_DATAVIEW MD_DATAVIEW_X_EVENT MD_EVENT MD_JOURNEY MD_JOURNEY_NODE MD_JOURNEY_NODE_OCCURRENCE MD_JOURNEY_OCCURRENCE MD_JOURNEY_X_AUDIENCE MD_JOURNEY_X_EVENT MD_JOURNEY_X_TASK MD_MESSAGE MD_MESSAGE_CUSTOM_PROP MD_MESSAGE_X_CREATIVE MD_OCCURRENCE MD_PURPOSE MD_RTC MD_SEGMENT MD_SEGMENT_CUSTOM_PROP MD_SEGMENT_MAP MD_SEGMENT_MAP_CUSTOM_PROP MD_SEGMENT_MAP_X_SEGMENT MD_SEGMENT_TEST MD_SEGMENT_TEST_X_SEGMENT MD_SEGMENT_X_EVENT MD_SPOT MD_TASK MD_TASK_CUSTOM_PROP MD_TASK_X_AUDIENCE MD_TASK_X_CREATIVE MD_TASK_X_DATAVIEW MD_TASK_X_EVENT MD_TASK_X_MESSAGE MD_TASK_X_SEGMENT MD_TASK_X_SPOT MD_TASK_X_VARIANT MOBILE_SPOTS NOTIFICATION_FAILED NOTIFICATION_OPENED NOTIFICATION_SEND NOTIFICATION_TARGETING_REQUEST OUTBOUND_SYSTEM RESPONSE_HISTORY SMS_MESSAGE_CLICKED SMS_MESSAGE_DELIVERED SMS_MESSAGE_FAILED SMS_MESSAGE_REPLY SMS_MESSAGE_SEND SMS_OPTOUT SPOT_CLICKED SPOT_REQUESTED	Added the category DESTINATIONS.
AUDIENCE_MEMBERSHIP_CHANGE CONVERSION_MILESTONE MD_AUDIENCE MD_AUDIENCE_OCCURRENCE MD_CREATIVE MD_CREATIVE_CUSTOM_PROP MD_OCCURRENCE MD_RTC MD_TASK MD_TASK_CUSTOM_PROP MD_TASK_X_AUDIENCE MD_TASK_X_CREATIVE MD_TASK_X_EVENT SMS_MESSAGE_CLICKED SMS_MESSAGE_DELIVERED SMS_MESSAGE_FAILED SMS_MESSAGE_REPLY SMS_MESSAGE_SEND SMS_OPTOUT SMS_OPTOUT_DETAILS	Added the category SMS.