CDM Response Tracking Code Tables

These tables contain information about response tracking codes (RTC). For more information, see Tracking Task Content in SAS Customer Intelligence 360: User’s Guide.

CDM_RTC_DETAIL (Non-partitioned)

This table contains metadata about RTCs. Use this table to link response history and contact history with an RTC.

Data for this table is obtained from the MD_RTC table.

CDM_RTC_DETAIL

Column Name

Data Type

Label

Description

Schema First Introduced

rtc_id Primary key

VARCHAR(36)

Response Tracking Code ID

Unique identifier that describes the package that was presented or responded to. The package represents tasks, segments, messages, creatives, occurrences, and item versions.

This column is the primary key.

6

task_occurrence_no

INT

Task Occurrence Number

Numeric value of a task that has execution history.

6

processed_dttm

TIMESTAMP

Processed Datetime

Timestamp for the response tracking code.

6

response_tracking_flg

CHAR(1)

Response Tracking Flag

Flag (1/0) that indicates whether the response tracking code is generated by the loading process.

6

segment_version_id

VARCHAR(36)

Segment Version ID

Version of the segment based on publishing. Each subsequent successful execution of the segment map adds a new version ID.

This column is the foreign key to the CDM_SEGMENT_DETAIL table.

6

task_version_id

VARCHAR(36)

Task Version ID

The version of the task that is based on which instance of the task is published. Each subsequent publish adds a new version ID.

This column is the foreign key to the CDM_TASK_DETAIL table.

6

execution_status_cd

VARCHAR(30)

Execution Status

For bulk tasks and segment maps, this value is the status of the occurrence (in progress, success, or failure).

For triggered tasks, this value is empty.

6

deleted_flg

CHAR(1)

Deleted Flag

Flag (1/0) that indicates when an administrator manually marks an response tracking code as deleted on premises.

6

occurrence_id

VARCHAR(36)

Occurrence ID

Automatically generated identifier that ties to a unique occurrence.

This column is the foreign key to the CDM_OCCURRENCE_DETAIL table.

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

segment_id

VARCHAR(36)

Segment ID

Unique ID that represents a segment.

8

task_id

VARCHAR(36)

Task ID

Unique identifier for the task.

8

CDM_RTC_X_CONTENT (Non-partitioned)

Use this table to see which content (creatives, messages, or treatments from SAS Customer Intelligence Studio) is associated with a particular RTC.

Data for this table is obtained from the MD_RTC table.

CDM_RTC_X_CONTENT

Column Name

Data Type

Label

Description

Schema First Introduced

rtc_x_content_sk

VARCHAR(36)

RTC Content Surrogate Key

Surrogate key that connects the response tracking code to content.

This column is part of the composite key.

Note: In the downloaded tables, this column contains null values. If you use the CDM loader program, the CDM_BUILD_KEYS macro generates unique values for this column when the data is loaded.

6

rtc_id Primary key

VARCHAR(36)

Response Tracking Code ID

Unique identifier that describes the package that was presented or responded to. The package represents tasks, segments, messages, creatives, occurrences, and item versions.

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

6

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.

Note: In the downloaded tables, this column contains null values.

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

6

content_hash_val

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).

6

sequence_no

INT

Sequence Number

Order of the treatment within the package.

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 identifier for the creative, message, or treatment.

8

Last updated: November 2, 2026