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.