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.
|
