DOCUMENTATION
Sign In

Get access to My SAS, trials, communities and more.

 

CDM Tables Supporting SAS Customer Intelligence Studio

These tables make it possible to use SAS Customer Intelligence 360 in parallel with SAS Customer Intelligence Studio. Contact your SAS representative for more information.

Note: These tables are in the schema, but are not currently available for download. Customers who are interested in getting access to the CDM data need to contact SAS Technical Support and request that the CDM jobs are enabled for their tenants.

CDM_CAMPAIGN_CUSTOM_ATTR (Non-partitioned)

Data for this table is obtained from the user-defined field tables in SAS Customer Intelligence Studio that describe campaigns and campaign pages. SAS creates scripts that migrate data from SAS Customer Intelligence Studio to SAS Customer Intelligence 360. These tables are always empty because the data is always on premises.

CDM_CAMPAIGN_CUSTOM_ATTR

Column Name

Data Type

Label

Description

Schema First Introduced

campaign_id Primary key

VARCHAR(36)

Campaign ID

Unique identifier for the campaign.

This column is part of the composite key. It is also the foreign key to the CDM_CAMPAIGN_DETAIL table.

6

attribute_nm Primary key

VARCHAR(256)

Attribute Name

Name of the custom property of an item.

This column is part of the composite key.

6

page_nm Primary key

VARCHAR(60)

Page Name

Name of the campaign group checklist item.

This column is part of the composite key.

6

attribute_data_type_cd Primary key

VARCHAR(30)

Custom Campaign Attribute Data Type

Data type of the custom property of an item.

These are the possible values:

  • BOOLEAN
  • DATETIME
  • DATEONLY

    Note: This value corresponds to custom properties that are defined with a data type value of DATE.

  • DOUBLE
  • INTEGER
  • TEXT

This column is part of the composite key.

6

attribute_val Primary key

VARCHAR(1500)

Attribute Value

This column is no longer populated.

Instead, one of the following columns are populated based on the type of custom property:

  • attribute_character_val
  • attribute_dttm_val
  • attribute_numeric_val

6

attribute_character_val

VARCHAR(1500)

Custom Campaign Attribute Value — Character

Value (string) of the custom property of an item.

6

attribute_numeric_val

DECIMAL(17,2)

Attribute Numeric Value

Value (numeric) of the custom property of an item.

6

attribute_dttm_val

TIMESTAMP

Custom Campaign Attribute Value — Date

Value (date) of the custom property of an item.

6

extension_attribute_nm

VARCHAR(256)

Extension Attribute Name

Legacy CDM.CI_CAMPAIGN_EXT variable name.

6

updated_by_nm

VARCHAR(60)

Updated by Name

User ID/name or process ID/name that is updating the table.

This field is optional.

6

updated_dttm

TIMESTAMP

Updated DTTM

Timestamp when the row was interacted with in the database. Typically defaults to the current system timestamp in the database.

This field is mandatory.

6

CDM_CAMPAIGN_DETAIL (Non-partitioned)

Data for this table is obtained from the CI_CAMPAIGN table in SAS Customer Intelligence Studio that describes campaigns and campaign pages. SAS creates scripts that migrate data from SAS Customer Intelligence Studio to SAS Customer Intelligence 360. These tables are always empty because the data is always on premises.

CDM_CAMPAIGN_DETAIL

Column Name

Data Type

Label

Description

Schema First Introduced

campaign_id Primary key

VARCHAR(36)

Campaign ID

Unique identifier for the campaign.

This column is the primary key.

6

campaign_version_no

INT

Campaign Version Number

Number incremented each time a new version of a campaign is created.

6

valid_from_dttm

TIMESTAMP

Campaign Valid From Datetime

Timestamp when an item was published.

6

valid_to_dttm

TIMESTAMP

Campaign Valid To Datetime

Timestamp when an item was ended.

The value of the column is based on the item's status:

  • For active items, the value is blank.
  • For completed items, the value is the date that the item is marked complete.

6

campaign_nm

VARCHAR(60)

Campaign Name

Name of the campaign.

6

campaign_desc

VARCHAR(1500)

Campaign Description

Description of the campaign.

6

campaign_cd

VARCHAR(60)

Campaign Code

Campaign code that functions as a business key. The value can either be specified or can be generated by SAS Customer Intelligence.

6

campaign_owner_nm

VARCHAR(60)

Campaign Owner

Name of the original creator of the campaign.

6

min_budget_offer_amt

DECIMAL(17,2)

Minimum Budget Per Offer Amount

Minimum budget per offer used in conjunction with SAS Customer Intelligence Studio.

6

max_budget_offer_amt

DECIMAL(17,2)

Maximum Budget Per Offer Amount

Maximum budget per offer used in conjunction with SAS Customer Intelligence Studio.

6

min_budget_amt

DECIMAL(17,2)

Minimum Budget Per Campaign Amount

Minimum budget per campaign. Used in SAS Customer Intelligence Studio.

6

max_budget_amt

DECIMAL(17,2)

Maximum Budget Per Campaign Amount

Minimum budget per campaign. Used in SAS Customer Intelligence Studio.

6

start_dttm

TIMESTAMP

Starting Datetime

