Updates in Schema 10 for SAS Customer Intelligence 360

Will_F_SAS — Thu, 29 Sep 2022 15:36:40 GMT

In the 22.10 release of SAS Customer Intelligence 360, the Common Data Model (CDM) and the Unified Data Model (UDM) are updated with the schema 10 data model. Schema 10 primarily contains enhancements to support holdout control groups.

Updates to the UDM

These are updates to the existing tables in the UDM:

Table	Updates
CONTACT_HISTORY	One column was added: control_group_flg This value is a flag (1/0) that specifies whether the user is part of a control group.
DAILY_USAGE	One column was added: admin_user_cnt This value is the number of administrative users that accessed the REST API.
MONTHLY_USAGE	One column was added: admin_user_cnt This value is the number of administrative users that accessed the REST API.
DIRECT_CONTACT	These columns were added: · control_group_flg · segment_id
MD_TASK	These columns are added: · control_group_action_nm · stratified_sampling_action_nm · segment_tests_flg These columns contain testing information for members of holdout control groups.

These are the new tables in the UDM:

Table

Updates

MD_SEGMENT_TEST

This table contains the metadata for segment tests related to holdout control groups.

MD_SEGMENT_TEST_X_SEGMENT

This table collects metadata information about the relationships between segment tests, the related tasks, and their targeted segments.

Updates to the CDM

These are updates to the existing tables in the CDM:

Table	Updates
CDM_CONTACT_HISTORY	One column was added: control_group_flg This value is a flag (1/0) that specifies whether the user is part of a control group.
CDM_RESPONSE_HISTORY	One column was added: properties_map_doc This column is currently not populated, but it is a placeholder for future use.
CDM_TASK_DETAIL	These columns are added: · control_group_action_nm · stratified_sampling_action_nm · segment_tests_flg These columns contain testing information for members of control groups.

These are the new tables in the CDM:

Table

Updates

CDM_SEGMENT_TEST

This table contains the metadata for segment tests that are related to holdout control groups.

CDM_SEGMENT_TEST_X_SEGMENT

This table collects metadata information about the relationships between segment tests, the related tasks, and their targeted segments.

topic Updates in Schema 10 for SAS Customer Intelligence 360 in SAS Customer Intelligence

Updates in Schema 10 for SAS Customer Intelligence 360

Updates to the UDM

Updates to the CDM