Campaign dimension table
Table Name | Column Name | Column Type | Primary Key |
|---|---|---|---|
Bi_DimCampaign_s3 | campaignid | VARCHAR(36) | PK |
Bi_DimCampaign_s3 | CampaignName | NVARCHAR(512) | |
Bi_DimCampaign_s3 | CampaignDesc | NVARCHAR(4096) | |
Bi_DimCampaign_s3 | CampaignType | INT | |
Bi_DimCampaign_s3 | CampaignFilePath | NVARCHAR(512) | |
Bi_DimCampaign_s3 | StartDate | TIMESTAMP | |
Bi_DimCampaign_s3 | EndDate | TIMESTAMP | |
Bi_DimCampaign_s3 | LaunchDate | TIMESTAMP | |
Bi_DimCampaign_s3 | RuleId | VARCHAR(36) | |
Bi_DimCampaign_s3 | CampaignMessage | NVARCHAR(16000) | |
Bi_DimCampaign_s3 | Active | BOOLEAN | |
Bi_DimCampaign_s3 | AutoApply | BOOLEAN | |
Bi_DimCampaign_s3 | CombineOffers | BOOLEAN | |
Bi_DimCampaign_s3 | AllowGiftCertificates | BOOLEAN | |
Bi_DimCampaign_s3 | ScheduleDateTime | TIMESTAMP | |
Bi_DimCampaign_s3 | OrganizationId | VARCHAR(36) | |
Bi_DimCampaign_s3 | BookingStartDate | TIMESTAMP | |
Bi_DimCampaign_s3 | BookingEndDate | TIMESTAMP | |
Bi_DimCampaign_s3 | CampaignCode | NVARCHAR(4096) | |
Bi_DimCampaign_s3 | DiscountId | VARCHAR(36) | |
Bi_DimCampaign_s3 | Cashback | NVARCHAR(32) | |
Bi_DimCampaign_s3 | SMSCampaign | INT | |
Bi_DimCampaign_s3 | allowothers | BOOLEAN | |
Bi_DimCampaign_s3 | CashbackRedeemedByAll | BOOLEAN | |
Bi_DimCampaign_s3 | MinimumAmount | DECIMAL(19,4) | |
Bi_DimCampaign_s3 | ValidityDays | INT | |
Bi_DimCampaign_s3 | ExpiryDate | TIMESTAMP | |
Bi_DimCampaign_s3 | ShowInCatalog | INT | |
Bi_DimCampaign_s3 | ProgramId | VARCHAR(36) | |
Bi_DimCampaign_s3 | AppliesTo | INT | |
Bi_DimCampaign_s3 | NeedOtpAuthorization | BOOLEAN | |
Bi_DimCampaign_s3 | FreeServiceCommissionEligible | BOOLEAN | |
Bi_DimCampaign_s3 | AlwaysOn | BOOLEAN | |
Bi_DimCampaign_s3 | SendRuleId | VARCHAR(36) | |
Bi_DimCampaign_s3 | ExpiryDays | INT | |
Bi_DimCampaign_s3 | IsBroadcast | BOOLEAN | |
Bi_DimCampaign_s3 | SendOnlyOnce | BOOLEAN | |
Bi_DimCampaign_s3 | MaximumAmount | DECIMAL(19,4) | |
Bi_DimCampaign_s3 | OpportunityOwner | VARCHAR(36) | |
Bi_DimCampaign_s3 | CampaignOpportunityType | NVARCHAR(1024) | |
Bi_DimCampaign_s3 | WebstorePageTitle | NVARCHAR(1024) | |
Bi_DimCampaign_s3 | MetaKeywords | NVARCHAR(1024) | |
Bi_DimCampaign_s3 | MetaDescription | NVARCHAR(1024) | |
Bi_DimCampaign_s3 | MaxRedemptionTimesPerGuest | INT | |
Bi_DimCampaign_s3 | Void | BOOLEAN | |
Bi_DimCampaign_s3 | EtlLastUpdatedOn | TIMESTAMP | |
Bi_DimCampaign_s3 | EtlLastUpdatedBy | NVARCHAR(50) | |
Bi_DimCampaign_s3 | PodName | VARCHAR(20) | |
Bi_DimCampaign_s3 | groupid | BIGINT |