ZenotiHelp

Gift Card Dimension Table

ZTZenoti Docs Team Updated October 7, 2026 2 min readGuide

Dimension table storing gift card and gift certificate definitions including value, validity, commission eligibility, and associated promotion details. Populated from the gift card master data and promotion configuration.

Columns

Column Name Data Type Nullable Description
giftcardwid BIGINT IDENTITY No Surrogate warehouse key for the gift card dimension, auto-generated
giftcardid VARCHAR(36) Yes Natural unique identifier (GUID) of the gift card from the source system
giftcardvalue NUMERIC(19,4) Yes Monetary value loaded on the gift card
creationdate TIMESTAMP Yes Timestamp when the gift card was created
giftcardpurchaseprice NUMERIC(19,4) Yes Purchase price paid for the gift card
giftcardvaliditydays INTEGER Yes Number of days the gift card remains valid
isonetimeuse BOOLEAN Yes Whether the gift card can only be used once
isgiftcard BOOLEAN Yes Whether this is a gift card (TRUE) vs. gift certificate (FALSE)
tax NUMERIC(19,4) Yes Tax amount applicable to the gift card
centertaxid VARCHAR(36) Yes Identifier of the center-specific tax configuration
expirydate TIMESTAMP Yes Fixed expiry date of the gift card
comissioneligible BOOLEAN Yes Whether the gift card sale is eligible for commission
freeservicecommissioneligible BOOLEAN Yes Whether free services redeemed via this gift card are commission-eligible
gifttypeid VARCHAR(36) Yes Identifier of the gift type classification
recipientid VARCHAR(36) Yes Identifier of the gift card recipient
authenticatedby VARCHAR(36) Yes Identifier of the user who authenticated/approved the gift card
gifttypefrequency INTEGER Yes Frequency setting for the gift type
void BOOLEAN Yes Soft-delete flag; TRUE indicates the record is voided/inactive
gifttypedesc VARCHAR(65535) Yes Description of the gift type
recipientname VARCHAR(1024) Yes Name of the gift card recipient
gifttypename VARCHAR(1024) Yes Name of the gift type
giftcardcode VARCHAR(1024) Yes Unique code printed on the gift card
notes VARCHAR(65535) Yes Additional notes about the gift card
gifttypecode VARCHAR(256) Yes Short code for the gift type
isbonusgiftcard BOOLEAN Yes Whether this is a bonus gift card issued through a promotion
promotionname VARCHAR(2048) Yes Name of the associated promotion (for bonus gift cards)
promotioncode VARCHAR(512) Yes Code of the associated promotion
promotiondescription VARCHAR(32000) Yes Description of the associated promotion
prmotionrulecriteria VARCHAR(2000) Yes Rule criteria for the associated promotion
promotionruleminimumvalue NUMERIC(19,4) Yes Minimum value threshold for the promotion rule
promotionrulemaximumvalue NUMERIC(19,4) Yes Maximum value threshold for the promotion rule
promotionrulebonusvalue NUMERIC(19,4) Yes Bonus value awarded by the promotion rule
templatename NVARCHAR(1024) Yes Name of the gift card template used
templatedescription NVARCHAR(8192) Yes Description of the gift card template
activationdate TIMESTAMP Yes Date when the gift card was activated
businessunitid VARCHAR(36) Yes Identifier (GUID) of the business unit the gift card is assigned to
businessunitname VARCHAR(800) Yes Name of the business unit the gift card is assigned to

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

giftcardwid

Foreign Keys

Column References
organizationid Bi_DimCenter
recipientid a user/guest ID
authenticatedby a user ID
gifttypeid the gift type entity
centertaxid the center tax configuration
Was this article helpful?
Your feedback helps us improve our documentation.