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.