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.
|
Column Name |
Data Type |
Label |
Description |
Schema First Introduced |
|---|---|---|---|---|
|
rtc_id |
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.
|
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 |
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 |