<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Updates for Schema 15 in the UDM for SAS Customer Intelligence 360 in SAS Customer Intelligence</title>
    <link>https://communities.sas.com/t5/SAS-Customer-Intelligence/Updates-for-Schema-15-in-the-UDM-for-SAS-Customer-Intelligence/m-p/920923#M1985</link>
    <description>&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Starting with the release for March 20th, SAS Customer Intelligence 360 includes updates to the Unified Data Model (UDM) for schema 15. Schema 15 contains enhancements to support these features:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Added additional channel metrics to the DAILY_USAGE table and MONTHLY_USAGE table.&lt;/LI&gt;
&lt;LI&gt;New columns for EMAIL_OPEN table and EMAIL_CLICK tables to include more information about how the email is accessed.&lt;/LI&gt;
&lt;LI&gt;New columns in the EMAIL_BOUNCE table to include the reason code and raw reason text from Sparkpost.&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;These are updates to the existing tables in the UDM:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;TABLE width="659"&gt;
&lt;THEAD&gt;
&lt;TR&gt;
&lt;TD width="272"&gt;
&lt;P&gt;&lt;STRONG&gt;Table&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="387"&gt;
&lt;P&gt;&lt;STRONG&gt;Updates&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="272"&gt;
&lt;P&gt;&lt;A href="https://documentation.sas.com/?cdcId=cintcdc&amp;amp;cdcVersion=production.a&amp;amp;docsetId=cintdd&amp;amp;docsetTarget=n12e5d37akj4ann133t5jpf2czdv.htm" target="_self"&gt;DAILY_USAGE&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&lt;A href="https://documentation.sas.com/?cdcId=cintcdc&amp;amp;cdcVersion=production.a&amp;amp;docsetId=cintdd&amp;amp;docsetTarget=n03gn66att2m3pn1pb5estnbndvl.htm" target="_self"&gt;MONTHLY_USAGE&lt;/A&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="387"&gt;
&lt;P&gt;These columns are added:&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;mobile_push_cnt&lt;/LI&gt;
&lt;LI&gt;mobile_in_app_msg_cnt&lt;/LI&gt;
&lt;LI&gt;facebook_ads_cnt&lt;/LI&gt;
&lt;LI&gt;google_ads_cnt&lt;/LI&gt;
&lt;LI&gt;linkedin_ads_cnt&lt;/LI&gt;
&lt;LI&gt;outbound_api_cnt&lt;/LI&gt;
&lt;/UL&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="272"&gt;
&lt;P&gt;&lt;A href="https://documentation.sas.com/?cdcId=cintcdc&amp;amp;cdcVersion=production.a&amp;amp;docsetId=cintdd&amp;amp;docsetTarget=n1o5zf8y7p8zyen1hspzjhfu6pzl.htm"&gt;EMAIL_BOUNCE&lt;/A&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="387"&gt;
&lt;P&gt;These columns are added:&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;raw_reason_txt&lt;/LI&gt;
&lt;LI&gt;bounce_class_cd&lt;/LI&gt;
&lt;/UL&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="272"&gt;
&lt;P&gt;&lt;A href="https://documentation.sas.com/?cdcId=cintcdc&amp;amp;cdcVersion=production.a&amp;amp;docsetId=cintdd&amp;amp;docsetTarget=p0fd7e82b1wyocn1knkrt7jsvzm1.htm"&gt;EMAIL_CLICK&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&lt;A href="https://documentation.sas.com/?cdcId=cintcdc&amp;amp;cdcVersion=production.a&amp;amp;docsetId=cintdd&amp;amp;docsetTarget=p0s10gwoj3kn77n1m468vvdl3ain.htm"&gt;EMAIL_OPEN&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="387"&gt;
&lt;P&gt;These columns are added:&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;click_tracking_flg&lt;/LI&gt;
&lt;LI&gt;mailbox_provider_nm&lt;/LI&gt;
&lt;LI&gt;open_tracking_flg&lt;/LI&gt;
&lt;LI&gt;user_agent_nm&lt;/LI&gt;
&lt;LI&gt;agent_family_nm&lt;/LI&gt;
&lt;LI&gt;manufacturer_nm&lt;/LI&gt;
&lt;LI&gt;device_nm&lt;/LI&gt;
&lt;LI&gt;is_mobile_flg&lt;/LI&gt;
&lt;LI&gt;platform_desc&lt;/LI&gt;
&lt;LI&gt;platform_version&lt;/LI&gt;
&lt;/UL&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;/THEAD&gt;
&lt;/TABLE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Sat, 18 Apr 2026 18:43:32 GMT</pubDate>
    <dc:creator>Will_F_SAS</dc:creator>
    <dc:date>2026-04-18T18:43:32Z</dc:date>
    <item>
      <title>Updates for Schema 15 in the UDM for SAS Customer Intelligence 360</title>
      <link>https://communities.sas.com/t5/SAS-Customer-Intelligence/Updates-for-Schema-15-in-the-UDM-for-SAS-Customer-Intelligence/m-p/920923#M1985</link>
      <description>&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Starting with the release for March 20th, SAS Customer Intelligence 360 includes updates to the Unified Data Model (UDM) for schema 15. Schema 15 contains enhancements to support these features:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Added additional channel metrics to the DAILY_USAGE table and MONTHLY_USAGE table.&lt;/LI&gt;
