ZenotiHelp

Package User Redemptions Fact Table

ZTZenoti Docs Team Updated April 10, 2026 4 min readGuide

Tracks package item redemptions by users, including sale details, payment information, pricing, discounts, and category metadata for products, services, and classes.

Columns

Column Name Data Type Nullable Description
factsegmentwid BIGINT IDENTITY NOT NULL Surrogate key for the package redemption fact record.
factsegmentid INTEGER NULL Business/natural key for the fact segment.
centerwid BIGINT NULL Foreign key to the center dimension (home center).
paymentcollectioncenterwid BIGINT NULL Foreign key to the center where payment was collected.
itemsalecenterwid BIGINT NULL Foreign key to the center where item was sold.
itemredemptioncenterwid BIGINT NULL Foreign key to the center where item was redeemed.
userwid BIGINT NULL Foreign key to the guest/customer user dimension.
salebywid BIGINT NULL Foreign key to the employee who made the sale.
closebywid BIGINT NULL Foreign key to the employee who closed the invoice.
createdbywid BIGINT NULL Foreign key to the employee who created the record.
itemtypewid BIGINT NULL Foreign key to the item type dimension.
itemwid BIGINT NULL Foreign key to the item dimension.
productwid BIGINT NULL Foreign key to the product dimension.
servicewid BIGINT NULL Foreign key to the service dimension.
packageversionwid BIGINT NULL Foreign key to the package version dimension.
packageuserwid BIGINT NULL Foreign key to the user-package association.
quantity INTEGER NULL Quantity of items in the package.
quantityredeemed INTEGER NULL Quantity of items redeemed.
saleprice DOUBLE PRECISION NULL Original sale price.
finalsaleprice DOUBLE PRECISION NULL Final sale price after discounts.
packagepaymentamount DOUBLE PRECISION NULL Payment amount for the package.
paymentmodenumber VARCHAR(36) NULL Payment mode reference number.
paymentdatetimeincenter TIMESTAMP NULL Payment date and time in center timezone.
paymentdateincenter DATE NULL Payment date in center timezone.
saledatetimeincenter TIMESTAMP NULL Sale date and time in center timezone.
saledateincenter DATE NULL Sale date in center timezone.
closeddatetimeincenter TIMESTAMP NULL Invoice close date and time in center timezone.
closeddateincenter DATE NULL Invoice close date in center timezone.
createddatetimeincenter TIMESTAMP NULL Record creation date and time in center timezone.
createddateincenter DATE NULL Record creation date in center timezone.
packageitemprice DOUBLE PRECISION NULL Price of the item within the package.
itempaymentamount DOUBLE PRECISION NULL Payment amount allocated to the item.
itemsaleprice DOUBLE PRECISION NULL Sale price of the individual item.
itemfinalsaleprice DOUBLE PRECISION NULL Final sale price of the individual item.
invoiceid VARCHAR(36) NULL Unique identifier (GUID) of the invoice.
invoiceitemid VARCHAR(36) NULL Unique identifier (GUID) of the invoice item.
refundinvoiceid VARCHAR(36) NULL GUID of the refund invoice, if applicable.
refundinvoiceitemid VARCHAR(36) NULL GUID of the refund invoice item, if applicable.
totalrefundvalue DOUBLE PRECISION NULL Total refund value for the item.
invoicestatus SMALLINT NULL Status code of the invoice.
transactionid VARCHAR(36) NULL Unique identifier (GUID) for the transaction.
paymentoptiontype VARCHAR(100) NULL Type of payment option used.
paymenttype VARCHAR(100) NULL Payment type description.
invoice_no VARCHAR(100) NULL Human-readable invoice number.
minimumredemptiondate DATE NULL Earliest date the package item can be redeemed.
maximumredemptiondate DATE NULL Latest date the package item can be redeemed.
podid INTEGER NULL Identifier of the source pod/database.
void INTEGER NULL Indicates whether the record has been voided.
redemptiondate TIMESTAMP NULL Date and time when the item was redeemed.
redeemedinvoiceitemid VARCHAR(36) NULL GUID of the invoice item for the redemption.
redemptionamount DOUBLE PRECISION NULL Monetary value of the redemption.
itemsalebyid VARCHAR(36) NULL GUID of the employee who sold the item.
itemdiscount DOUBLE PRECISION NULL Discount amount applied to the item.
unititemdiscount VARCHAR(64) NULL Unit or percentage descriptor of the item discount.
resourcewid BIGINT NULL Foreign key to the resource dimension.
therapistwid BIGINT NULL Foreign key to the therapist/provider user dimension.
itemlistprice DOUBLE PRECISION NULL List price of the item.
approvalnumber VARCHAR(256) NULL Payment approval/authorization number.
creditcardlastfourdigits VARCHAR(32) NULL Last four digits of the credit card used.
unititemtype INTEGER NULL Type code for the unit item.
productcategoryname VARCHAR(512) NULL Name of the product category.
productcategorycode VARCHAR(64) NULL Code of the product category.
productparentcategoryname VARCHAR(512) NULL Name of the product parent category.
productparentcategorycode VARCHAR(64) NULL Code of the product parent category.
producttagname VARCHAR(510) NULL Tag name associated with the product.
servicecategoryname VARCHAR(512) NULL Name of the service category.
servicecategorycode VARCHAR(64) NULL Code of the service category.
serviceparentcategoryname VARCHAR(512) NULL Name of the service parent category.
serviceparentcategorycode VARCHAR(64) NULL Code of the service parent category.
servicetagname VARCHAR(510) NULL Tag name associated with the service.
classwid BIGINT NULL Foreign key to the class dimension.
classcategoryname VARCHAR(512) NULL Name of the class category.
classcategorycode VARCHAR(64) NULL Code of the class category.
classparentcategoryname VARCHAR(512) NULL Name of the class parent category.
classparentcategorycode VARCHAR(64) NULL Code of the class parent category.
classtagname VARCHAR(510) NULL Tag name associated with the class.
benefitrefundqty INTEGER NULL Quantity of benefit items refunded.

Note: All fact tables also include standard ETL metadata columns (podname, organizationid, groupid, etlCreatedDate) which are omitted from this reference for brevity.

Primary Key

factsegmentwid

Foreign Keys

Column References
centerwid Bi_DimCenter.centerwid
paymentcollectioncenterwid Bi_DimCenter.centerwid
itemsalecenterwid Bi_DimCenter.centerwid
itemredemptioncenterwid Bi_DimCenter.centerwid
userwid Bi_DimUser.userwid
salebywid Bi_DimUser.userwid
closebywid Bi_DimUser.userwid
createdbywid Bi_DimUser.userwid
therapistwid Bi_DimUser.userwid
closeddateincenter Bi_DimDate.datewid
createddateincenter Bi_DimDate.datewid
paymentdateincenter Bi_DimDate.datewid
saledateincenter Bi_DimDate.datewid

Enumerator Values

Column Values
invoicestatus 0 = Open
1 = Open
2 = Open
3 = Open
4 = Closed
void 0 = active, non-zero = voided
unititemtype 0 = Service
2 = Product
11 = Class
Was this article helpful?
Your feedback helps us improve our documentation.