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.