&lt;LI&gt;New columns for EMAIL_OPEN table and EMAIL_CLICK tables to include more information about how the email is accessed.&lt;/LI&gt;
&lt;LI&gt;New columns in the EMAIL_BOUNCE table to include the reason code and raw reason text from Sparkpost.&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;These are updates to the existing tables in the UDM:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;TABLE width="659"&gt;
&lt;THEAD&gt;
&lt;TR&gt;
&lt;TD width="272"&gt;
&lt;P&gt;&lt;STRONG&gt;Table&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="387"&gt;
&lt;P&gt;&lt;STRONG&gt;Updates&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="272"&gt;
&lt;P&gt;&lt;A href="https://documentation.sas.com/?cdcId=cintcdc&amp;amp;cdcVersion=production.a&amp;amp;docsetId=cintdd&amp;amp;docsetTarget=n12e5d37akj4ann133t5jpf2czdv.htm" target="_self"&gt;DAILY_USAGE&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&lt;A href="https://documentation.sas.com/?cdcId=cintcdc&amp;amp;cdcVersion=production.a&amp;amp;docsetId=cintdd&amp;amp;docsetTarget=n03gn66att2m3pn1pb5estnbndvl.htm" target="_self"&gt;MONTHLY_USAGE&lt;/A&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="387"&gt;
&lt;P&gt;These columns are added:&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;mobile_push_cnt&lt;/LI&gt;
&lt;LI&gt;mobile_in_app_msg_cnt&lt;/LI&gt;
&lt;LI&gt;facebook_ads_cnt&lt;/LI&gt;
&lt;LI&gt;google_ads_cnt&lt;/LI&gt;
&lt;LI&gt;linkedin_ads_cnt&lt;/LI&gt;
&lt;LI&gt;outbound_api_cnt&lt;/LI&gt;
&lt;/UL&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="272"&gt;
&lt;P&gt;&lt;A href="https://documentation.sas.com/?cdcId=cintcdc&amp;amp;cdcVersion=production.a&amp;amp;docsetId=cintdd&amp;amp;docsetTarget=n1o5zf8y7p8zyen1hspzjhfu6pzl.htm"&gt;EMAIL_BOUNCE&lt;/A&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="387"&gt;
&lt;P&gt;These columns are added:&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;raw_reason_txt&lt;/LI&gt;
&lt;LI&gt;bounce_class_cd&lt;/LI&gt;
&lt;/UL&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="272"&gt;
&lt;P&gt;&lt;A href="https://documentation.sas.com/?cdcId=cintcdc&amp;amp;cdcVersion=production.a&amp;amp;docsetId=cintdd&amp;amp;docsetTarget=p0fd7e82b1wyocn1knkrt7jsvzm1.htm"&gt;EMAIL_CLICK&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&lt;A href="https://documentation.sas.com/?cdcId=cintcdc&amp;amp;cdcVersion=production.a&amp;amp;docsetId=cintdd&amp;amp;docsetTarget=p0s10gwoj3kn77n1m468vvdl3ain.htm"&gt;EMAIL_OPEN&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="387"&gt;
&lt;P&gt;These columns are added:&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;click_tracking_flg&lt;/LI&gt;
&lt;LI&gt;mailbox_provider_nm&lt;/LI&gt;
&lt;LI&gt;open_tracking_flg&lt;/LI&gt;
&lt;LI&gt;user_agent_nm&lt;/LI&gt;
&lt;LI&gt;agent_family_nm&lt;/LI&gt;
&lt;LI&gt;manufacturer_nm&lt;/LI&gt;
&lt;LI&gt;device_nm&lt;/LI&gt;
&lt;LI&gt;is_mobile_flg&lt;/LI&gt;
&lt;LI&gt;platform_desc&lt;/LI&gt;
&lt;LI&gt;platform_version&lt;/LI&gt;
&lt;/UL&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;/THEAD&gt;
&lt;/TABLE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Sat, 18 Apr 2026 18:43:32 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Customer-Intelligence/Updates-for-Schema-15-in-the-UDM-for-SAS-Customer-Intelligence/m-p/920923#M1985</guid>
      <dc:creator>Will_F_SAS</dc:creator>
      <dc:date>2026-04-18T18:43:32Z</dc:date>
    </item>
  </channel>
</rss>

