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

topic Updates for Schema 19 in the UDM for SAS Customer Intelligence 360 in SAS Customer Intelligence https://communities.sas.com/t5/SAS-Customer-Intelligence/Updates-for-Schema-19-in-the-UDM-for-SAS-Customer-Intelligence/m-p/976642#M2087 <P>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.</P> <P> </P> <P>Schema 19 contains enhancements to support these features:</P> <UL> <LI>UDM tables now indicate which columns are the primary key or part of a table's composite key.</LI> <LI>Journey tables include new columns for contextual identity information.</LI> <LI>Impression tables and SMS tables include journey information.</LI> <LI>Usage tables include information about the number of customer profiles that were processed for each license.</LI> <LI>A new metadata table for audiences is added to the UDM and CDM.</LI> </UL> <H1> </H1> <H1>Updates to the UDM</H1> <H2> </H2> <H2>New Table</H2> <P>The <A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=db-udm-metadata-audience.htm#p1b5xkg43esjb3n0zi8vxx537gnx">MD_AUDIENCE_X_SEGMENT</A> table contains information that connects audiences with the related segments.</P> <P> </P> <H2>Updates to Tables</H2> <P>These are updates to the existing tables in the UDM:</P> <P> </P> <TABLE> <THEAD> <TR> <TD width="241"> <P><STRONG>Table</STRONG></P> </TD> <TD width="360"> <P><STRONG>Updates</STRONG></P> </TD> </TR> </THEAD> <TBODY> <TR> <TD width="241"> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n12e5d37akj4ann133t5jpf2czdv.htm" target="_self">DAILY_USAGE</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n03gn66att2m3pn1pb5estnbndvl.htm" target="_self">MONTHLY_USAGE</A></P> </TD> <TD width="360"> <P>The customer_profiles_processed_str is added.</P> </TD> </TR> <TR> <TD width="241"> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0cx3x37r8xcwfn1nxoxxu5fs1cm.htm">IMPRESSION_DELIVERED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0f9xa323t78zhn1rfj1c7g980iz.htm">SMS_MESSAGE_CLICKED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n0ka3bnxfn3z86n1szqb8om360x0.htm">SMS_MESSAGE_DELIVERED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n09pliyiibhpuzn1ib5ir141rl3n.htm">SMS_MESSAGE_FAILED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1oy311a7yygncn1q6jsh8sa8dvt.htm">SMS_MESSAGE_REPLY</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1tud9fi3hulj2n1qmibbz5wvdrx.htm">SMS_MESSAGE_SEND</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1k9skuosq92o7n1gscxgtnmka1r.htm">SMS_OPTOUT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1653n6dsmqx7qn16p6gx7ngzxks.htm">SMS_OPTOUT_DETAILS</A></P> </TD> <TD width="360"> <P>These columns are added:</P> <UL> <LI>journey_id</LI> <LI>journey_occurrence_id</LI> </UL> </TD> </TR> <TR> <TD width="241"> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1a768isx3i85en13cazi5sl4wjd.htm">JOURNEY_ENTRY</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0xvglivsh1quen1vf7d5fe81ltr.htm">JOURNEY_EXIT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n096u799a8n3wjn18t2mc9myyq93.htm">JOURNEY_HOLDOUT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1t1c0e2jlshr3n14ts4r4az2jfy.htm">JOURNEY_NODE_ENTRY</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n02fbx6azwpbobn0zoox1osu27sn.htm">JOURNEY_SUCCESS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0suvtx05whtw5n1x1sjk1ph0hg5.htm">JOURNEY_SUPPRESSION</A></P> </TD> <TD width="360"> <P>These columns are added:</P> <UL> <LI>context_type_nm</LI> <LI>context_val</LI> </UL> </TD> </TR> <TR> <TD width="241"> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p07x6c0208mnddn1getzl4i9txhc.htm" target="_self">MEDIA_ACTIVITY_DETAILS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1bkh3j1u63g6an1e0ahmy11fn4q.htm" target="_self">MEDIA_DETAILS_EXT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1l32gcmy8yf7sn1ath8pabt1mnn.htm" target="_self">SEARCH_RESULTS_EXT</A></P> </TD> <TD width="360"> <P>The event_id column is added.</P> </TD> </TR> <TR> <TD width="241"> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n12uxr217i3bjzn1s4ttqbcrcw1v.htm">NOTIFICATION_TARGETING_REQUEST</A></P> </TD> <TD width="360"> <P>The task_id column is added.</P> </TD> </TR> <TR> <TD width="241"> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1jzyeh5lrvvv3n16rrvb1w5cysz.htm">AB_TEST_PATH_ASSIGNMENT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1aobkx8zmhutkn1wydp0fcpw3te.htm">ACTIVITY_CONVERSION</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n09m1wwbezpbkbn1jpuicllf6f4x.htm">ACTIVITY_FLOW_IN</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1qtuoeu6arrlbn1axcsfy6zz5t5.htm">ACTIVITY_START</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=db-udm-engage-advertising.htm">ADVERTISING_CONTACT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=db-udm-audience.htm">AUDIENCE_MEMBERSHIP_CHANGE</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1gxhpfdn4jhqin1wxeq5xqjgo41.htm">BUSINESS_PROCESS_DETAILS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0txj2rk97tmwsn1sxaizhjdlz7a.htm" target="_self">CART_ACTIVITY_DETAILS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1gqs2umtcfvwdn1rxzcadu6kf7d.htm">CONVERSION_MILESTONE</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1eyc8khiczwymn1l2pp2bl1tkgp.htm" target="_self">CUSTOM_EVENTS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p146paauzlblk7n1g48tj54fehqy.htm" target="_self">DATA_VIEW_DETAILS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1xprcws7hejc0n19mnpw7slrr2l.htm">DIRECT_CONTACT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1h22eo39huzbwn1gq503rzqkl73.htm" target="_self">DOCUMENT_DETAILS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0fd7e82b1wyocn1knkrt7jsvzm1.htm">EMAIL_CLICK</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1492v1oej5nymn1hvl5e2cz3y1m.htm">EMAIL_COMPLAINT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0s10gwoj3kn77n1m468vvdl3ain.htm">EMAIL_OPEN</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1ozd8xu1r2q6un1q051wycv4fln.htm">EMAIL_OPTOUT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n029zyhvhxmaman1iaq7z0ier6pi.htm">EMAIL_REPLY</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0xoaguvdty53sn1g0vv4svtptra.htm">EMAIL_SEND</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n0chobyr4vbv77n184yoiyy9jjjq.htm">EMAIL_VIEW</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0ggcuhl38ul0vn129j1yf9uz0ux.htm" target="_self">EXTERNAL_EVENT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n0oqlxfnhd2219n1mb3t4jgahnpx.htm" target="_self">FORM_DETAILS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0cx3x37r8xcwfn1nxoxxu5fs1cm.htm">IMPRESSION_DELIVERED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1d4fviqdzk1k9n1blozii2sfhr7.htm">IMPRESSION_SPOT_VIEWABLE</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0gavavgvouaqon1uzuxchmk8bgs.htm">IN_APP_FAILED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0edrwmiz6ixjen13vetfrm87i1v.htm">IN_APP_MESSAGE</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p01k8ep5f4anoon1jghgpq85hnku.htm">IN_APP_SEND</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p17jt140kkb2g3n1ao9zet8q9mva.htm">IN_APP_TARGETING_REQUEST</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1a768isx3i85en13cazi5sl4wjd.htm">JOURNEY_ENTRY</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0xvglivsh1quen1vf7d5fe81ltr.htm">JOURNEY_EXIT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n096u799a8n3wjn18t2mc9myyq93.htm">JOURNEY_HOLDOUT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1t1c0e2jlshr3n14ts4r4az2jfy.htm">JOURNEY_NODE_ENTRY</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n02fbx6azwpbobn0zoox1osu27sn.htm">JOURNEY_SUCCESS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0suvtx05whtw5n1x1sjk1ph0hg5.htm">JOURNEY_SUPPRESSION</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n0z5bdz1v8iafjn1lwssrpkq8vb0.htm">MD_ACTIVITY</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0x34e1ei0ud1dn1xqsdm4crcxmd.htm">MD_CREATIVE</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p14i191e7kxv5hn1s3icou66mllz.htm">MD_EVENT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p18qj2p3v6h4lvn19qm0i23yiqfg.htm">MD_MESSAGE</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1gyfjmkqmicbyn1fae3v9zn60pk.htm">MD_SEGMENT_MAP</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0wnxmsbzkykhwn175wgknlvcyo2.htm">MD_SEGMENT_TEST</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=db-udm-metadata-spots.htm">MD_SPOT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n08guibsnisb93n1bainx9h34ffg.htm">MD_TASK</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1gwzbnng719bdn17gm9ut4r1sym.htm" target="_self">MEDIA_DETAILS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1bkh3j1u63g6an1e0ahmy11fn4q.htm" target="_self">MEDIA_DETAILS_EXT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n0t7rkmzjo3wjdn1i518s9suk1eh.htm" target="_self">MOBILE_FOCUS_DEFOCUS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n0t537jgtcdvcqn14y0o4l3n8uyf.htm">MOBILE_SPOTS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0hxqqe04d1fjkn1js2gnprynofd.htm">NOTIFICATION_FAILED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1dpqekraaaarin13z92sfo2yvjc.htm">NOTIFICATION_OPENED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0qqyedlnm8nl5n1umuxa21vsgnu.htm">NOTIFICATION_SEND</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n12uxr217i3bjzn1s4ttqbcrcw1v.htm">NOTIFICATION_TARGETING_REQUEST</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1w99mkn8kc1hfn1iv0avosi1i26.htm">OUTBOUND_SYSTEM</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1wqzw6ibse1qdn1mvggb0lnz239.htm" target="_self">ORDER_DETAILS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1nq9pv7wpb3b1n1sonhyevw1grq.htm" target="_self">ORDER_SUMMARY</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1dzcnn3jya43ln1pc2pmycdayla.htm">PAGE_ERRORS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1533bbdazxcq5n1p4uciico0ngp.htm">PRODUCT_VIEWS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0czyd6ul0d9fan1xgefn5s5rgir.htm" target="_self">PROMOTION_DISPLAYED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0f77mzq4yi5zln1r6m7drzvbml7.htm" target="_self">PROMOTION_USED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0kttefgtvhj9jn1utroy20sbo6f.htm" target="_self">SEARCH_RESULTS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1l32gcmy8yf7sn1ath8pabt1mnn.htm" target="_self">SEARCH_RESULTS_EXT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0f9xa323t78zhn1rfj1c7g980iz.htm">SMS_MESSAGE_CLICKED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n0ka3bnxfn3z86n1szqb8om360x0.htm">SMS_MESSAGE_DELIVERED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n09pliyiibhpuzn1ib5ir141rl3n.htm">SMS_MESSAGE_FAILED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1oy311a7yygncn1q6jsh8sa8dvt.htm">SMS_MESSAGE_REPLY</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1tud9fi3hulj2n1qmibbz5wvdrx.htm">SMS_MESSAGE_SEND</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1k9skuosq92o7n1gscxgtnmka1r.htm">SMS_OPTOUT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1653n6dsmqx7qn16p6gx7ngzxks.htm">SMS_OPTOUT_DETAILS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n06zalac500e8qn1w19lfwj93vjd.htm">SPOT_CLICKED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0v381mw4ytb2bn19gk982tu1ej4.htm">SPOT_REQUESTED</A></P> </TD> <TD width="360" style="width: 360px; vertical-align: top;"> <P> </P> <P> </P> <P>Primary key or composite key information is added.</P> <P> </P> <P>When the column is a primary key or part of the table's composite key, that information is conveyed in these ways:</P> <P> </P> <UL> <LI>In the JSON schema, the primary_key attribute is set to true.</LI> <LI>In the Help Center, the following icon is displayed next to the column's name: <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Will_F_SAS_0-1759927356141.png" style="width: 200px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/110510iFBF8B78A5E034895/image-size/small?v=v2&px=200" role="button" title="Will_F_SAS_0-1759927356141.png" alt="Will_F_SAS_0-1759927356141.png" /></span></LI> </UL> </TD> </TR> </TBODY> </TABLE> <P> </P> <H1>Updates to the CDM</H1> <H1> </H1> <H1>New Table</H1> <P>The <A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=db-cdm-audience.htm#p0mmrtogt0gepvn1k0ra0vl7u1x2">CDM_AUDIENCE_X_SEGMENT</A> table contains metadata about published audiences and the related segments.</P> <P> </P> Mon, 20 Apr 2026 16:18:26 GMT Will_F_SAS 2026-04-20T16:18:26Z Updates for Schema 19 in the UDM for SAS Customer Intelligence 360 https://communities.sas.com/t5/SAS-Customer-Intelligence/Updates-for-Schema-19-in-the-UDM-for-SAS-Customer-Intelligence/m-p/976642#M2087 <P>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.</P> <P> </P> <P>Schema 19 contains enhancements to support these features:</P> <UL> <LI>UDM tables now indicate which columns are the primary key or part of a table's composite key.</LI> <LI>Journey tables include new columns for contextual identity information.</LI> <LI>Impression tables and SMS tables include journey information.</LI> <LI>Usage tables include information about the number of customer profiles that were processed for each license.</LI> <LI>A new metadata table for audiences is added to the UDM and CDM.</LI> </UL> <H1> </H1> <H1>Updates to the UDM</H1> <H2> </H2> <H2>New Table</H2> <P>The <A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=db-udm-metadata-audience.htm#p1b5xkg43esjb3n0zi8vxx537gnx">MD_AUDIENCE_X_SEGMENT</A> table contains information that connects audiences with the related segments.</P> <P> </P> <H2>Updates to Tables</H2> <P>These are updates to the existing tables in the UDM:</P> <P> </P> <TABLE> <THEAD> <TR> <TD width="241"> <P><STRONG>Table</STRONG></P> </TD> <TD width="360"> <P><STRONG>Updates</STRONG></P> </TD> </TR> </THEAD> <TBODY> <TR> <TD width="241"> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n12e5d37akj4ann133t5jpf2czdv.htm" target="_self">DAILY_USAGE</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n03gn66att2m3pn1pb5estnbndvl.htm" target="_self">MONTHLY_USAGE</A></P> </TD> <TD width="360"> <P>The customer_profiles_processed_str is added.</P> </TD> </TR> <TR> <TD width="241"> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0cx3x37r8xcwfn1nxoxxu5fs1cm.htm">IMPRESSION_DELIVERED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0f9xa323t78zhn1rfj1c7g980iz.htm">SMS_MESSAGE_CLICKED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n0ka3bnxfn3z86n1szqb8om360x0.htm">SMS_MESSAGE_DELIVERED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n09pliyiibhpuzn1ib5ir141rl3n.htm">SMS_MESSAGE_FAILED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1oy311a7yygncn1q6jsh8sa8dvt.htm">SMS_MESSAGE_REPLY</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1tud9fi3hulj2n1qmibbz5wvdrx.htm">SMS_MESSAGE_SEND</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1k9skuosq92o7n1gscxgtnmka1r.htm">SMS_OPTOUT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1653n6dsmqx7qn16p6gx7ngzxks.htm">SMS_OPTOUT_DETAILS</A></P> </TD> <TD width="360"> <P>These columns are added:</P> <UL> <LI>journey_id</LI> <LI>journey_occurrence_id</LI> </UL> </TD> </TR> <TR> <TD width="241"> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1a768isx3i85en13cazi5sl4wjd.htm">JOURNEY_ENTRY</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0xvglivsh1quen1vf7d5fe81ltr.htm">JOURNEY_EXIT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n096u799a8n3wjn18t2mc9myyq93.htm">JOURNEY_HOLDOUT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1t1c0e2jlshr3n14ts4r4az2jfy.htm">JOURNEY_NODE_ENTRY</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n02fbx6azwpbobn0zoox1osu27sn.htm">JOURNEY_SUCCESS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0suvtx05whtw5n1x1sjk1ph0hg5.htm">JOURNEY_SUPPRESSION</A></P> </TD> <TD width="360"> <P>These columns are added:</P> <UL> <LI>context_type_nm</LI> <LI>context_val</LI> </UL> </TD> </TR> <TR> <TD width="241"> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p07x6c0208mnddn1getzl4i9txhc.htm" target="_self">MEDIA_ACTIVITY_DETAILS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1bkh3j1u63g6an1e0ahmy11fn4q.htm" target="_self">MEDIA_DETAILS_EXT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1l32gcmy8yf7sn1ath8pabt1mnn.htm" target="_self">SEARCH_RESULTS_EXT</A></P> </TD> <TD width="360"> <P>The event_id column is added.</P> </TD> </TR> <TR> <TD width="241"> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n12uxr217i3bjzn1s4ttqbcrcw1v.htm">NOTIFICATION_TARGETING_REQUEST</A></P> </TD> <TD width="360"> <P>The task_id column is added.</P> </TD> </TR> <TR> <TD width="241"> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1jzyeh5lrvvv3n16rrvb1w5cysz.htm">AB_TEST_PATH_ASSIGNMENT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1aobkx8zmhutkn1wydp0fcpw3te.htm">ACTIVITY_CONVERSION</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n09m1wwbezpbkbn1jpuicllf6f4x.htm">ACTIVITY_FLOW_IN</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1qtuoeu6arrlbn1axcsfy6zz5t5.htm">ACTIVITY_START</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=db-udm-engage-advertising.htm">ADVERTISING_CONTACT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=db-udm-audience.htm">AUDIENCE_MEMBERSHIP_CHANGE</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1gxhpfdn4jhqin1wxeq5xqjgo41.htm">BUSINESS_PROCESS_DETAILS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0txj2rk97tmwsn1sxaizhjdlz7a.htm" target="_self">CART_ACTIVITY_DETAILS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1gqs2umtcfvwdn1rxzcadu6kf7d.htm">CONVERSION_MILESTONE</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1eyc8khiczwymn1l2pp2bl1tkgp.htm" target="_self">CUSTOM_EVENTS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p146paauzlblk7n1g48tj54fehqy.htm" target="_self">DATA_VIEW_DETAILS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1xprcws7hejc0n19mnpw7slrr2l.htm">DIRECT_CONTACT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1h22eo39huzbwn1gq503rzqkl73.htm" target="_self">DOCUMENT_DETAILS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0fd7e82b1wyocn1knkrt7jsvzm1.htm">EMAIL_CLICK</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1492v1oej5nymn1hvl5e2cz3y1m.htm">EMAIL_COMPLAINT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0s10gwoj3kn77n1m468vvdl3ain.htm">EMAIL_OPEN</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1ozd8xu1r2q6un1q051wycv4fln.htm">EMAIL_OPTOUT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n029zyhvhxmaman1iaq7z0ier6pi.htm">EMAIL_REPLY</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0xoaguvdty53sn1g0vv4svtptra.htm">EMAIL_SEND</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n0chobyr4vbv77n184yoiyy9jjjq.htm">EMAIL_VIEW</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0ggcuhl38ul0vn129j1yf9uz0ux.htm" target="_self">EXTERNAL_EVENT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n0oqlxfnhd2219n1mb3t4jgahnpx.htm" target="_self">FORM_DETAILS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0cx3x37r8xcwfn1nxoxxu5fs1cm.htm">IMPRESSION_DELIVERED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1d4fviqdzk1k9n1blozii2sfhr7.htm">IMPRESSION_SPOT_VIEWABLE</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0gavavgvouaqon1uzuxchmk8bgs.htm">IN_APP_FAILED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0edrwmiz6ixjen13vetfrm87i1v.htm">IN_APP_MESSAGE</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p01k8ep5f4anoon1jghgpq85hnku.htm">IN_APP_SEND</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p17jt140kkb2g3n1ao9zet8q9mva.htm">IN_APP_TARGETING_REQUEST</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1a768isx3i85en13cazi5sl4wjd.htm">JOURNEY_ENTRY</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0xvglivsh1quen1vf7d5fe81ltr.htm">JOURNEY_EXIT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n096u799a8n3wjn18t2mc9myyq93.htm">JOURNEY_HOLDOUT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1t1c0e2jlshr3n14ts4r4az2jfy.htm">JOURNEY_NODE_ENTRY</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n02fbx6azwpbobn0zoox1osu27sn.htm">JOURNEY_SUCCESS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0suvtx05whtw5n1x1sjk1ph0hg5.htm">JOURNEY_SUPPRESSION</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n0z5bdz1v8iafjn1lwssrpkq8vb0.htm">MD_ACTIVITY</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0x34e1ei0ud1dn1xqsdm4crcxmd.htm">MD_CREATIVE</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p14i191e7kxv5hn1s3icou66mllz.htm">MD_EVENT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p18qj2p3v6h4lvn19qm0i23yiqfg.htm">MD_MESSAGE</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1gyfjmkqmicbyn1fae3v9zn60pk.htm">MD_SEGMENT_MAP</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0wnxmsbzkykhwn175wgknlvcyo2.htm">MD_SEGMENT_TEST</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=db-udm-metadata-spots.htm">MD_SPOT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n08guibsnisb93n1bainx9h34ffg.htm">MD_TASK</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1gwzbnng719bdn17gm9ut4r1sym.htm" target="_self">MEDIA_DETAILS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1bkh3j1u63g6an1e0ahmy11fn4q.htm" target="_self">MEDIA_DETAILS_EXT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n0t7rkmzjo3wjdn1i518s9suk1eh.htm" target="_self">MOBILE_FOCUS_DEFOCUS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n0t537jgtcdvcqn14y0o4l3n8uyf.htm">MOBILE_SPOTS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0hxqqe04d1fjkn1js2gnprynofd.htm">NOTIFICATION_FAILED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1dpqekraaaarin13z92sfo2yvjc.htm">NOTIFICATION_OPENED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0qqyedlnm8nl5n1umuxa21vsgnu.htm">NOTIFICATION_SEND</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n12uxr217i3bjzn1s4ttqbcrcw1v.htm">NOTIFICATION_TARGETING_REQUEST</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1w99mkn8kc1hfn1iv0avosi1i26.htm">OUTBOUND_SYSTEM</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1wqzw6ibse1qdn1mvggb0lnz239.htm" target="_self">ORDER_DETAILS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1nq9pv7wpb3b1n1sonhyevw1grq.htm" target="_self">ORDER_SUMMARY</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1dzcnn3jya43ln1pc2pmycdayla.htm">PAGE_ERRORS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1533bbdazxcq5n1p4uciico0ngp.htm">PRODUCT_VIEWS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0czyd6ul0d9fan1xgefn5s5rgir.htm" target="_self">PROMOTION_DISPLAYED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0f77mzq4yi5zln1r6m7drzvbml7.htm" target="_self">PROMOTION_USED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0kttefgtvhj9jn1utroy20sbo6f.htm" target="_self">SEARCH_RESULTS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1l32gcmy8yf7sn1ath8pabt1mnn.htm" target="_self">SEARCH_RESULTS_EXT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0f9xa323t78zhn1rfj1c7g980iz.htm">SMS_MESSAGE_CLICKED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n0ka3bnxfn3z86n1szqb8om360x0.htm">SMS_MESSAGE_DELIVERED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n09pliyiibhpuzn1ib5ir141rl3n.htm">SMS_MESSAGE_FAILED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1oy311a7yygncn1q6jsh8sa8dvt.htm">SMS_MESSAGE_REPLY</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1tud9fi3hulj2n1qmibbz5wvdrx.htm">SMS_MESSAGE_SEND</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n1k9skuosq92o7n1gscxgtnmka1r.htm">SMS_OPTOUT</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p1653n6dsmqx7qn16p6gx7ngzxks.htm">SMS_OPTOUT_DETAILS</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=n06zalac500e8qn1w19lfwj93vjd.htm">SPOT_CLICKED</A></P> <P><A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=p0v381mw4ytb2bn19gk982tu1ej4.htm">SPOT_REQUESTED</A></P> </TD> <TD width="360" style="width: 360px; vertical-align: top;"> <P> </P> <P> </P> <P>Primary key or composite key information is added.</P> <P> </P> <P>When the column is a primary key or part of the table's composite key, that information is conveyed in these ways:</P> <P> </P> <UL> <LI>In the JSON schema, the primary_key attribute is set to true.</LI> <LI>In the Help Center, the following icon is displayed next to the column's name: <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Will_F_SAS_0-1759927356141.png" style="width: 200px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/110510iFBF8B78A5E034895/image-size/small?v=v2&px=200" role="button" title="Will_F_SAS_0-1759927356141.png" alt="Will_F_SAS_0-1759927356141.png" /></span></LI> </UL> </TD> </TR> </TBODY> </TABLE> <P> </P> <H1>Updates to the CDM</H1> <H1> </H1> <H1>New Table</H1> <P>The <A href="https://documentation.sas.com/?cdcId=cintcdc&cdcVersion=production.a&docsetId=cintdd&docsetTarget=db-cdm-audience.htm#p0mmrtogt0gepvn1k0ra0vl7u1x2">CDM_AUDIENCE_X_SEGMENT</A> table contains metadata about published audiences and the related segments.</P> <P> </P> Mon, 20 Apr 2026 16:18:26 GMT https://communities.sas.com/t5/SAS-Customer-Intelligence/Updates-for-Schema-19-in-the-UDM-for-SAS-Customer-Intelligence/m-p/976642#M2087 Will_F_SAS 2026-04-20T16:18:26Z