System Tables

This section provides details on each of the HCL CDP system tables.

Module Tables Description
admin-ui adminuiaccess stores access data
adminuiconfig stores admin config information
dbindex stores db index data
dmpcampaigncontractdetails stores campaign contract details
piiconversiondetails stores pii conversation details data
Audience Uploader dmpwcaengagement stores engagement info
eedmpcampaignemailclientmapping stores campaign client email info
eedmpemailcontacts stores mail contacts
exportpublisher stores export publishers name
facebookengagement stores facebook engagement data
wcaengagement stores wca engagement data
core-api aclresource stores acl resource data
aclrole stores acl role data
aclrule stores acl rule data
acluserrule stores acl user rule data
adhocqueries stores adhoc queries data
advancedprioritysegmentgroups stores priority segment groups data
advancedprioritysegmentlogs stores priority segment logs data
banner stores banner information
banneraudittrail stores banner auditing data
bannerclass stores banner class details
bannerclasssource stores banner class source details
bannerdatatemplate stores banner template information
bannersize stores banner image size
calculatedproperties stores calculated properties info
calculatedpropertytypes stores calculated properties type info
calculations_propertytypes stores calculated properties type info
calculationtypes stores calculated properties type info
campaigndomainmapping stores campaign mapping to domain
campaignparameters stores campaign parameters
campaignregistrationdetails stores campaign registration details
cdpcalculatedproperty stores calculated property data
cdpcalculationtype stores calculation type data
cdpcalculationtypemapping stores calculation type mapping data
cdpcustomerproperties stores customer properties info
cdpdatapoint stores data point info
cdpproperty stores CDP property data
cdppropertytype stores CDP property type data
clientdetails stores client details
clientmacros stores client macro details
consentapiauth stores api authentication information
country stores country details
datasources stores data source info
defaultimages stores default image info
dmpanalyzeparameters stores dmp analyze parameters data
dmpapppushbuttons stores app push buttons information
dmpapppushtargetoptions stores app push target option data
dmpapppushtemplates stores app push templates data
dmpbannerpersonalizationdefaultsabtest stores banner personalization default data
dmpbannerpersonalizationengagement stores banner personalization engagement data
dmpbannerpersonalizationslot stores banner personalization slot data
dmpbannerpersonalizationslotdefaults stores banner personalization slot default data
dmpbannerpersonalizationtemplate stores banner personalization template data
dmpbfsifeed stores on-site reco details
dmpbrowserpushsettings stores browser push settings data
dmpcampaigncookiepolicy stores campaign cookie policy data
dmpcampaigncovmapping stores campaign customer one view mapping data
dmpcampaignexportpublishermapping stores campaign export publisher mapping data
dmpcampaignexportpublisherpixeldetails stores campaign export publisher pixel details
dmpcampaignsegmenttags stores campaign segment tags data
dmpclientrequest stores client request data
dmpdailysegmentdata stores daily segment data
dmpdatasourcestaticinfo stores data source static info
dmpengagementauditlog stores entanglement auditing log data
dmpengagementshorturlmapping stores engagement short url mapping data
dmpeventproperties stores event properties data
dmpfbnfengagement stores facebook engagement data
dmpfbrhsengagement stores facebook engagement data
dmpfirsttimevisitorfieldvalues stores first time visitor field values
dmpfirsttimevisitormacro stores first time visitor macro data
dmpfunnelreports stores funnel reports data
dmpinappnotificationengagement stores app notification engagement data
dmpinsight stores dmp insight data
dmpinsightcategory stores dmp insight category data
dmpjourney stores dmp journey data
dmpnotificationbotengagement stores notification engagement data
dmpnotificationbotsettings stores notification bot settings data
dmpnotificationbottemplate stores notification template information
dmpoptintemplates stores opt in templates info
dmpprogrammaticengagement stores programmatic engagement data
dmppublisherverticals stores publisher vertical data
dmppushnotificationengagement stores push notification engagement data
dmpreportapidetails stores report api details
dmpslot stores dmp slot data
ecomtype stores e-commerce type data
fb_banners stores facebook banners data
fb_newsfeed_banners stores news feed banners data
fbadtemplateplaceholder stores template placeholder data
fbquerytypeplaceholder stores query type place holder data
fbx_campaign_details stores facebook campaign details data
fbxadaccount stores ad account data
fbxadcampaign stores ad campaign data
fbxcalltoactionbutton stores facebook allocation button data
feed stores feed data
feeddownloadmetadata stores feed download data
feeddownloadtimes stores feed download times data
feeddownloadtracker stores feed download tracker
feeds stores feeds data
field_type_operator_mapping stores field type operation mapping data
googlemerchantdata stores Google merchant data
grpbuytype stores group buy type data
hivemetadata stores hive metadata info
hotelstype stores hotels type data
imagesizesmaster stores image size banner information
intellirecexperiment stores intelli rec experiment data
mediapartner stores media partner information
mobileappdetails stores mobile application details data
oauthclient stores oauth client information
oauthtoken stores oauth token information
oauthuser stores oauth user information
packagetype stores package type information
payouttype stores payout type information
planmonthlytarget stores play monthly target information
publishermarkup stores publisher mark up data
publisherzone stores publisher zone data
routeshistory stores routes history information
rtbbidrates stores rtb bid rates data
scheduledengagementmetadata stores schedule engagement meta data information
segmentexperimentsplit stores segment experiment split data
segmentgroupmapping stores segment group mapping data
segurls stores segment url information
selfservebanner stores self server banner data
selfservebannergroup stores self service banner group information
selfservetemplate stores self service template data
selfservetemplatesizes stores self service template size data
sourceevents stores source event data
sourceevents_propertytypes stores source events property types data
stage stores stage data
staticuploads stores static uploads data
tableauuser stores tableau user data
timezone stores time zone data
useruploads stores user uploads data
uservideouploads stores user video uploads data
wca_details stores wca details data
wca_newsfeed_banners stores wca news feed banners data
PBATenantUserRoles stores roles. Used in product based access to CDP
PBARoleProductMapping stores roles to product mapping. Used in product based access to CDP
PBARoleUserMapping stores roles to user mapping. Used in product based access to CDP
DMP-SST campaignencryptionkeymapping stores campaign encryption key
campaignunicoderangemapping stores campaign unicode range mapping data
cdpcustomerproperty stores customer properties info
cdpdestinationeventjsonmapping stores destination event json data mapping
cdpjsontemplate stores json template data
currency stores currency details
currencyconversion stores currency conversion
dmpairport stores airport data
dmpcampaigncategory stores dmp campaign category
dmpcampaigndatadictionary contains all the details of datapoints configured for each tenant at campaign level.
dmpcampaigndatasource contains details of all datasources for each tenant at campaign level.
dmpcampaigndatasourcemapping contains the details of mapping between metadata and datapoint at campaign level.
dmpcampaigndatasourceschema stores campaign data source schema data
dmpcampaignemaildetails stores campaign email details
dmpdataapicredentials stores data api credentials data
dmpdataapiparamsnode stores data api params node
dmpdataingestionapi stores API specific token information
dmpdatapoint stores data point information
dmpemaillandingpagejsonmacros stores email landing page json macros data
dmpglobaldatadictionary contains all the details of datapoints configured at global level.
dmpglobaldatasource contains details of all datasources at global level.
dmpglobaldatasourcemapping contains the details of mapping between metadata and datapoint at global level.
dmpjourneyversion stores journey version
dmpmasterdatasourcecampaignmapping stores master datasource campaign mapping data
dmpnbakeyformation stores nba key formation data
dmpreportautomation stores report automation data
dmpverticaldatadictionary contains all the details of datapoints configured for each tenant at vertical level.
dmpverticaldatasource contains details of all datasources for each tenant at vertical level.
dmpverticaldatasourcemapping contains the details of mapping between metadata and datapoint at vertical level.
flighttype stores flight type data
metaapiauth stores meta api authentication data
metaapiidtoengmapping stores meta api engine mapping data
productcategory stores product category data
Event Processor cdpcustomeventsdictionary stores custom event dictionary data
cdpcustomeventstransformers stores custom events transformer data
cdpdestinationinstance stores destination information
cdpdestinationinstancenifiprocessgroupmapping stores destination instance nifi processing group mapping data
cdpdestinationnifitemplatemapping stores destination nifi template mapping data
cdpsource stores all predefined source types available for source creation
cdpsourcedestinationinstancemapping stores mapping of source to destination
cdpsourceinstance stores new source created by user
cdpsourceinstancenifiprocessgroupmapping stores source instance nifi processing group mapping data
cdpsourcenifitemplatemapping stores source nifi template mapping data
cdpsourcetransformers stores JavaScript code for function
cdpstandardeventdictionary stores event specific information
cdpstandardeventspropscampaignmapping stores mapping info of campaign and event
cdpstandardeventstransformers stores standard event transformer info
eventdetails stores event details
hclcdp-ios-sdk userinfo stores user information data
Internal-libs securitycookie stores security cookie information
securitycookieregexmapping stores security cookie regex mapping information
securityparamregex stores security parameter regex data
transactionalcategory stores transaction category data
javascript-sdk cdpdestination stores destination data
cdppassthroughtransformers stores pass through transformer data
cdpsourcedestinationmapping stores source destination mapping data
httppixellistenerdomain stores http pixel listener domain data
httpspixellistenerdomain stores http pixel listener domain data
MA campaignvertical stores campaign vertical data
dmplandingpagejsonmacros stores landing page macro data
dmpsegmentabtest stores segment tab test data
MA (click tracker) campaign stores whether the campaign is active or not, whether campaign is part of real-time segmentation
dmpsmsengagement stores engagement SMS information
dmptriggerapiengagement stores trigger api engagement data
eedmpcampaignsmsclientmapping stores campaign SMS client mapping info
eedmpemailengagement stores email engagement info
email stored email details
emailclienttemplates stores email template info
engageplaceholder stores engagement placeholder info
smsclienttemplates stores SMS template data of client
smsconfiguration stores SMS configuration data
MA (trigger channels) dmpapppushnotificationengagement stores push notification engagement details
dmpcampaign stores dmp campaign data
dmpcampaignsmsdetails stores campaign SMS details
dmpcampaigntriggerapidetails stores campaign trigger data
dmpchannel stores channel data
dmpcountry stores country details
dmpnbamacroreplacement stores macro replacement data
dmpreportingqueue stores reporting queue data
dmpsegmentexportpublishermapping stores mapping of segment exports publisher data
dmpsmssendercampaignmapping stores mapping of sender and campaign
dmpsmstype stores types of SMS
dmptriggerapiauthdetails stores api authentication data
dmptriggerapidetails stores trigger api details
dmptriggerapiparams stores trigger api params info
dmptriggerapiparamsmapping stores trigger api params mapping data
dmptriggerchannelengagementdetailsview stores engagement channel view data
dmpwelcomenotificationsettings stores welcome notification for settings
dmpwhatsappengagement stores WhatsApp engagement info
mobidmpbrowserpushsettings stores browser push notification settings data
mobidmpemailnotification stores email notification data
mobidmpemailsettings stores email settings data
mobidmpemailtemplates Stores email template data
mobidmpfeedmetadata stored feed metadata information
schedulemetadata stores schedule information of meta-data
whatsappcampaignvendormapping stores WhatsApp campaign vendor mapping info
whatsappclients stores WhatsApp clients data
whatsappuploads stores WhatsApp upload data
MA (try out) dmpserviceprovider stores service provider information
dmpssthashalgorithmname stores hashing algorithm name
dmpssthashemptydefaults stores hash empty default data
dmptabs stores tabs data
dmpuserfeedrtsmetadata stores user feed meta data information
dmpusersinsight store user insight data
dmpvendortemplates stores vendor template data
dmpwebpushbasetemplate stores web pushbase data
MA(Flip) dmponsitenotificationengagement stores site notification engagement data
dmponsitenotificationtemplates stores site notification template data
dmponsiterecommendationengagement stores sire recommendation engagement data
dmponsiterecommendationslot stores site recommendation slot data
MA(Ramanjuam) businessgeo stores geo location of the business
campaignuseridpriority stores campaign user priority data
dmpcampaignchannel stores dmp campaign channel
dmpcampaignchannelmapping stores campaign channel mapping data
dmpcampaignvertical
dmpsegmentabtestmapping
dmpsegmentauditlog Stores the audit trail for segment changes, including when a segment was published (PublishedOn) and when its user count was refreshed (UserCountRefreshedOn).
dmpsegmentchannel stores segment associated with the channel and whether the channel is active or not.
dmpsegmentchannelabtest
dmpsegmentproducts
dmpwebpushnotificationengagement stores engagement push notification data
dsmodel stores model info
dssegmentmodel stores segment model data
dsusecase stores use case data
Pixel-listener advertiser stores advertiser info
advertiserplatforms stores advertiser platform data
advertiserpocdata stores advertiser poc data
campaignpublishercountrymapping
campaignpublishermapping
campaignshareableattribute stores campaign shareable attribute data
crosssellcampaign stores cross sell campaign data
datapixel stores data pixel data
dpacampaigndetails stores campaign details data
publisher stores publisher information
securityparam stores security param information
securityparamregexmapping stores security parameter regex mapping data
segmentallowedpublisher stores segment allowed publisher information
selectivepixelingrule stores selective pixeling rule information
shareableattribute stores shareable attribute data
webtomobilemapping stores web to mobile mapping data
Segmentation cdpcampaignuseridentifier stores campaign user identifier data
dmpfliproutes stores flip routes
dmpnbamapping stores mapping of dmp and nba
dmpofflineeventqueue stores offline event queue info
dmppredictivesegment informs whether the segment is predictive or not, product associated with the segment and the model key
dmprtspredictiveparams stores rts predictive params
dmpsegment contains the rule associated with a segment and the query to determine the number of users satisfying this rule. It also stores the last published timestamp (PublishedOn), the last user count refresh timestamp (UserCountRefreshedOn), and the associated event IDs (DetectEventIds).
fieldaliastable contains the name of the field which need to be displayed on UI, the data point associated with UI field, data type of UI field.
segment provides information related to specific segment. This information includes Campaign ID associated with the segment, whether segment is active or not, whether segment is DMP or not
SegmentAggregateMapping Stores the mapping between a segment's aggregate data and a specific campaign. Contains segmentId, aggregateName, and campaignId.
Web App funneltypes stores funnel type data
leadformconfigpost stores form configuration post data
pathmetricsconfig stores path metric configuration information