DOCUMENTATION
Sign In

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

 

CDM Task Tables

CDM_TASK_CUSTOM_ATTR (Non-partitioned)

This table contains custom properties defined by a user for published tasks.

Data for this table is obtained from the MD_TASK_CUSTOM_PROP table.

CDM_TASK_CUSTOM_ATTR

Column Name

Data Type

Label

Description

Schema First Introduced

task_version_id Primary key

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 part of the composite key. It is also the foreign key to the CDM_TASK_DETAIL table.

6

attribute_nm Primary key

VARCHAR(256)

Task Custom Attribute

Name of the custom property of an item.

This column is part of the composite key.

6

attribute_data_type_cd Primary key

VARCHAR(30)

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

Custom Task Attribute Value — Character

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

6

attribute_numeric_val

DECIMAL(17,2)

Custom Task Attribute Value — Numeric

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

6

attribute_dttm_val

TIMESTAMP

Custom Task Attribute Value — Date

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

6

extension_attribute_nm

VARCHAR(256)

Extension Attribute Name

Legacy CDM.CI_COMMUNICATION_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 for when the row was most recently modified. This value typically defaults to the current system timestamp when the row was updated in the database.

This field is mandatory.

6

task_id

VARCHAR(36)

Task ID

Unique identifier for the task.

8

CDM_TASK_DETAIL (Non-partitioned)

This table contains metadata about published tasks.

Data for this table is obtained from the MD_TASK table.

CDM_TASK_DETAIL

Column Name

Data Type

Label

Description

Schema First Introduced

task_version_id Primary key

VARCHAR(36)

Task Version ID

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 primary key.

6

task_id

VARCHAR(36)

Task ID

Unique ID for a task.

6

valid_from_dttm

TIMESTAMP

Task Valid From Datetime

Timestamp when an item was published.

6

valid_to_dttm

TIMESTAMP

Task 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

task_nm

VARCHAR(256)

Task Name

Name of the task.

6

task_desc

VARCHAR(1500)

Task Description

Description of the task.

6

task_type_nm

VARCHAR(40)

Task Type

Type of task (for example, single or A/B test).

6

task_status_cd

VARCHAR(20)

Task Status

Publish status of the task. These are the possible values:

  • active
  • completed
  • 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

task_subtype_nm

VARCHAR(100)

Task SubType

Subtype for the task. These are the possible values:

  • spot
  • pushNotification
  • inApp

6

task_cd

VARCHAR(60)

Task Code

Code assigned to the task in order to map to external applications.

6

task_delivery_type_nm

VARCHAR(60)

Task Delivery Type

Type of mechanism used to generate the task.

6

active_flg

CHAR(1)

Active Flag

Flag (1/0) indicating whether the item is active.

6

saved_flg

CHAR(1)

Saved Flag

Flag (1/0) indicating whether the flag is saved.

6

published_flg

CHAR(1)

Published Flag

Flag (1/0) indicating whether the item is published.

Note: All items from SAS Customer Intelligence 360 are published.

6

owner_nm

VARCHAR(256)

Note: The length of the column was updated in schema 16.

Task Published By User

User that modified the item.

6

modified_status_cd

VARCHAR(20)

Modified Status

Timestamp of when an item was published.

6

created_user_nm

VARCHAR(256)

Note: The length of the column was updated in schema 16.

Task Created By User

User that created the item.

6

created_dt

DATE

Created Date

Date the task was created.

6

scheduled_start_dttm

TIMESTAMP

Task Schedule Start Date

Timestamp when the schedule for the task begins.

6

scheduled_end_dttm

TIMESTAMP

Task Schedule End Date

Timestamp when the schedule for the task ends

6

scheduled_flg

CHAR(1)

Task Scheduled Flag

Flag (1/0) indicating whether the task is scheduled.

6

maximum_period_expression_cnt

INT

Task Impression Capping By Period

Maximum time period for capping impressions.

6

limit_period_unit_cnt

INT

Task Limit Period Unit

Numeric value (such as the number of minutes) based on the unit of time selected.

6

limit_by_total_impression_flg

INT

Note: In the JSON schema file, this column's type is currently listed incorrectly as CHAR(1).

Task Impressions Life Time Limit

Maximum number of impressions for the task.

6

export_dttm

TIMESTAMP

Export Datetime

Datetime that the communication was last exported.

6

update_contact_history_flg

CHAR(1)

Update Contact History Flag

Flag (1/0) indicating whether a communication is expected to have a contact history. In SAS Campaign Studio, the contact history can be specified for the communication. The communication is published to the CDM regardless of this value.

6

subject_type_nm

VARCHAR(60)

Subject Type

Subject type (household, customer, or account) associated with the communication.

6

min_budget_offer_amt

DECIMAL(17,2)

Minimum Budget Per Offer Constraint

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 offer used in conjunction with SAS Customer Intelligence Studio.

6

max_budget_amt

DECIMAL(17,2)

Maximum Budget Per Campaign Amount

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

6

budget_unit_cost_amt

DECIMAL(17,2)

Budget Unit Cost Amount

Budget unit cost amount used in conjunction with SAS Customer Intelligence Studio.

6

recurr_type_cd

VARCHAR(3)

Recurring Type

Primary key code for a communication recurrence type. Examples of supplied values are "N" (None), "H" (Hourly), "D" (Daily), "W" (Weekly), "M" (Monthly), and "O" (Other).

6

budget_unit_usage_amt

DECIMAL(17,2)

Budget Unit Usage Amount

Budget unit usage amount used in conjunction with SAS Customer Intelligence Studio.

6

standard_reply_flg

CHAR(1)

Standard Reply Flag

Flag (Y/N) indicating whether the communication is part of a standard reply decision campaign.

6

staged_flg

CHAR(1)

Staged Offer Flag

Flag (Y/N) indicating whether the communication is for treatment staging.

6

contact_channel_cd

VARCHAR(60)

Task Channel

Channel where the task is being executed.

This column can be set as the foreign key to the CDM_CONTACT_CHANNEL table, but the constraint is disabled by default.

6

campaign_id

VARCHAR(36)

Campaign ID

Unique identifier for a campaign item.

This column is the foreign key to the CDM_CAMPAIGN_DETAIL table.

6

business_context_id

VARCHAR(36)

Business Context Name

Unique identifier used to define a business context.

This column is the foreign key to the CDM_BUSINESS_CONTEXT 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 for when the row was most recently modified. This value typically defaults to the current system timestamp when the row was updated in the database.

This field is mandatory.

6

recurring_schedule_flg

CHAR(1)

Task Recurring Schedule

Flag (Y/N) indicating whether the task is part of a recurring schedule.

8

control_group_action_nm

VARCHAR(65)

Control Group Action Name

The action that is performed when the segment size is too small to populate the holdout control group.

These are the possible values:

  • useEntirePopulation
  • failTaskExecution

10

stratified_sampling_action_nm

VARCHAR(65)

Stratified Sampling Action Name

The action that is performed when the holdout control group is too small to apply stratified sampling.

These are the possible values:

  • useEntirePopulation
  • failTaskExecution
  • useRandomSelection

10

segment_tests_flg

CHAR(1)

Segment Tests Flag

Flag (1/0) that indicates that both of these settings are true:

  • segment tests are enabled for the direct marketing task
  • one or more segments tests are defined and enabled

10

Last updated: August 18, 2026