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

[Will_F_SAS]

Starting with the release for October 08, 2025, SAS Customer Intelligence 360 includes updates to the Unified Data Model (UDM) and Common Data Model (CDM) for schema 19.

Schema 19 contains enhancements to support these features:

• UDM tables now indicate which columns are the primary key or part of a table's composite key.
• Journey tables include new columns for contextual identity information.
• Impression tables and SMS tables include journey information.
• Usage tables include information about the number of customer profiles that were processed for each license.
• A new metadata table for audiences is added to the UDM and CDM.

 

Updates to the UDM

 

New Table

The MD_AUDIENCE_X_SEGMENT table contains information that connects audiences with the related segments.

Updates to Tables

These are updates to the existing tables in the UDM:

Table	Updates
DAILY_USAGE MONTHLY_USAGE	The customer_profiles_processed_str is added.
IMPRESSION_DELIVERED SMS_MESSAGE_CLICKED SMS_MESSAGE_DELIVERED SMS_MESSAGE_FAILED SMS_MESSAGE_REPLY SMS_MESSAGE_SEND SMS_OPTOUT SMS_OPTOUT_DETAILS	These columns are added: journey_id journey_occurrence_id
JOURNEY_ENTRY JOURNEY_EXIT JOURNEY_HOLDOUT JOURNEY_NODE_ENTRY JOURNEY_SUCCESS JOURNEY_SUPPRESSION	These columns are added: context_type_nm context_val
MEDIA_ACTIVITY_DETAILS MEDIA_DETAILS_EXT SEARCH_RESULTS_EXT	The event_id column is added.
NOTIFICATION_TARGETING_REQUEST	The task_id column is added.
AB_TEST_PATH_ASSIGNMENT ACTIVITY_CONVERSION ACTIVITY_FLOW_IN ACTIVITY_START ADVERTISING_CONTACT AUDIENCE_MEMBERSHIP_CHANGE BUSINESS_PROCESS_DETAILS CART_ACTIVITY_DETAILS CONVERSION_MILESTONE CUSTOM_EVENTS DATA_VIEW_DETAILS DIRECT_CONTACT DOCUMENT_DETAILS EMAIL_CLICK EMAIL_COMPLAINT EMAIL_OPEN EMAIL_OPTOUT EMAIL_REPLY EMAIL_SEND EMAIL_VIEW EXTERNAL_EVENT FORM_DETAILS 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_CREATIVE MD_EVENT MD_MESSAGE MD_SEGMENT_MAP MD_SEGMENT_TEST MD_SPOT MD_TASK MEDIA_DETAILS MEDIA_DETAILS_EXT MOBILE_FOCUS_DEFOCUS MOBILE_SPOTS NOTIFICATION_FAILED NOTIFICATION_OPENED NOTIFICATION_SEND NOTIFICATION_TARGETING_REQUEST OUTBOUND_SYSTEM ORDER_DETAILS ORDER_SUMMARY PAGE_ERRORS PRODUCT_VIEWS PROMOTION_DISPLAYED PROMOTION_USED SEARCH_RESULTS SEARCH_RESULTS_EXT SMS_MESSAGE_CLICKED SMS_MESSAGE_DELIVERED SMS_MESSAGE_FAILED SMS_MESSAGE_REPLY SMS_MESSAGE_SEND SMS_OPTOUT SMS_OPTOUT_DETAILS SPOT_CLICKED SPOT_REQUESTED	Primary key or composite key information is added. When the column is a primary key or part of the table's composite key, that information is conveyed in these ways: In the JSON schema, the primary_key attribute is set to true. In the Help Center, the following icon is displayed next to the column's name:

Updates to the CDM

 

New Table

The CDM_AUDIENCE_X_SEGMENT table contains metadata about published audiences and the related segments.