CDM Audience Tables

Note: If you use the CDM loader program, the cdm_load_datastep.sas macro load utility populates the source_system_cd column, updated_by_nm column, and updated_dttm column as they are loaded into the database. These columns are null in the downloaded data set but are updated during the loading process.

If you do not use the CDM loader program and you have site-specific code to load into the on-premises database, you must populate the source_system_cd column and updated_dttm column (and optionally the updated_by_nm column) when you load the data. The updated_dttm column is required and is populated by the cloud process for partitioned tables only. However, this column remains null for non-partitioned tables.

CDM_AUDIENCE_DETAIL (Non-partitioned)

This table contains information about audiences. For more information, see About Audiences in SAS Customer Intelligence 360: User’s Guide.

Data for this table is obtained from the MD_AUDIENCE table.

CDM_AUDIENCE_DETAIL
Column Name	Data Type	Label	Description	Schema First Introduced
audience_id	VARCHAR(36)	Audience ID	Unique ID that represents the audience in SAS Customer Intelligence 360.	16
audience_nm	VARCHAR(128)	Audience Name	Name of the audience	16
audience_desc	VARCHAR(1332)	Audience Description	Description of the audience	16
created_user_nm	VARCHAR(256)	Audience Created By User	User that created the audience	16
audience_schedule_flg	CHAR(1)	Audience Schedule Flag	Specifies whether the audience is run on a schedule: `0` means that the audience does not have a schedule. `1` means that the audience is run on a schedule.	16
audience_source_nm	VARCHAR(100)	Audience Source Name	Name of the table that is used as the audience source	16
audience_data_source_nm	VARCHAR(100)	Audience Data Source Name	Name of the data source that is used in an audience	16
create_dttm	TIMESTAMP	Audience Creation Datetime	Timestamp of when the audience was created	16
delete_dttm	TIMESTAMP	Audience Deletion Datetime	Timestamp of when the audience was deleted	16
updated_dttm	TIMESTAMP	Updated DTTM	Timestamp of when the record was updated in the database.	16

CDM_AUDIENCE_OCCUR_DETAIL (Non-partitioned)

This table contains metadata about published audiences. For more information, see About Audiences in SAS Customer Intelligence 360: User’s Guide.

Data for this table is obtained from the MD_AUDIENCE table.

CDM_AUDIENCE_OCCUR_DETAIL
Column Name	Data Type	Label	Description	Schema First Introduced
audience_id	VARCHAR(36)	Audience ID	Unique ID that represents the audience in SAS Customer Intelligence 360.	16
audience_occur_id	VARCHAR(36)	Audience Occurrence Id	Unique ID that represents the specific occurrence for an audience in SAS Customer Intelligence 360.	16
execution_status_cd	VARCHAR(100)	Audience Occurrence Status	Status of the occurrence	16
audience_size_cnt	INT	Audience Size	Size of the audience occurrence	16
started_by_nm	VARCHAR(256)	Started By	User that ran the audience	16
occurrence_type_nm	VARCHAR(100)	Type of Occurrence	Specifies how the occurrence was triggered (either through a schedule or manually)	16
start_dttm	TIMESTAMP	Start Time	Start time for when the occurrence was run	16
end_dttm	TIMESTAMP	Audience Creation Datetime	End time for when the occurrence was run	16
updated_dttm	TIMESTAMP	Updated DTTM	Timestamp of when the record was updated in the database.	16

CDM_AUDIENCE_X_SEGMENT (Non-partitioned)

This table contains metadata about published audiences and the related segments. For more information, see About Audiences in SAS Customer Intelligence 360: User’s Guide.

Data for this table is obtained from the MD_AUDIENCE table and the MD_SEGMENT table.

CDM_AUDIENCE_X_SEGMENT
Column Name	Data Type	Label	Description	Schema First Introduced
audience_id	VARCHAR(36)	Audience ID	Unique ID that represents the audience in SAS Customer Intelligence 360.	19
segment_id	VARCHAR(36)	Segment Id	Unique ID for a segment.	19

Last updated: August 18, 2026