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

[Will_F_SAS]

Starting with the release for February 11, 2026, SAS Customer Intelligence 360 includes updates to the Unified Data Model (UDM) and Common Data Model (CDM) for schema 20.

Schema 20 contains enhancements to support these features:

• More information about primary keys and foreign keys in both the UDM and CDM
• New metadata tables that provide a complete history of metadata for items
• Updates to usage tables to capture the counts from occurrences of direct marketing tasks
• Updates to tables for journeys.
• UDM detail tables no longer include customer identifiers (such as subject IDs, email addresses, and so on).

On this page:

• Updates to the UDM
  • New tables
  • Updates to tables
• Updates to the CDM

Updates to the UDM

New Tables

Debug Table

The EVENT_ERRORS table is added to debug events that are sent to SAS Customer Intelligence 360 through the server-side Events API but cannot be processed.

Journey Table

The JOURNEY_TEST_SUCCESS table is added to capture when an individual in a scheduled journey converts for a specific path that is part of path testing.

Metadata Tables

A set of new, separate metadata tables are added to enable users to get the complete history of metadata for items. To download metadata for items, you should choose one of these categories:

• ENGAGEMETADATA: downloads metadata tables with the most recent metadata for items.
• METADATA_ALL: downloads the new *_ALL tables with the most recent metadata and the historical metadata.

With either category, you receive the same number of tables, covering all areas of metadata. No behavior has changed for tables in the ENGAGEMETADATA category.

Note: When you download tables in the METADATA_ALL category, the primary key in the table is <object>_version_id, rather than <object>_id.

These new tables can be downloaded with the METADATA_ALL category:

• MD_ACTIVITY_ABTESTPATH_ALL
• MD_ACTIVITY_ALL
• MD_ACTIVITY_CUSTOM_PROP_ALL
• MD_ACTIVITY_NODE_ALL
• MD_ACTIVITY_X_ACTIVITY_NODE_ALL
• MD_ACTIVITY_X_TASK_ALL
• MD_ASSET_ALL
• MD_BUSINESS_CONTEXT_ALL
• MD_CREATIVE_ALL
• MD_CREATIVE_CUSTOM_PROP_ALL
• MD_CREATIVE_X_ASSET_ALL
• MD_DATAVIEW_ALL
• MD_DATAVIEW_X_EVENT_ALL
• MD_EVENT_ALL
• MD_JOURNEY_ALL
• MD_MESSAGE_ALL
• MD_MESSAGE_CUSTOM_PROP_ALL
• MD_MESSAGE_X_CREATIVE_ALL
• MD_SEGMENT_ALL
• MD_SEGMENT_CUSTOM_PROP_ALL
• MD_SEGMENT_MAP_ALL
• MD_SEGMENT_MAP_CUSTOM_PROP_ALL
• MD_SEGMENT_MAP_X_SEGMENT_ALL
• MD_SEGMENT_TEST_ALL
• MD_SEGMENT_TEST_X_SEGMENT_ALL
• MD_SEGMENT_X_EVENT_ALL
• MD_SPOT_ALL
• MD_TASK_ALL
• MD_TASK_CUSTOM_PROP_ALL
• MD_TASK_X_CREATIVE_ALL
• MD_TASK_X_DATAVIEW_ALL
• MD_TASK_X_EVENT_ALL
• MD_TASK_X_MESSAGE_ALL
• MD_TASK_X_SEGMENT_ALL
• MD_TASK_X_SPOT_ALL
• MD_TASK_X_VARIANT_ALL

Updates to Tables

These are updates to the existing tables in the UDM:

Table	Updates
AB_TEST_PATH_ASSIGNMENT ACTIVITY_CONVERSION ACTIVITY_FLOW_IN ACTIVITY_START CONVERSION_MILESTONE DATA_VIEW_DETAILS DIRECT_CONTACT EMAIL_BOUNCE EMAIL_CLICK EMAIL_COMPLAINT EMAIL_OPEN EMAIL_OPTOUT EMAIL_REPLY EMAIL_SEND EMAIL_VIEW EXTERNAL_EVENT OUTBOUND_SYSTEM	The channel_id column is no longer populated. This change always applies to the downloaded tables, regardless of the schema version that is requested.
DBT_CONTENT DBT_DOCUMENTS DBT_FORMS DBT_GOALS DBT_PROMOTIONS DBT_SEARCH	The detail_id column is added.
DAILY_USAGE MONTHLY_USAGE	These columns are added: dm_destinations_total_id_cnt dm_destinations_total_row_cnt
EMAIL_VIEW	These columns are added: journey_id journey_occurrence_id
MD_AUDIENCE_X_SEGMENT MD_JOURNEY_NODE MD_JOURNEY_NODE_OCCURRENCE MD_JOURNEY_OCCURRENCE MD_JOURNEY_X_AUDIENCE MD_JOURNEY_X_EVENT MD_JOURNEY_X_TASK MD_TARGET_ASSIST MD_TASK_X_AUDIENCE	The value METADATA_ALL is added to the list of categories.
JOURNEY_NODE_ENTRY JOURNEY_EXIT	The group_id column is added.
JOURNEY_SUCCESS	These columns are added: group_id parent_event_designed_id
DIRECT_CONTACT JOURNEY_ENTRY JOURNEY_EXIT JOURNEY_HOLDOUT JOURNEY_NODE_ENTRY JOURNEY_SUCCESS JOURNEY_SUPPRESSION	These columns are no longer populated: identity_type_nm identity_type_val
MD_ACTIVITY_NODE	The wait_tm column's data type is updated to BIGINT.
SESSION_DETAILS	These columns are updated: The visitor_id column's data type is updated to VARCHAR(128). The event_source_cd column is added, which specifies the source channel for the event.

Updates to the CDM

In the CDM_OCCURRENCE_DETAIL table, the data type for the occurrence_type_cd column is now VARCHAR(100).