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

[Will_F_SAS]

In the 22.07 release of SAS Customer Intelligence 360, the Unified Data Model (UDM) will be updated to use the data model for schema 9. Schema 9 introduces enhancements to usage metrics for REST APIs, cross-table information, and new tables for cost-center budgeting in SAS 360 Plan.

These are updates to the existing tables in the UDM:

Table Name	Updates
EMAIL_OPEN	One column was added: prefetched_flg This column indicates whether the email open event was triggered automatically (prefetched) by the mail provider. Prefetching email information is common if the email recipient is using an iOS device and has activated Apple’s Mail Privacy Protection feature (MPP).
DAILY_USAGE	One column was added: api_usage_cnt This column contains information about the calls to REST API endpoints in SAS Customer Intelligence 360.
MONTHLY_USAGE	One column was added: api_usage_cnt This column contains information about the calls to REST API endpoints in SAS Customer Intelligence 360.
MD_SEGMENT_MAP_X_SEGMENT	One column was added: segment_version_id This column contains the version ID for a segment. You can use this new column to join records from the CDM_SEGMENT_DETAIL table in the CDM.
PLANNING_INFO	One column was added: parent_id This column contains the ID of the record’s parent item.

These are the new tables for SAS 360 Plan:

Table Name	Updates
CC_BUDGET_BREAKUP_CCBDGT	This table contains information about cost-center budgets when you are using cost-center based budgeting.
COMMITMENT_LINE_ITEMS_CCBDGT	This table contains information about line items in commitments that are used in cost-center budgeting.
FISCAL_CC_BUDGET	This table contains information about fiscal periods that are used for cost-center budgeting.
INVOICE_LINE_ITEMS_CCBDGT	This table contains information about line items in an invoice that is used in cost-center budgeting.
MD_FISCAL_PERIOD	This table contains metadata about fiscal periods for SAS 360 Plan.