ZenotiHelp

Campaign Dimension Table

ZTZenoti Docs Team Updated June 29, 2026 3 min readGuide

Dimension table storing campaign and promotional offer definitions including scheduling, targeting rules, discount associations, and catalog display settings. Populated from the campaign/promotion master data.

Columns

Column Name Data Type Nullable Description
campaignwid BIGINT IDENTITY No Surrogate warehouse key for the campaign dimension, auto-generated
campaignid VARCHAR(36) Yes Natural unique identifier (GUID) of the campaign from the source system
campaignname VARCHAR(512) Yes Name of the campaign
campaigntype INTEGER Yes Type of campaign (enumerated value)
startdate TIMESTAMP Yes Start date of the campaign
enddate TIMESTAMP Yes End date of the campaign
launchdate TIMESTAMP Yes Date when the campaign was launched
ruleid VARCHAR(36) Yes Identifier of the targeting/eligibility rule
campaignmessage VARCHAR(16000) Yes Message content of the campaign
active BOOLEAN Yes Whether the campaign is currently active
autoapply BOOLEAN Yes Whether the campaign offer is automatically applied
combineoffers BOOLEAN Yes Whether this campaign can be combined with other offers
allowgiftcertificates BOOLEAN Yes Whether gift certificates can be used with this campaign
scheduledatetime TIMESTAMP Yes Scheduled date and time for campaign execution
bookingstartdate TIMESTAMP Yes Start date for booking eligibility under this campaign
bookingenddate TIMESTAMP Yes End date for booking eligibility under this campaign
discountid VARCHAR(36) Yes Identifier of the associated discount definition
smscampaign INTEGER Yes Flag indicating whether this is an SMS campaign
allowothers BOOLEAN Yes Whether other offers/campaigns are allowed alongside this one
cashbackredeemedbyall BOOLEAN Yes Whether cashback can be redeemed by all users
minimumamount NUMERIC(19,4) Yes Minimum transaction amount required for the campaign to apply
validitydays INTEGER Yes Number of days the campaign offer remains valid
expirydate TIMESTAMP Yes Fixed expiry date for the campaign offer
showincatalog INTEGER Yes Flag indicating whether the campaign is visible in the catalog
programid VARCHAR(36) Yes Identifier of the associated loyalty/marketing program
appliesto INTEGER Yes Enumerated value indicating what the campaign applies to
needotpauthorization BOOLEAN Yes Whether OTP authorization is required for redemption
freeservicecommissioneligible BOOLEAN Yes Whether free services under this campaign are commission-eligible
alwayson BOOLEAN Yes Whether the campaign is always active (no date restriction)
sendruleid VARCHAR(36) Yes Identifier of the send/distribution rule
expirydays INTEGER Yes Number of days until the campaign expires
isbroadcast BOOLEAN Yes Whether the campaign is a broadcast-type campaign
sendonlyonce BOOLEAN Yes Whether the campaign communication is sent only once per guest
maximumamount NUMERIC(19,4) Yes Maximum transaction amount for the campaign to apply
opportunityowner VARCHAR(36) Yes Identifier of the opportunity owner (sales/marketing user)
metakeywords VARCHAR(1024) Yes SEO meta keywords for the campaign
metadescription VARCHAR(1024) Yes SEO meta description for the campaign
maxredemptiontimesperguest INTEGER Yes Maximum number of times a guest can redeem this campaign
void BOOLEAN Yes Soft-delete flag; TRUE indicates the record is voided/inactive
campaigndesc VARCHAR(4096) Yes Detailed description of the campaign
campaignfilepath VARCHAR(512) Yes File path for campaign-related assets/images
campaignopportunitytype VARCHAR(1024) Yes Type of opportunity associated with the campaign
webstorepagetitle VARCHAR(1024) Yes Page title for the campaign on the Webstore
campaigncode VARCHAR(4096) Yes Code identifier for the campaign
cashback VARCHAR(32) Yes Cashback value or percentage associated with the campaign

Note: All dimension tables also include standard ETL metadata columns (podname, organizationid, groupid, etlLastUpdatedOn, etlLastUpdatedBy) which are omitted from this reference for brevity.

Primary Key

campaignwid

Foreign Keys

Column References
organizationid Bi_DimCenter
discountid Bi_DimDiscount
ruleid the targeting/eligibility rule entity
sendruleid the send/distribution rule entity
programid the loyalty/marketing program entity
opportunityowner a user ID

Enumerator Values

Column Values
campaigntype 1 = Email
2 = SMS
3 = Push Notification
smscampaign 0 = Not SMS Campaign
1 = SMS Campaign
showincatalog (1 = show, 0 = hide)
appliesto 0 = All
1 = Guest
2 = Employee
Was this article helpful?
Your feedback helps us improve our documentation.