List of Data Tables by Category
- AUDIENCE
- CDM
- DEBUG
- DECISIONING
- DESTINATIONS
- DISCOVER
- ENGAGEDIGITAL
- ENGAGEDIRECT
- ENGAGEEMAIL
- ENGAGEMETADATA
- ENGAGEMOBILE
- ENGAGEWEB
- METADATA_ALL
- OPTOUTDATA
- PLAN
- SMS
- SMS_OPTOUTDATA
- USAGE
The following tables list the database tables that are available for each category, the type of table, and the schema that first included the table.
AUDIENCE
|
Table Name |
Table Type |
Schema First Introduced |
|---|---|---|
|
AUDIENCE_MEMBERSHIP_CHANGE |
Audience |
14 |
|
MD_AUDIENCE |
Audience Metadata |
12 Note: The category value is updated
to |
|
MD_AUDIENCE_OCCURRENCE |
Audience Metadata |
12 Note: The category value is updated
to |
|
MD_AUDIENCE_X_SEGMENT |
Audience Metadata |
19 |
CDM
|
Table Name |
Table Type |
Schema First Introduced |
|---|---|---|
|
CDM_ACTIVITY_CUSTOM_ATTR |
CDM |
6 |
|
CDM_ACTIVITY_DETAIL |
CDM |
6 |
|
CDM_ACTIVITY_X_TASK |
CDM |
6 |
|
CDM_AUDIENCE_DETAIL |
CDM |
16 |
|
CDM_AUDIENCE_OCCUR_DETAIL |
CDM |
16 |
|
CDM_AUDIENCE_X_SEGMENT |
CDM |
19 |
|
CDM_BUSINESS_CONTEXT |
CDM |
6 |
|
CDM_CAMPAIGN_CUSTOM_ATTR |
CDM |
6 |
|
CDM_CAMPAIGN_DETAIL |
CDM |
6 |
|
CDM_CONTACT_CHANNEL |
CDM |
6 |
|
CDM_CONTACT_HISTORY |
CDM |
6 |
|
CDM_CONTACT_STATUS |
CDM |
6 |
|
CDM_CONTENT_CUSTOM_ATTR |
CDM |
6 |
|
CDM_CONTENT_DETAIL |
CDM |
6 |
|
CDM_DYN_CONTENT_CUSTOM_ATTR |
CDM |
6 |
|
CDM_IDENTIFIER_TYPE |
CDM |
6 |
|
CDM_IDENTITY_ATTR |
CDM |
6 |
|
CDM_IDENTITY_MAP |
CDM |
6 |
|
CDM_IDENTITY_TYPE |
CDM |
6 |
|
CDM_OCCURRENCE_DETAIL |
CDM |
6 |
|
CDM_RESPONSE_CHANNEL |
CDM |
6 |
|
CDM_RESPONSE_EXTENDED_ATTR |
CDM |
6 |
|
CDM_RESPONSE_HISTORY |
CDM |
6 |
|
CDM_RESPONSE_LOOKUP |
CDM |
6 |
|
CDM_RESPONSE_TYPE |
CDM |
6 |
|
CDM_RTC_DETAIL |
CDM |
6 |
|
CDM_RTC_X_CONTENT |
CDM |
6 |
|
CDM_SEGMENT_CUSTOM_ATTR |
CDM |
6 |
|
CDM_SEGMENT_DETAIL |
CDM |
6 |
|
CDM_SEGMENT_MAP |
CDM |
6 |
|
CDM_SEGMENT_MAP_CUSTOM_ATTR |
CDM |
6 |
|
CDM_SEGMENT_TEST |
CDM |
10 |
|
CDM_SEGMENT_TEST_X_SEGMENT |
CDM |
10 |
|
CDM_TASK_CUSTOM_ATTR |
CDM |
6 |
|
CDM_TASK_DETAIL |
CDM |
6 |
DEBUG
|
Table Name |
Table Type |
Schema First Introduced |
|---|---|---|
|
EVENT_ERRORS |
Debugging |
20 |
DECISIONING
|
Table Name |
Table Type |
Schema First Introduced |
|---|---|---|
|
DECISION_EXECUTION |
Decisioning Detail |
21 |
DESTINATIONS
|
Table Name |
Table Type |
Schema First Introduced |
|---|---|---|
|
AB_TEST_PATH_ASSIGNMENT |
SAS 360 Foundations Detail |
17 |
|
ACTIVITY_CONVERSION |
SAS 360 Foundations Detail |
17 |
|
ACTIVITY_FLOW_IN |
SAS 360 Foundations Detail |
17 |
|
ACTIVITY_START |
SAS 360 Foundations Detail |
17 |
|
ADVERTISING_CONTACT |
SAS 360 Foundations Detail |
17 |
|
AUDIENCE_MEMBERSHIP_CHANGE |
SAS 360 Foundations Detail |
17 |
|
CONTACT_HISTORY |
SAS 360 Foundations Detail |
17 |
|
CONVERSION_MILESTONE |
SAS 360 Foundations Detail |
17 |
|
EMAIL_BOUNCE |
SAS 360 Foundations Detail |
17 |
|
EMAIL_CLICK |
SAS 360 Foundations Detail |
17 |
|
EMAIL_COMPLAINT |
SAS 360 Foundations Detail |
17 |
|
EMAIL_OPEN |
SAS 360 Foundations Detail |
17 |
|
EMAIL_OPTOUT |
SAS 360 Foundations Detail |
17 |
|
EMAIL_REPLY |
SAS 360 Foundations Detail |
17 |
|
EMAIL_SEND |
SAS 360 Foundations Detail |
17 |
|
EMAIL_VIEW |
SAS 360 Foundations Detail |
17 |
|
IDENTITY_ADDRESSABLE_DEVICES |
Identity |
21 |
|
IMPRESSION_DELIVERED |
SAS 360 Foundations Detail |
17 |
|
IMPRESSION_SPOT_VIEWABLE |
SAS 360 Foundations Detail |
17 |
|
IN_APP_FAILED |
SAS 360 Foundations Detail |
17 |
|
IN_APP_MESSAGE |
SAS 360 Foundations Detail |
17 |
|
IN_APP_SEND |
SAS 360 Foundations Detail |
17 |
|
IN_APP_TARGETING_REQUEST |
SAS 360 Foundations Detail |
17 |
|
JOURNEY_ENTRY |
SAS 360 Foundations Detail |
17 |
|
JOURNEY_EXIT |
SAS 360 Foundations Detail |
17 |
|
JOURNEY_HOLDOUT |
SAS 360 Foundations Detail |
17 |
|
JOURNEY_NODE_ENTRY |
SAS 360 Foundations Detail |
17 |
|
JOURNEY_TEST_SUCCESS |
SAS 360 Foundations Detail |
20 |
|
JOURNEY_SUCCESS |
SAS 360 Foundations Detail |
17 |
|
JOURNEY_SUPPRESSION |
SAS 360 Foundations Detail |
17 |
|
MD_ACTIVITY |
Real-time Journey Metadata |
17 |
|
MD_ACTIVITY_ABTESTPATH |
Real-time Journey Metadata |
17 |
|
MD_ACTIVITY_CUSTOM_PROP |
Real-time Journey Metadata |
17 |
|
MD_ACTIVITY_NODE |
Real-time Journey Metadata |
17 |
|
MD_ACTIVITY_X_ACTIVITY_NODE |
Real-time Journey Metadata |
17 |
|
MD_ACTIVITY_X_TASK |
Real-time Journey Metadata |
17 |
|
MD_ASSET |
Real-time Journey Metadata |
17 |
|
MD_AUDIENCE |
Audience Metadata |
12 |
|
MD_AUDIENCE_OCCURRENCE |
Audience Metadata |
12 |
|
MD_AUDIENCE_X_SEGMENT |
Audience Metadata |
19 |
|
MD_CREATIVE |
Creative Metadata |
17 |
|
MD_CREATIVE_CUSTOM_PROP |
Creative Metadata |
17 |
|
MD_CREATIVE_X_ASSET |
Creative Metadata |
17 |
|
MD_DATAVIEW |
Dataview Metadata |
17 |
|
MD_DATAVIEW_X_EVENT |
Dataview Metadata |
17 |
|
MD_EVENT |
Event Metadata |
17 |
|
MD_JOURNEY |
Scheduled Journey Metadata |
17 |
|
MD_JOURNEY_NODE |
Scheduled Journey Metadata |
17 |
|
MD_JOURNEY_NODE_OCCURRENCE |
Scheduled Journey Metadata |
17 |
|
MD_JOURNEY_NODE_X_NEXT_NODE |
Scheduled Journey Metadata |
20 |
|
MD_JOURNEY_NODE_X_PREVIOUS_NODE |
Scheduled Journey Metadata |
20 |
|
MD_JOURNEY_NODE_X_VARIANT |
Scheduled Journey Metadata |
20 |
|
MD_JOURNEY_OCCURRENCE |
Scheduled Journey Metadata |
17 |
|
MD_JOURNEY_X_AUDIENCE |
Scheduled Journey Metadata |
17 |
|
MD_JOURNEY_X_EVENT |
Scheduled Journey Metadata |
17 |
|
MD_JOURNEY_X_TASK |
Scheduled Journey Metadata |
17 |
|
MD_MESSAGE |
Message Metadata |
17 |
|
MD_MESSAGE_CUSTOM_PROP |
Message Metadata |
17 |
|
MD_MESSAGE_X_CREATIVE |
Message Metadata |
17 |
|
MD_OCCURRENCE |
Segment and Task Metadata |
17 |
|
MD_PURPOSE |
Scheduled Journey Metadata |
17 |
|
MD_RTC |
Task Metadata |
17 |
|
MD_SEGMENT |
Segment Metadata |
17 |
|
MD_SEGMENT_CUSTOM_PROP |
Segment Metadata |
17 |
|
MD_SEGMENT_MAP |
Segment Metadata |
17 |
|
MD_SEGMENT_MAP_CUSTOM_PROP |
Segment Metadata |
17 |
|
MD_SEGMENT_MAP_X_SEGMENT |
Segment Metadata |
17 |
|
MD_SEGMENT_TEST |
Segment Metadata |
17 |
|
MD_SEGMENT_TEST_X_SEGMENT |
Segment Metadata |
17 |
|
MD_SEGMENT_X_EVENT |
Segment Metadata |
17 |
|
MD_SPOT |
Spot Metadata |
17 |
|
MD_TASK |
Task Metadata |
17 |
|
MD_TASK_CUSTOM_PROP |
Task Metadata |
17 |
|
MD_TASK_X_AUDIENCE |
Task Metadata |
17 |
|
MD_TASK_X_CREATIVE |
Task Metadata |
17 |
|
MD_TASK_X_DATAVIEW |
Task Metadata |
17 |
|
MD_TASK_X_EVENT |
Task Metadata |
17 |
|
MD_TASK_X_MESSAGE |
Task Metadata |
17 |
|
MD_TASK_X_SEGMENT |
Task Metadata |
17 |
|
MD_TASK_X_SPOT |
Task Metadata |
17 |
|
MD_TASK_X_VARIANT |
Task Metadata |
17 |
|
MOBILE_SPOTS |
Mobile |
17 |
|
NOTIFICATION_FAILED |
Mobile |
17 |
|
NOTIFICATION_OPENED |
Mobile |
17 |
|
NOTIFICATION_SEND |
Mobile |
17 |
|
NOTIFICATION_TARGETING_REQUEST |
Mobile |
17 |
|
OUTBOUND_SYSTEM |
Direct Marketing and Custom Tasks |
17 |
|
RESPONSE_HISTORY |
Task |
17 |
|
SMS_MESSAGE_CLICKED |
Mobile |
17 |
|
SMS_MESSAGE_DELIVERED |
Mobile |
17 |
|
SMS_MESSAGE_FAILED |
Mobile |
17 |
|
SMS_MESSAGE_REPLY |
Mobile |
17 |
|
SMS_MESSAGE_SEND |
Mobile |
17 |
|
SMS_OPTOUT |
Mobile |
17 |
|
SPOT_CLICKED |
Task |
17 |
|
SPOT_REQUESTED |
Task |
17 |
DISCOVER
|
Table Name |
Table Type |
Schema First Introduced |
|---|---|---|
|
BUSINESS_PROCESS_DETAILS |
SAS 360 Discover Detail |
1 |
|
CART_ACTIVITY_DETAILS |
SAS 360 Discover Detail |
1 |
|
CUSTOM_ATTRIBUTES |
SAS 360 Discover Detail |
1 |
|
CUSTOM_EVENTS |
SAS 360 Discover Detail |
4 |
|
CUSTOM_EVENTS_EXT |
SAS 360 Discover Detail |
4 |
|
DATA_VIEW_DETAILS |
SAS 360 Discover Detail |
4 |
|
DOCUMENT_DETAILS |
SAS 360 Discover Detail |
1 |
|
EXTERNAL_EVENT |
SAS 360 Discover Detail |
4 |
|
FORM_DETAILS |
SAS 360 Discover Detail |
1 |
|
GOAL_DETAILS |
SAS 360 Discover Detail |
1 |
|
GOAL_DETAILS_EXT |
SAS 360 Discover Detail |
1 |
|
IDENTITY_ATTRIBUTES |
Identity |
1 |
|
IDENTITY_MAP |
Identity |
1 |
|
MD_DATAVIEW |
Data View Metadata |
4 |
|
MD_DATAVIEW_X_EVENT |
Data View Metadata |
6 Note: The DISCOVER category was added to this table in schema 14. |
|
MD_EVENT |
Event Metadata |
4 |
|
MEDIA_ACTIVITY_DETAILS |
SAS 360 Discover Detail |
1 |
|
MEDIA_DETAILS |
SAS 360 Discover Detail |
1 |
|
MEDIA_DETAILS_EXT |
SAS 360 Discover Detail |
1 |
|
MOBILE_FOCUS_DEFOCUS |
SAS 360 Discover Detail |
4 |
|
ORDER_DETAILS |
SAS 360 Discover Detail |
1 |
|
ORDER_SUMMARY |
SAS 360 Discover Detail |
1 |
|
PAGE_DETAILS |
SAS 360 Discover Detail |
1 |
|
PAGE_DETAILS_EXT |
SAS 360 Discover Detail |
1 |
|
PAGE_ERRORS |
SAS 360 Discover Detail |
1 |
|
PRODUCT_VIEWS |
SAS 360 Discover Detail |
1 |
|
PROMOTION_DISPLAYED |
SAS 360 Discover Detail |
1 |
|
PROMOTION_USED |
SAS 360 Discover Detail |
1 |
|
SEARCH_RESULTS |
SAS 360 Discover Detail |
1 |
|
SEARCH_RESULTS_EXT |
SAS 360 Discover Detail |
1 |
|
SESSION_DETAILS |
SAS 360 Discover Detail |
1 |
|
SESSION_DETAILS_EXT |
SAS 360 Discover Detail |
1 |
|
VISIT_DETAILS |
SAS 360 Discover Detail |
1 |
ENGAGEDIGITAL
|
Table Name |
Table Type |
Schema First Introduced |
|---|---|---|
|
AB_TEST_PATH_ASSIGNMENT |
Real-time Journey |
7 |
|
ACTIVITY_CONVERSION |
Real-time Journey |
4 |
|
ACTIVITY_FLOW_IN |
Real-time Journey |
4 |
|
ACTIVITY_START |
Real-time Journey |
4 |
|
ADVERTISING_CONTACT |
Advertising |
11 |
|
CONTACT_HISTORY |
Task |
4 |
|
CONVERSION_MILESTONE |
Task |
4 |
|
EXTERNAL_EVENT |
SAS 360 Discover Detail |
8 |
|
IDENTITY_ATTRIBUTES |
Identity |
1 |
|
IDENTITY_MAP |
Identity |
1 |
|
IMPRESSION_DELIVERED |
Task |
7 |
|
IMPRESSION_SPOT_VIEWABLE |
Task |
4 |
|
IN_APP_FAILED |
Mobile |
4 |
|
IN_APP_MESSAGE |
Mobile |
4 |
|
IN_APP_SEND |
Mobile |
4 |
|
IN_APP_TARGETING_REQUEST |
Mobile |
7 |
|
MD_ACTIVITY |
Real-time Journey Metadata |
4 |
|
MD_ACTIVITY_ABTESTPATH |
Real-time Journey Metadata |
6 |
|
MD_ACTIVITY_CUSTOM_PROP |
Real-time Journey Metadata |
4 |
|
MD_ACTIVITY_NODE |
Real-time Journey Metadata |
6 |
|
MD_ACTIVITY_X_ACTIVITY_NODE |
Real-time Journey Metadata |
6 |
|
MD_ACTIVITY_X_TASK |
Real-time Journey Metadata |
4 |
|
MD_ASSET |
Asset Metadata |
6 |
|
MD_BUSINESS_CONTEXT |
Business Context Metadata |
6 |
|
MD_CREATIVE |
Creative Metadata |
4 |
|
MD_CREATIVE_CUSTOM_PROP |
Creative Metadata |
4 |
|
MD_CREATIVE_X_ASSET |
Creative Metadata |
6 |
|
MD_DATAVIEW_X_EVENT |
Data View Metadata |
6 |
|
MD_MESSAGE |
Message Metadata |
4 |
|
MD_MESSAGE_CUSTOM_PROP |
Message Metadata |
4 |
|
MD_MESSAGE_X_CREATIVE |
Message Metadata |
6 |
|
MD_OCCURRENCE |
Segment and Task Metadata |
6 |
|
MD_RTC |
Task Metadata |
6 |
|
MD_SEGMENT |
Segment Metadata |
4 |
|
MD_SEGMENT_CUSTOM_PROP |
Segment Metadata |
4 |
|
MD_SEGMENT_MAP_CUSTOM_PROP |
Segment Metadata |
4 |
|
MD_SEGMENT_TEST |
Segment Metadata |
10 |
|
MD_SEGMENT_TEST_X_SEGMENT |
Segment Metadata |
10 |
|
MD_SEGMENT_MAP_X_SEGMENT |
Segment Metadata |
6 |
|
MD_SEGMENT_X_EVENT |
Segment Metadata |
6 |
|
MD_SPOT |
Spot Metadata |
4 |
|
MD_TARGET_ASSIST |
Assisted Targeting Metadata |
8 |
|
MD_TASK |
Task Metadata |
4 |
|
MD_TASK_CUSTOM_PROP |
Task Metadata |
4 |
|
MD_TASK_X_AUDIENCE |
Task Metadata |
12 |
|
MD_TASK_X_CREATIVE |
Task Metadata |
6 |
|
MD_TASK_X_DATAVIEW |
Task Metadata |
6 |
|
MD_TASK_X_EVENT |
Task Metadata |
6 |
|
MD_TASK_X_MESSAGE |
Task Metadata |
6 |
|
MD_TASK_X_SEGMENT |
Task Metadata |
6 |
|
MD_TASK_X_SPOT |
Task Metadata |
6 |
|
MD_TASK_X_VARIANT |
Task Metadata |
16 |
|
MOBILE_SPOTS |
Mobile |
4 |
|
NOTIFICATION_FAILED |
Mobile |
4 |
|
NOTIFICATION_OPENED |
Mobile |
4 |
|
NOTIFICATION_SEND |
Mobile |
4 |
|
NOTIFICATION_TARGETING_REQUEST |
Mobile |
7 |
|
OUTBOUND_SYSTEM |
Direct Marketing and Custom Tasks |
4 |
|
RESPONSE_HISTORY |
Task |
4 |
|
SPOT_CLICKED |
Task |
4 |
|
SPOT_REQUESTED |
Task |
7 |
ENGAGEDIRECT
|
Table Name |
Table Type |
Schema First Introduced |
|---|---|---|
|
ACTIVITY_CONVERSION |
Real-time Journey |
4 |
|
ACTIVITY_FLOW_IN |
Real-time Journey |
4 |
|
ACTIVITY_START |
Real-time Journey |
4 |
|
ADVERTISING_CONTACT |
Advertising |
11 |
|
CONTACT_HISTORY |
Task |
4 |
|
CONVERSION_MILESTONE |
Task |
4 |
|
DIRECT_CONTACT |
Direct Marketing and Custom Tasks |
4 |
|
EXTERNAL_EVENT |
SAS 360 Discover Detail |
8 |
|
IDENTITY_ATTRIBUTES |
Identity |
1 |
|
IDENTITY_MAP |
Identity |
1 |
|
MD_ACTIVITY |
Real-time Journey Metadata |
4 |
|
MD_ACTIVITY_ABTESTPATH |
Real-time Journey Metadata |
6 |
|
MD_ACTIVITY_CUSTOM_PROP |
Real-time Journey Metadata |
4 |
|
MD_ACTIVITY_NODE |
Real-time Journey Metadata |
6 |
|
MD_ACTIVITY_X_ACTIVITY_NODE |
Real-time Journey Metadata |
6 |
|
MD_ACTIVITY_X_TASK |
Real-time Journey Metadata |
4 |
|
MD_ASSET |
Asset Metadata |
6 |
|
MD_BUSINESS_CONTEXT |
Business Context Metadata |
6 |
|
MD_CREATIVE |
Creative Metadata |
4 |
|
MD_CREATIVE_CUSTOM_PROP |
Creative Metadata |
4 |
|
MD_CREATIVE_X_ASSET |
Creative Metadata |
6 |
|
MD_DATAVIEW_X_EVENT |
Data View Metadata |
6 |
|
MD_MESSAGE |
Message Metadata |
4 |
|
MD_MESSAGE_CUSTOM_PROP |
Message Metadata |
4 |
|
MD_MESSAGE_X_CREATIVE |
Message Metadata |
6 |
|
MD_OCCURRENCE |
Segment and Task Metadata |
6 |
|
MD_RTC |
Task Metadata |
6 |
|
MD_SEGMENT |
Segment Metadata |
4 |
|
MD_SEGMENT_CUSTOM_PROP |
Segment Metadata |
4 |
|
MD_SEGMENT_MAP |
Segment Metadata |
4 |
|
MD_SEGMENT_MAP_CUSTOM_PROP |
Segment Metadata |
4 |
|
MD_SEGMENT_MAP_X_SEGMENT |
Segment Metadata |
6 |
|
MD_SEGMENT_TEST |
Segment Metadata |
10 |
|
MD_SEGMENT_TEST_X_SEGMENT |
Segment Metadata |
10 |
|
MD_SEGMENT_X_EVENT |
Segment Metadata |
6 |
|
MD_TARGET_ASSIST |
Assisted Targeting Metadata |
8 |
|
MD_TASK |
Task Metadata |
4 |
|
MD_TASK_CUSTOM_PROP |
Task Metadata |
4 |
|
MD_TASK_X_AUDIENCE |
Task Metadata |
12 |
|
MD_TASK_X_CREATIVE |
Task Metadata |
6 |
|
MD_TASK_X_DATAVIEW |
Task Metadata |
6 |
|
MD_TASK_X_EVENT |
Task Metadata |
6 |
|
MD_TASK_X_MESSAGE |
Task Metadata |
6 |
|
MD_TASK_X_SEGMENT |
Task Metadata |
6 |
|
MD_TASK_X_SPOT |
Task Metadata |
6 |
|
OUTBOUND_SYSTEM |
Direct Marketing and Custom Tasks |
4 |
|
RESPONSE_HISTORY |
Task |
4 |
|
SEGMENT_MEMBERSHIP |
Direct Marketing |
22 |
ENGAGEEMAIL
|
Table Name |
Table Type |
Schema First Introduced |
|---|---|---|
|
ACTIVITY_CONVERSION |
Real-time Journey |
4 |
|
ACTIVITY_FLOW_IN |
Real-time Journey |
4 |
|
ACTIVITY_START |
Real-time Journey |
4 |
|
ADVERTISING_CONTACT |
Advertising |
11 |
|
CONTACT_HISTORY |
Task |
4 |
|
CONVERSION_MILESTONE |
Task |
4 |
|
EMAIL_BOUNCE |
|
4 |
|
EMAIL_CLICK |
|
4 |
|
EMAIL_COMPLAINT |
|
4 |
|
EMAIL_OPEN |
|
4 |
|
EMAIL_OPTOUT |
|
4 |
|
EMAIL_REPLY |
|
4 |
|
EMAIL_SEND |
|
4 |
|
EMAIL_VIEW |
|
4 |
|
EXTERNAL_EVENT |
SAS 360 Discover Detail |
8 |
|
IDENTITY_ATTRIBUTES |
Identity |
1 |
|
IDENTITY_MAP |
Identity |
1 |
|
MD_ACTIVITY |
Real-time Journey Metadata |
4 |
|
MD_ACTIVITY_ABTESTPATH |
Real-time Journey Metadata |
6 |
|
MD_ACTIVITY_CUSTOM_PROP |
Real-time Journey Metadata |
4 |
|
MD_ACTIVITY_NODE |
Real-time Journey Metadata |
6 |
|
MD_ACTIVITY_X_ACTIVITY_NODE |
Real-time Journey Metadata |
6 |
|
MD_ACTIVITY_X_TASK |
Real-time Journey Metadata |
4 |
|
MD_ASSET |
Asset Metadata |
6 |
|
MD_BUSINESS_CONTEXT |
Business Context Metadata |
6 |
|
MD_CREATIVE |
Creative Metadata |
4 |
|
MD_CREATIVE_CUSTOM_PROP |
Creative Metadata |
4 |
|
MD_CREATIVE_X_ASSET |
Creative Metadata |
6 |
|
MD_DATAVIEW_X_EVENT |
Data View Metadata |
6 |
|
MD_MESSAGE |
Message Metadata |
4 |
|
MD_MESSAGE_CUSTOM_PROP |
Message Metadata |
4 |
|
MD_MESSAGE_X_CREATIVE |
Message Metadata |
6 |
|
MD_OCCURRENCE |
Segment and Task Metadata |
6 |
|
MD_RTC |
Task Metadata |
6 |
|
MD_SEGMENT |
Segment Metadata |
4 |
|
MD_SEGMENT_CUSTOM_PROP |
Segment Metadata |
4 |
|
MD_SEGMENT_MAP_CUSTOM_PROP |
Segment Metadata |
4 |
|
MD_SEGMENT_MAP_X_SEGMENT |
Segment Metadata |
6 |
|
MD_SEGMENT_X_EVENT |
Segment Metadata |
6 |
|
MD_SPOT |
Spot Metadata |
4 |
|
MD_TARGET_ASSIST |
Assisted Targeting Metadata |
8 |
|
MD_TASK |
Task Metadata |
4 |
|
MD_TASK_CUSTOM_PROP |
Task Metadata |
4 |
|
MD_TASK_X_AUDIENCE |
Task Metadata |
12 |
|
MD_TASK_X_CREATIVE |
Task Metadata |
6 |
|
MD_TASK_X_DATAVIEW |
Task Metadata |
6 |
|
MD_TASK_X_EVENT |
Task Metadata |
6 |
|
MD_TASK_X_MESSAGE |
Task Metadata |
6 |
|
MD_TASK_X_SEGMENT |
Task Metadata |
6 |
|
MD_TASK_X_SPOT |
Task Metadata |
6 |
|
RESPONSE_HISTORY |
Task |
4 |
ENGAGEMETADATA
|
Table Name |
Table Type |
Schema First Introduced |
|---|---|---|
|
MD_ACTIVITY |
Real-time Journey Metadata |
4 |
|
MD_ACTIVITY_ABTESTPATH |
Real-time Journey Metadata |
6 |
|
MD_ACTIVITY_CUSTOM_PROP |
Real-time Journey Metadata |
4 |
|
MD_ACTIVITY_NODE |
Real-time Journey Metadata |
6 |
|
MD_ACTIVITY_X_ACTIVITY_NODE |
Real-time Journey Metadata |
6 |
|
MD_ACTIVITY_X_TASK |
Real-time Journey Metadata |
4 |
|
MD_AUDIENCE |
Audience Metadata |
12 |
|
MD_AUDIENCE_OCCURRENCE |
Audience Metadata |
12 |
|
MD_AUDIENCE_X_SEGMENT |
Audience Metadata |
19 |
|
MD_ASSET |
Asset Metadata |
6 |
|
MD_BUSINESS_CONTEXT |
Business Context Metadata |
6 |
|
MD_CREATIVE |
Creative Metadata |
4 |
|
MD_CREATIVE_CUSTOM_PROP |
Creative Metadata |
4 |
|
MD_CREATIVE_X_ASSET |
Creative Metadata |
6 |
|
MD_DATAVIEW |
Data View Metadata |
4 |
|
MD_DATAVIEW_X_EVENT |
Data View Metadata |
6 |
|
MD_EVENT |
Event Metadata |
4 |
|
MD_JOURNEY |
Scheduled Journey Metadata |
17 |
|
MD_JOURNEY_NODE |
Scheduled Journey Metadata |
17 |
|
MD_JOURNEY_NODE_OCCURRENCE |
Scheduled Journey Metadata |
17 |
|
MD_JOURNEY_NODE_X_NEXT_NODE |
Scheduled Journey Metadata |
20 |
|
MD_JOURNEY_NODE_X_PREVIOUS_NODE |
Scheduled Journey Metadata |
20 |
|
MD_JOURNEY_NODE_X_VARIANT |
Scheduled Journey Metadata |
20 |
|
MD_JOURNEY_OCCURRENCE |
Scheduled Journey Metadata |
17 |
|
MD_JOURNEY_X_AUDIENCE |
Scheduled Journey Metadata |
17 |
|
MD_JOURNEY_X_EVENT |
Scheduled Journey Metadata |
17 |
|
MD_JOURNEY_X_TASK |
Scheduled Journey Metadata |
17 |
|
MD_MESSAGE |
Message Metadata |
4 |
|
MD_MESSAGE_CUSTOM_PROP |
Message Metadata |
4 |
|
MD_MESSAGE_X_CREATIVE |
Message Metadata |
6 |
|
MD_OCCURRENCE |
Segment and Task Metadata |
6 |
|
MD_PURPOSE |
Scheduled Journey Metadata |
17 |
|
MD_RTC |
Task Metadata |
6 |
|
MD_SEGMENT |
Segment Metadata |
4 |
|
MD_SEGMENT_CUSTOM_PROP |
Segment Metadata |
4 |
|
MD_SEGMENT_MAP |
Segment Metadata |
4 |
|
MD_SEGMENT_MAP_CUSTOM_PROP |
Segment Metadata |
4 |
|
MD_SEGMENT_MAP_X_SEGMENT |
Segment Metadata |
6 |
|
MD_SEGMENT_X_EVENT |
Segment Metadata |
6 |
|
MD_SPOT |
Spot Metadata |
4 |
|
MD_TARGET_ASSIST |
Assisted Targeting Metadata |
8 |
|
MD_TASK |
Task Metadata |
4 |
|
MD_TASK_CUSTOM_PROP |
Task Metadata |
4 |
|
MD_TASK_X_AUDIENCE |
Task Metadata |
12 |
|
MD_TASK_X_CREATIVE |
Task Metadata |
6 |
|
MD_TASK_X_DATAVIEW |
Task Metadata |
6 |
|
MD_TASK_X_EVENT |
Task Metadata |
6 |
|
MD_TASK_X_MESSAGE |
Task Metadata |
6 |
|
MD_TASK_X_SEGMENT |
Task Metadata |
6 |
|
MD_TASK_X_SPOT |
Task Metadata |
6 |
ENGAGEMOBILE
|
Table Name |
Table Type |
Schema First Introduced |
|---|---|---|
|
AB_TEST_PATH_ASSIGNMENT |
Real-time Journey |
7 |
|
ACTIVITY_CONVERSION |
Real-time Journey |
4 |
|
ACTIVITY_FLOW_IN |
Real-time Journey |
4 |
|
ACTIVITY_START |
Real-time Journey |
4 |
|
ADVERTISING_CONTACT |
Advertising |
11 |
|
CONTACT_HISTORY |
Task |
4 |
|
CONVERSION_MILESTONE |
Task |
4 |
|
IDENTITY_ADDRESSABLE_DEVICES |
Identity |
21 |
|
IDENTITY_ATTRIBUTES |
Identity |
1 |
|
IDENTITY_MAP |
Identity |
1 |
|
IMPRESSION_DELIVERED |
Task |
7 |
|
IMPRESSION_SPOT_VIEWABLE |
Task |
4 |
|
IN_APP_FAILED |
Mobile |
4 |
|
IN_APP_MESSAGE |
Mobile |
4 |
|
IN_APP_SEND |
Mobile |
4 |
|
IN_APP_TARGETING_REQUEST |
Mobile |
7 |
|
MD_ACTIVITY |
Real-time Journey Metadata |
4 |
|
MD_ACTIVITY_ABTESTPATH |
Real-time Journey Metadata |
6 |
|
MD_ACTIVITY_CUSTOM_PROP |
Real-time Journey Metadata |
4 |
|
MD_ACTIVITY_NODE |
Real-time Journey Metadata |
6 |
|
MD_ACTIVITY_X_ACTIVITY_NODE |
Real-time Journey Metadata |
6 |
|
MD_ACTIVITY_X_TASK |
Real-time Journey Metadata |
4 |
|
MD_ASSET |
Asset Metadata |
6 |
|
MD_BUSINESS_CONTEXT |
Business Context Metadata |
6 |
|
MD_CREATIVE |
Creative Metadata |
4 |
|
MD_CREATIVE_CUSTOM_PROP |
Creative Metadata |
4 |
|
MD_CREATIVE_X_ASSET |
Creative Metadata |
6 |
|
MD_DATAVIEW_X_EVENT |
Data View Metadata |
6 |
|
MD_MESSAGE |
Message Metadata |
4 |
|
MD_MESSAGE_CUSTOM_PROP |
Message Metadata |
4 |
|
MD_MESSAGE_X_CREATIVE |
Message Metadata |
6 |
|
MD_OCCURRENCE |
Segment and Task Metadata |
6 |
|
MD_RTC |
Task Metadata |
6 |
|
MD_SEGMENT |
Segment Metadata |
4 |
|
MD_SEGMENT_CUSTOM_PROP |
Segment Metadata |
4 |
|
MD_SEGMENT_MAP_CUSTOM_PROP |
Segment Metadata |
4 |
|
MD_SEGMENT_MAP_X_SEGMENT |
Segment Metadata |
6 |
|
MD_SEGMENT_X_EVENT |
Segment Metadata |
6 |
|
MD_SPOT |
Spot Metadata |
4 |
|
MD_TARGET_ASSIST |
Assisted Targeting Metadata |
8 |
|
MD_TASK |
Task Metadata |
4 |
|
MD_TASK_CUSTOM_PROP |
Task Metadata |
4 |
|
MD_TASK_X_AUDIENCE |
Task Metadata |
12 |
|
MD_TASK_X_CREATIVE |
Task Metadata |
6 |
|
MD_TASK_X_DATAVIEW |
Task Metadata |
6 |
|
MD_TASK_X_EVENT |
Task Metadata |
6 |
|
MD_TASK_X_MESSAGE |
Task Metadata |
6 |
|
MD_TASK_X_SEGMENT |
Task Metadata |
6 |
|
MD_TASK_X_SPOT |
Task Metadata |
6 |
|
MOBILE_SPOTS |
Mobile |
4 |
|
NOTIFICATION_FAILED |
Mobile |
4 |
|
NOTIFICATION_OPENED |
Mobile |
4 |
|
NOTIFICATION_SEND |
Mobile |
4 |
|
NOTIFICATION_TARGETING_REQUEST |
Mobile |
7 |
|
OUTBOUND_SYSTEM |
Direct Marketing and Custom Tasks |
4 |
|
RESPONSE_HISTORY |
Task |
4 |
|
SPOT_CLICKED |
Task |
4 |
|
SPOT_REQUESTED |
Task |
7 |
ENGAGEWEB
|
Table Name |
Table Type |
Schema First Introduced |
|---|---|---|
|
AB_TEST_PATH_ASSIGNMENT |
Real-time Journey |
7 |
|
ACTIVITY_CONVERSION |
Real-time Journey |
4 |
|
ACTIVITY_FLOW_IN |
Real-time Journey |
4 |
|
ACTIVITY_START |
Real-time Journey |
4 |
|
ADVERTISING_CONTACT |
Advertising |
11 |
|
CONTACT_HISTORY |
Task |
4 |
|
CONVERSION_MILESTONE |
Task |
4 |
|
IDENTITY_ATTRIBUTES |
Identity |
1 |
|
IDENTITY_MAP |
Identity |
1 |
|
IMPRESSION_DELIVERED |
Task |
7 |
|
IMPRESSION_SPOT_VIEWABLE |
Task |
4 |
|
MD_ACTIVITY |
Real-time Journey Metadata |
4 |
|
MD_ACTIVITY_ABTESTPATH |
Real-time Journey Metadata |
6 |
|
MD_ACTIVITY_CUSTOM_PROP |
Real-time Journey Metadata |
4 |
|
MD_ACTIVITY_NODE |
Real-time Journey Metadata |
6 |
|
MD_ACTIVITY_X_ACTIVITY_NODE |
Real-time Journey Metadata |
6 |
|
MD_ACTIVITY_X_TASK |
Real-time Journey Metadata |
4 |
|
MD_ASSET |
Asset Metadata |
6 |
|
MD_BUSINESS_CONTEXT |
Business Context Metadata |
6 |
|
MD_CREATIVE |
Creative Metadata |
4 |
|
MD_CREATIVE_CUSTOM_PROP |
Creative Metadata |
4 |
|
MD_CREATIVE_X_ASSET |
Creative Metadata |
6 |
|
MD_DATAVIEW_X_EVENT |
Data View Metadata |
6 |
|
MD_MESSAGE |
Message Metadata |
4 |
|
MD_MESSAGE_CUSTOM_PROP |
Message Metadata |
4 |
|
MD_MESSAGE_X_CREATIVE |
Message Metadata |
6 |
|
MD_SEGMENT |
Segment Metadata |
4 |
|
MD_SEGMENT_CUSTOM_PROP |
Segment Metadata |
4 |
|
MD_SEGMENT_MAP_CUSTOM_PROP |
Segment Metadata |
4 |
|
MD_SEGMENT_MAP_X_SEGMENT |
Segment Metadata |
6 |
|
MD_SEGMENT_X_EVENT |
Segment Metadata |
6 |
|
MD_SPOT |
Spot Metadata |
4 |
|
MD_TARGET_ASSIST |
Assisted Targeting Metadata |
8 |
|
MD_TASK |
Task Metadata |
4 |
|
MD_TASK_CUSTOM_PROP |
Task Metadata |
4 |
|
MD_TASK_X_CREATIVE |
Task Metadata |
6 |
|
MD_TASK_X_DATAVIEW |
Task Metadata |
6 |
|
MD_TASK_X_EVENT |
Task Metadata |
6 |
|
MD_TASK_X_MESSAGE |
Task Metadata |
6 |
|
MD_TASK_X_SEGMENT |
Task Metadata |
6 |
|
MD_TASK_X_SPOT |
Task Metadata |
6 |
|
OUTBOUND_SYSTEM |
Direct Marketing and Custom Tasks |
4 |
|
RESPONSE_HISTORY |
Task |
4 |
|
SPOT_CLICKED |
Task |
4 |
|
SPOT_REQUESTED |
Task |
7 |
METADATA_ALL
|
Table Name |
Table Type |
Schema First Introduced |
|---|---|---|
|
MD_ACTIVITY_ALL |
Real-time Journey Metadata |
20 |
|
MD_ACTIVITY_ABTESTPATH_ALL |
Real-time Journey Metadata |
20 |
|
MD_ACTIVITY_CUSTOM_PROP_ALL |
Real-time Journey Metadata |
20 |
|
MD_ACTIVITY_NODE_ALL |
Real-time Journey Metadata |
20 |
|
MD_ACTIVITY_X_ACTIVITY_NODE_ALL |
Real-time Journey Metadata |
20 |
|
MD_ACTIVITY_X_TASK_ALL |
Real-time Journey Metadata |
20 |
|
MD_ASSET_ALL |
Asset Metadata |
20 |
|
MD_AUDIENCE_X_SEGMENT |
Audience Metadata |
20 |
|
MD_BUSINESS_CONTEXT_ALL |
Business Context Metadata |
20 |
|
MD_CREATIVE_ALL |
Creative Metadata |
20 |
|
MD_CREATIVE_CUSTOM_PROP_ALL |
Creative Metadata |
20 |
|
MD_CREATIVE_X_ASSET_ALL |
Creative Metadata |
20 |
|
MD_DATAVIEW_ALL |
Event Metadata |
20 |
|
MD_DATAVIEW_X_EVENT_ALL |
Event Metadata |
20 |
|
MD_EVENT_ALL |
Event Metadata |
20 |
|
MD_JOURNEY_ALL |
Scheduled Journey Metadata |
20 |
|
MD_JOURNEY_NODE |
Scheduled Journey Metadata |
20 |
|
MD_JOURNEY_NODE_OCCURRENCE |
Scheduled Journey Metadata |
20 |
|
MD_JOURNEY_OCCURRENCE |
Scheduled Journey Metadata |
20 |
|
MD_JOURNEY_X_AUDIENCE |
Scheduled Journey Metadata |
20 |
|
MD_JOURNEY_X_EVENT |
Scheduled Journey Metadata |
20 |
|
MD_JOURNEY_X_TASK |
Scheduled Journey Metadata |
20 |
|
MD_MESSAGE_ALL |
Message Metadata |
20 |
|
MD_MESSAGE_CUSTOM_PROP_ALL |
Message Metadata |
20 |
|
MD_MESSAGE_X_CREATIVE_ALL |
Message Metadata |
20 |
|
MD_SEGMENT_ALL |
Segment Metadata |
20 |
|
MD_SEGMENT_CUSTOM_PROP_ALL |
Segment Metadata |
20 |
|
MD_SEGMENT_MAP_ALL |
Segment Metadata |
20 |
|
MD_SEGMENT_MAP_CUSTOM_PROP_ALL |
Segment Metadata |
20 |
|
MD_SEGMENT_MAP_X_SEGMENT_ALL |
Segment Metadata |
20 |
|
MD_SEGMENT_TEST_ALL |
Segment Metadata |
20 |
|
MD_SEGMENT_TEST_X_SEGMENT_ALL |
Segment Metadata |
20 |
|
MD_SEGMENT_X_EVENT_ALL |
Segment Metadata |
20 |
|
MD_SPOT_ALL |
Spot Metadata |
20 |
|
MD_TARGET_ASSIST |
Assisted Targeting Metadata |
20 |
|
MD_TASK_ALL |
Task Metadata |
20 |
|
MD_TASK_CUSTOM_PROP_ALL |
Task Metadata |
20 |
|
MD_TASK_X_AUDIENCE |
Task Metadata |
20 |
|
MD_TASK_X_CREATIVE_ALL |
Task Metadata |
20 |
|
MD_TASK_X_DATAVIEW_ALL |
Task Metadata |
20 |
|
MD_TASK_X_EVENT_ALL |
Task Metadata |
20 |
|
MD_TASK_X_MESSAGE_ALL |
Task Metadata |
20 |
|
MD_TASK_X_SEGMENT_ALL |
Task Metadata |
20 |
|
MD_TASK_X_SPOT_ALL |
Task Metadata |
20 |
|
MD_TASK_X_VARIANT_ALL |
Task Metadata |
20 |
OPTOUTDATA
|
Table Name |
Table Type |
Schema First Introduced |
|---|---|---|
|
EMAIL_OPTOUT_DETAILS |
|
6 |
PLAN
|
Table Name |
Table Type |
Schema First Introduced |
|---|---|---|
|
ASSET_DETAILS |
Assets |
5 |
|
ASSET_DETAILS_CUSTOM_PROP |
Assets |
5 |
|
ASSET_FOLDER_DETAILS |
Assets |
5 |
|
ASSET_RENDITION_DETAILS |
Assets |
5 |
|
ASSET_REVISION |
Assets |
5 |
|
CC_BUDGET_BREAKUP |
SAS 360 Plan |
5 |
|
CC_BUDGET_BREAKUP_CCBDGT |
SAS 360 Plan |
9 |
|
COMMITMENT_DETAILS |
SAS 360 Plan |
5 |
|
COMMITMENT_LINE_ITEMS |
SAS 360 Plan |
6 |
|
COMMITMENT_LINE_ITEMS_CCBDGT |
SAS 360 Plan |
9 |
|
FISCAL_CC_BUDGET |
SAS 360 Plan |
9 |
|
INVOICE_DETAILS |
SAS 360 Plan |
5 |
|
INVOICE_LINE_ITEMS |
SAS 360 Plan |
5 |
|
INVOICE_LINE_ITEMS_CCBDGT |
SAS 360 Plan |
9 |
|
MD_BU |
SAS 360 Plan |
5 |
|
MD_COST_CATEGORY |
SAS 360 Plan |
6 |
|
MD_COSTCENTER |
SAS 360 Plan |
5 |
|
MD_CREATIVE_X_ASSET |
Creative Metadata |
6 |
|
MD_CUST_ATTRIB |
SAS 360 Plan |
5 |
|
MD_CUSTATTRIB_TABLE_VALUES |
SAS 360 Plan |
5 |
|
MD_FISCAL_PERIOD |
SAS 360 Plan |
9 |
|
MD_GRID_ATTR_DEFN |
SAS 360 Plan |
5 |
|
MD_OBJECT_TYPE |
SAS 360 Plan |
5 |
|
MD_PICKLIST |
SAS 360 Plan |
5 |
|
MD_VENDOR |
SAS 360 Plan |
5 |
|
MD_WF_PROCESS_DEF |
Workflow |
5 |
|
MD_WF_PROCESS_DEF_ATTR_GRP |
Workflow |
5 |
|
MD_WF_PROCESS_DEF_CATEGORIES |
Workflow |
5 |
|
MD_WF_PROCESS_DEF_TASK_ASSG |
Workflow |
5 |
|
MD_WF_PROCESS_DEF_TASKS |
Workflow |
5 |
|
PLANNING_HIERARCHY_DEFN |
SAS 360 Plan |
5 |
|
PLANNING_INFO |
SAS 360 Plan |
5 |
|
PLANNING_INFO_CUSTOM_PROP |
SAS 360 Plan |
5 |
|
TAG_DETAILS |
SAS 360 Plan |
5 |
|
WF_PROCESS_DETAILS |
Workflow |
5 |
|
WF_PROCESS_DETAILS_CUSTOM_PROP |
Workflow |
5 |
|
WF_PROCESS_TASKS |
Workflow |
5 |
|
WF_TASKS_USER_ASSIGNMENT |
Workflow |
5 |
SMS
|
Table Name |
Table Type |
Schema First Introduced |
|---|---|---|
|
AUDIENCE_MEMBERSHIP_CHANGE |
Audience |
17 |
|
CONVERSION_MILESTONE |
Task |
17 |
|
MD_AUDIENCE |
Audience Metadata |
17 |
|
MD_AUDIENCE_OCCURRENCE |
Audience Metadata |
17 |
|
MD_AUDIENCE_X_SEGMENT |
Audience Metadata |
19 |
|
MD_CREATIVE |
Creative Metadata |
17 |
|
MD_CREATIVE_CUSTOM_PROP |
Creative Metadata |
17 |
|
MD_OCCURRENCE |
Segment and Task Metadata |
17 |
|
MD_RTC |
Task Metadata |
17 |
|
MD_TASK |
Task Metadata |
17 |
|
MD_TASK_CUSTOM_PROP |
Task Metadata |
17 |
|
MD_TASK_X_AUDIENCE |
Task Metadata |
17 |
|
MD_TASK_X_CREATIVE |
Task Metadata |
17 |
|
MD_TASK_X_EVENT |
Task Metadata |
17 |
|
SMS_MESSAGE_CLICKED |
Mobile |
17 |
|
SMS_MESSAGE_DELIVERED |
Mobile |
17 |
|
SMS_MESSAGE_FAILED |
Mobile |
17 |
|
SMS_MESSAGE_REPLY |
Mobile |
17 |
|
SMS_MESSAGE_SEND |
Mobile |
17 |
|
SMS_OPTOUT |
Mobile |
17 |
SMS_OPTOUTDATA
|
Table Name |
Table Type |
Schema First Introduced |
|---|---|---|
|
SMS_OPTOUT_DETAILS |
Mobile |
17 |
USAGE
|
Table Name |
Table Type |
Schema First Introduced |
|---|---|---|
|
DAILY_USAGE |
Usage |
8 |
|
MONTHLY_USAGE |
Usage |
8 |