Contains either the starting datetime of the earliest scheduled communication occurrence within the selection campaign or the starting datetime of a decision campaign, treatment campaign, or decision flow.

6

end_dttm

TIMESTAMP

Ending Datetime

Contains either the ending datetime of the last scheduled communication occurrence within the selection campaign or the ending datetime of a decision campaign, treatment campaign, or decision flow.

6

run_dttm

TIMESTAMP

Execution Datetime

Execution datetime of the most recent communication within the campaign.

6

last_modified_dttm

TIMESTAMP

Last Modified Datetime

Last datetime that the campaign was fully or partially published.

6

approval_dttm

TIMESTAMP

Approval of Campaign Datetime

Datetime of the approval of the campaign.

6

approval_given_by_nm

VARCHAR(60)

Name of Campaign Approver

Name of the user who approved the campaign.

6

last_modified_by_user_nm

VARCHAR(60)

Last Modified User Name

Name of the user who last modified the campaign.

6

current_version_flg

CHAR(1)

Current Version Flag

Flag (Y/N) indicating whether this record is the current version of the campaign.

6

deleted_flg

CHAR(1)

Deleted Flag

Flag (Y/N) indicating whether this campaign has been deleted.

6

campaign_status_cd

VARCHAR(3)

Campaign Status

Reference key code that associates the campaign detail with a campaign detail status. The CI_CAMPAIGN_STATUS table provides values for the status codes.

6

campaign_type_cd

VARCHAR(3)

Campaign Type

Reference key code for a type of campaign. The CI_CAMPAIGN_TYPE table provides values for the campaign types.

6

campaign_folder_txt

VARCHAR(1024)

Campaign Folder

Name of the campaign folder where the campaign is stored.

6

campaign_group_sk

INT

Campaign Group Surrogate Key

Reference key that associates the campaign group checklist item with a campaign group.

6

deployment_version_no

INT

Deployment Version Number

Number of times the campaign has been marked for deployment.

6

source_system_cd

VARCHAR(10)

Source System

System that the information came from (for example, SAS Customer Intelligence 360 or SAS Customer Intelligence Studio).

This field is mandatory.

6

updated_by_nm

VARCHAR(60)

Updated by Name

User ID/name or process ID/name that is updating the table.

This field is optional.

6

updated_dttm

TIMESTAMP

Updated DTTM

Timestamp when the row was interacted with in the database. Typically defaults to the current system timestamp in the database.

This field is mandatory.

6

CDM_DYN_CONTENT_CUSTOM_ATTR (Partitioned)

This table contains dynamic attributes from SAS Customer Intelligence Studio, as well as their values. There is no data from SAS Customer Intelligence 360 stored in this table.

IMPORTANT These dynamic attributes are only from SAS Customer Intelligence Studio. SAS Customer Intelligence 360 does not support dynamic custom properties for items.
CDM_DYN_CONTENT_CUSTOM_ATTR

Column Name

Data Type

Label

Description

Schema First Introduced

content_version_id

VARCHAR(40)

Content Version ID

Version of the creative, message, or treatment based on publishing. Each subsequent publish adds a new version ID.

This column is part of the composite key. It is also the foreign key to the CDM_CONTENT_DETAIL table.

6

attribute_nm Primary key

VARCHAR(256)

Dynamic Custom Attribute

Name of the custom property of an item.

This column is part of the composite key.

6

content_hash_val Primary key

VARCHAR(32)

Content Hash Value

Hash value generated to supply a single look-up value for a combination of the dynamic custom details of a treatment (legacy only).

This column is part of the composite key.

6

attribute_data_type_cd Primary key

VARCHAR(30)

Dynamic Custom Attribute Data Type

Data type of the custom property of an item.

These are the possible values:

  • BOOLEAN
  • DATETIME
  • DATEONLY

    Note: This value corresponds to custom properties that are defined with a data type value of DATE.

  • DOUBLE
  • INTEGER
  • TEXT

This column is part of the composite key.

6

attribute_val Primary key

VARCHAR(1500)

Attribute Value

This column is no longer populated.

Instead, one of the following columns are populated based on the type of custom property:

  • attribute_character_val
  • attribute_dttm_val
  • attribute_numeric_val

6

attribute_character_val

VARCHAR(1500)

Dynamic Custom Value (Char)

Value (string) of the custom property of an item.

6

attribute_numeric_val

DECIMAL(17,2)

Dynamic Custom Value (Numeric)

Value (numeric) of the custom property of an item.

6

attribute_dttm_val

TIMESTAMP

Dynamic Custom Value (Date)

Value (date) of the custom property of an item.

6

extension_attribute_nm

VARCHAR(256)

Extension Attribute Name

Legacy CDM.CI_DYNAMIC_TREATMENT_ATTR_EXT variable name.

6

updated_by_nm

VARCHAR(60)

Updated by Name

User ID/name or process ID/name that is updating the table.

This field is optional.

6

updated_dttm

TIMESTAMP

Updated DTTM

Timestamp when the row was interacted with in the database. Typically defaults to the current system timestamp in the database.

This field is mandatory.

6

content_id

VARCHAR(40)

Content ID

Unique item identifier of the creative, message, or treatment.

8

Last updated: August 18, 2026