ZenotiHelp

Package Benefits Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing the benefit items included in packages, linking packages to their constituent services, products, or other item types with quantities.

Columns

Column Name Data Type Nullable Description
PackageBenefitwid BIGINT IDENTITY No Surrogate warehouse identifier (auto-generated)
PackageId VARCHAR(36) Yes Unique identifier of the parent package
PackageVersionId VARCHAR(36) Yes Unique identifier of the specific package version
BenefitType VARCHAR(50) Yes Type/category of the benefit (e.g., service, product)
ItemID VARCHAR(36) Yes Unique identifier of the benefit item (service, product, etc.)
PK INT Yes Source system primary key for the benefit record
ItemType INT Yes Enumerator indicating the type of the benefit item
Quantity INT Yes Number of units of the benefit item included
ItemTags VARCHAR(65535) Yes Tags associated with the benefit item
void INT Yes Soft-delete flag (non-zero indicates voided)

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

PackageBenefitwid

Foreign Keys

Column References
PackageId the package dimension
PackageVersionId the specific package version
ItemID the benefit item (service, product, or other entity depending on ItemType)

Enumerator Values

Column Values
ItemType -1 = None
0 = Service
2 = Product
3 = Membership
4 = Series Package
5 = Day/Promo Package
6 = Gift Card
8 = Employee
11 = Class
14 = Add-ons
-90 = Service Refund
-92 = Product Refund
-93 = Membership Refund
-94 = Series Package Refund
-95 = Day Package Refund
-96 = Gift Card Refund
-911 = Class Refund
BenefitType Service
Product
Discount
Credit
Was this article helpful?
Your feedback helps us improve our documentation.