Giftcards Fact Consolidated
ZTZenoti Docs Team Updated April 10, 2026 4 min readGuide
Consolidated fact table capturing gift card lifecycle events including sales, redemptions, and closures with associated center, user, item, and financial details.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| redemption date | DATE | Yes | Date when the gift card was redeemed. |
| sale date | DATE | Yes | Date when the gift card was sold. |
| closed date | DATE | Yes | Date when the gift card was closed. |
| organization name | VARCHAR(256) | Yes | Name of the organization. Sourced from DimOrganization.organization_name. |
| organization account name | VARCHAR(256) | Yes | Account name of the organization. Sourced from DimOrganization.organization_account_name. |
| zone name | VARCHAR(256) | Yes | Zone name of the sale center. Sourced from DimCenter.zone_name. |
| center name | VARCHAR(256) | Yes | Name of the sale center. Sourced from DimCenter.center_name. |
| center city | VARCHAR(256) | Yes | City of the sale center. Sourced from DimCenter.city. |
| center zip | VARCHAR(128) | Yes | Zip code of the sale center. Sourced from DimCenter.zip. |
| center state name | VARCHAR(128) | Yes | State of the sale center. Sourced from DimCenter.state_name. |
| country name | VARCHAR(128) | Yes | Country of the sale center. Sourced from DimCenter.country_name. |
| operating center | BOOLEAN | Yes | Indicates whether the sale center is operating. Sourced from DimCenter.operating_center. |
| center wid | BIGINT | Yes | Warehouse identifier for the sale center. Sourced from DimCenter.center_wid. |
| minutestoadd | INTEGER | Yes | Timezone offset in minutes for the sale center. |
| item name | VARCHAR(512) | Yes | Name of the gift card item sold. |
| item code | VARCHAR(256) | Yes | Code of the gift card item sold. |
| item buisness unit name | VARCHAR(65535) | Yes | Business unit name of the sold item. |
| item tags | VARCHAR(65535) | Yes | Tags associated with the sold item. |
| redemption item name | VARCHAR(512) | Yes | Name of the item used for redemption. |
| redemption item code | VARCHAR(256) | Yes | Code of the item used for redemption. |
| redemption item buisness unit name | VARCHAR(65535) | Yes | Business unit name of the redemption item. |
| redemption item tags | VARCHAR(65535) | Yes | Tags associated with the redemption item. |
| redemption organization name | VARCHAR(256) | Yes | Organization name of the redemption center. Sourced from DimOrganization.organization_name (redemption). |
| redemption organization account name | VARCHAR(256) | Yes | Organization account name of the redemption center. Sourced from DimOrganization.organization_account_name (redemption). |
| redemption zone name | VARCHAR(256) | Yes | Zone name of the redemption center. Sourced from DimCenter.zone_name (redemption). |
| redemption center name | VARCHAR(256) | Yes | Name of the redemption center. Sourced from DimCenter.center_name (redemption). |
| redemption center city | VARCHAR(256) | Yes | City of the redemption center. Sourced from DimCenter.city (redemption). |
| redemption center zip | VARCHAR(128) | Yes | Zip code of the redemption center. Sourced from DimCenter.zip (redemption). |
| redemption center state name | VARCHAR(128) | Yes | State of the redemption center. Sourced from DimCenter.state_name (redemption). |
| redemption country name | VARCHAR(128) | Yes | Country of the redemption center. Sourced from DimCenter.country_name (redemption). |
| redemption operating center | BOOLEAN | Yes | Indicates whether the redemption center is operating. Sourced from DimCenter.operating_center (redemption). |
| redemption center wid | BIGINT | Yes | Warehouse identifier for the redemption center. Sourced from DimCenter.center_wid (redemption). |
| redemption minutestoadd | INTEGER | Yes | Timezone offset in minutes for the redemption center. |
| user id | VARCHAR(36) | Yes | Unique identifier (UUID) of the purchasing guest. Sourced from DimGuest.user_id. |
| user first name | VARCHAR(160) | Yes | First name of the purchasing guest. Sourced from DimGuest.first_name. |
| user last name | VARCHAR(256) | Yes | Last name of the purchasing guest. Sourced from DimGuest.last_name. |
| user middle name | VARCHAR(128) | Yes | Middle name of the purchasing guest. Sourced from DimGuest.middle_name. |
| user base center | VARCHAR(256) | Yes | Base center of the purchasing guest. Sourced from DimGuest.base_center. |
| redemption user id | VARCHAR(36) | Yes | Unique identifier (UUID) of the redeeming guest. Sourced from DimGuest.user_id (redemption). |
| redemption user first name | VARCHAR(160) | Yes | First name of the redeeming guest. Sourced from DimGuest.first_name (redemption). |
| redemption user last name | VARCHAR(256) | Yes | Last name of the redeeming guest. Sourced from DimGuest.last_name (redemption). |
| redemption user middle name | VARCHAR(128) | Yes | Middle name of the redeeming guest. Sourced from DimGuest.middle_name (redemption). |
| invoiceid | VARCHAR(36) | Yes | Unique identifier (UUID) of the invoice. |
| invoiceitemid | VARCHAR(36) | Yes | Unique identifier (UUID) of the invoice item. |
| item type code | VARCHAR(128) | Yes | Code representing the type of item. |
| expiry date | DATE | Yes | Expiry date of the gift card. |
| sale price | FLOAT | Yes | Sale price of the gift card. |
| gift card value | FLOAT | Yes | Monetary value loaded on the gift card. |
| redeemed amount | FLOAT | Yes | Amount redeemed from the gift card. |
| factortoprice | FLOAT | Yes | Factor applied to the price calculation. |
| discount | FLOAT | Yes | Discount amount applied to the gift card. |
| tax | FLOAT | Yes | Tax amount applied to the gift card. |
| record type name | VARCHAR(36) | Yes | Name of the record type (e.g., Sale, Redemption). |
| is gift card | BOOLEAN | Yes | Indicates whether the record is a gift card. |
| gift card id | VARCHAR(36) | Yes | Unique identifier (UUID) of the gift card. |
| gift card code | VARCHAR(1024) | Yes | Code assigned to the gift card. |
| gift card validity days | INTEGER | Yes | Number of days the gift card is valid. |
| gift card user id | VARCHAR(36) | Yes | User ID associated with the gift card ownership. |
| factgiftcardid | BIGINT | Yes | Fact gift card identifier. |
| factgiftcardwid | BIGINT | Yes | Fact gift card warehouse identifier. |
| activation date | TIMESTAMP | Yes | Date and time when the gift card was activated. |
| Center Code | VARCHAR(40) | Yes | Code of the sale center. Sourced from DimCenter.center_code. |
| redemption Center Code | VARCHAR(40) | Yes | Code of the redemption center. Sourced from DimCenter.center_code (redemption). |
| invoice no | VARCHAR(160) | Yes | Invoice number associated with the transaction. |
Primary Key
No explicit primary key is defined. gift card id combined with record type name serves as a logical key. factgiftcardwid is a surrogate warehouse identifier.
Foreign Keys
user idreferences DimGuest (purchasing guest)redemption user idreferences DimGuest (redeeming guest)center name,center wid,Center Codereferences DimCenter (sale center)redemption center name,redemption center wid,redemption Center Codereferences DimCenter (redemption center)invoiceid,invoiceitemidreferences invoice entitygift card user idreferences DimGuest (gift card owner)
Enumerator Values
| Column Name | Known Values |
|---|---|
| record type name | Sale, Redemption, Closure |
| is gift card | true, false |
| item type code | GiftCard, PrepaidCard, etc. |
Standard ETL metadata columns (EtlLastUpdatedOn, EtlLastUpdatedBy, podname, groupid) are present in the underlying table but omitted from this reference for brevity.
Was this article helpful?
Your feedback helps us improve our documentation.