ZenotiHelp

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 id references DimGuest (purchasing guest)
  • redemption user id references DimGuest (redeeming guest)
  • center name, center wid, Center Code references DimCenter (sale center)
  • redemption center name, redemption center wid, redemption Center Code references DimCenter (redemption center)
  • invoiceid, invoiceitemid references invoice entity
  • gift card user id references 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.