Updates in Schema 10 for SAS Customer Intelligence 360

[Will_F_SAS]

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.