CDM Content Tables

CDM_CONTENT_CUSTOM_ATTR (Non-partitioned)

This table represents the custom property metadata associated with messages, creatives, and treatments from SAS Customer Intelligence Studio. For more information, see Custom Properties in SAS Customer Intelligence 360: User’s Guide.

Data for this table is obtained from the following tables: MD_CREATIVE_CUSTOM_PROP and MD_MESSAGE_CUSTOM_PROP.

CDM_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	VARCHAR(256)	Custom Content Attribute Name	Name of the custom property of an item. This column is part of the composite key.	6
attribute_data_type_cd	VARCHAR(30)	Custom Content 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	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 Content Attribute Value — Character	Value (string) of the custom property of an item.	6
attribute_numeric_val	DECIMAL(17,2)	Custom Content Attribute Value — Numeric	Value (numeric) of the custom property of an item.	6
attribute_dttm_val	TIMESTAMP	Custom Content Attribute 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

CDM_CONTENT_DETAIL (Non-partitioned)

This table contains metadata about messages and creatives from SAS Customer Intelligence 360 and treatments from SAS Customer Intelligence Studio.

Data for this table is obtained from the following tables: MD_CREATIVE and MD_MESSAGE.

CDM_CONTENT_DETAIL
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 the primary key.	6
content_id	VARCHAR(40)	Content ID	Unique item identifier for the creative, message, or treatment.	6
valid_from_dttm	TIMESTAMP	Content Valid From Datetime	Timestamp when an item was published.	6
valid_to_dttm	TIMESTAMP	Content 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
contact_content_nm	VARCHAR(256)	Content Name	Name of the creative, message, or treatment.	6
contact_content_desc	VARCHAR(1500)	Content Description	Description of the creative, message, or treatment.	6
contact_content_type_nm	VARCHAR(50)	Content Type Name	Defines when an item is a creative, message, or treatment.	6
contact_content_status_cd	VARCHAR(60)	Content Status	Publish status of the creative, message, or treatment (active, completed, or history). When the value is `history`, the data is for a previous version of that item. When the value is `completed`, the item is either complete, manually stopped, or deleted.	6
contact_content_category_nm	VARCHAR(256)	Content Category	Category assigned to the creative, message, or treatment by the user.	6
contact_content_class_nm	VARCHAR(100)	Content Class	Content classification (for example, creative, message, or treatment).	6
contact_content_cd	VARCHAR(60)	Content Code	Code assigned to the creative, message, or treatment in order to map to external applications.	6
active_flg	CHAR(1)	Active Flag	Flag (1/0) that indicates whether the item is active.	6
owner_nm	VARCHAR(256) Note: The length of the column was updated in schema 16.	Content Published By User	User that modified the item.	6
created_user_nm	VARCHAR(256) Note: The length of the column was updated in schema 16.	Content Created By User	User that created the item.	6
created_dt	DATE	Created Date	Date that the item was created.	6
external_reference_txt	VARCHAR(1024)	External Reference	Displayed text of the link to an external file such as an image, spreadsheet, or Microsoft Word document (for example, a ski resort logo for a winter coupon).	6
external_reference_url_txt	VARCHAR(1024)	External Reference URL	URL of the link to an external file such as an image, spreadsheet, or Microsoft Word document.	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

Last updated: November 2, 2026