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.