Package Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 3 min readGuide
Dimension table storing package version definitions including pricing, validity, commission settings, target/visit tracking, and catalog display options. Populated from the package and package version master data.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| packageversionwid | BIGINT IDENTITY | No | Surrogate warehouse key for the package version dimension, auto-generated |
| packageversionid | VARCHAR(36) | Yes | Natural unique identifier (GUID) of the package version from the source system |
| packageid | VARCHAR(36) | Yes | Identifier of the parent package definition |
| bookingstartdate | TIMESTAMP | Yes | Date when the package becomes available for booking |
| bookingenddate | TIMESTAMP | Yes | Date when the package is no longer available for booking |
| allowgiftcertificates | BOOLEAN | Yes | Whether gift certificates can be used with this package |
| packageprice | NUMERIC(19,4) | Yes | Price of the package |
| comissionpercentage | DOUBLE PRECISION | Yes | Commission percentage for the package |
| packagetype | INTEGER | Yes | Type of package (enumerated value) |
| expirationdays | INTEGER | Yes | Number of days until the package expires from date of purchase |
| expirationdate | TIMESTAMP | Yes | Fixed expiration date for the package |
| enddate | TIMESTAMP | Yes | End date of the package version validity |
| comissioneligible | BOOLEAN | Yes | Whether the package is eligible for commission |
| commissionfactor | DOUBLE PRECISION | Yes | Commission factor/multiplier for the package |
| packagelength | INTEGER | Yes | Duration or length of the package in days |
| custom | BOOLEAN | Yes | Whether the package is a custom/personalized package |
| allowmembershipredemption | BOOLEAN | Yes | Whether membership credits can be redeemed against this package |
| showprice | BOOLEAN | Yes | Whether the price should be displayed in the catalog |
| packagecategoryid | VARCHAR(36) | Yes | Identifier of the package category |
| businessunitid | VARCHAR(36) | Yes | Identifier of the business unit the package belongs to |
| iscustomtemplate | BOOLEAN | Yes | Whether this package serves as a template for custom packages |
| templatepackageversionid | VARCHAR(36) | Yes | Identifier of the template package version this was derived from |
| redemptionfrequencydays | INTEGER | Yes | Minimum days between redemptions |
| visits | INTEGER | Yes | Number of visits included in the package |
| targetvalue | DOUBLE PRECISION | Yes | Target value for the package (revenue or service target) |
| closeontargetcompletion | BOOLEAN | Yes | Whether the package closes automatically when the target is met |
| initiallyrecognized | DOUBLE PRECISION | Yes | Percentage or amount recognized as revenue at the time of sale |
| sortorder | INTEGER | Yes | Sort order for display in the catalog |
| packagevaliditymodelid | VARCHAR(36) | Yes | Identifier of the validity model used for the package |
| active | BOOLEAN | Yes | Whether the package version is currently active |
| targettype | INTEGER | Yes | Type of target (enumerated value, e.g., visit-based, value-based) |
| packagefreezecount | INTEGER | Yes | Number of times the package can be frozen/paused |
| commissiontype | INTEGER | Yes | Type of commission calculation (e.g., percentage, flat) |
| flatcommissionvalue | DOUBLE PRECISION | Yes | Flat commission value when commissiontype is flat |
| packageinternalcost | NUMERIC(19,4) | Yes | Internal cost of the package |
| minpartialamount | NUMERIC(19,4) | Yes | Minimum partial payment amount allowed |
| isofferpackage | BOOLEAN | Yes | Whether this is a promotional offer package |
| prereqqty | INTEGER | Yes | Prerequisite quantity for offer packages (buy X) |
| freeqty | INTEGER | Yes | Free quantity for offer packages (get Y free) |
| void | BOOLEAN | Yes | Soft-delete flag; TRUE indicates the record is voided/inactive |
| tags | VARCHAR(65535) | Yes | Tags associated with the package for categorization/filtering |
| graceperiod | VARCHAR(40) | Yes | Grace period definition after package expiration |
| packagedesc | VARCHAR(65535) | Yes | Detailed description of the package |
| packagecode | VARCHAR(512) | Yes | Short code identifier for the package |
| packagedisplayname | VARCHAR(512) | Yes | Display name for the package in catalogs |
| packagecategoryname | VARCHAR(800) | Yes | Name of the package category |
| businessunitname | VARCHAR(800) | Yes | Name of the associated business unit |
| packagecategorydescription | VARCHAR(65535) | Yes | Description of the package category |
| businessunitdescription | VARCHAR(65535) | Yes | Description of the associated business unit |
| metadescription | VARCHAR(65535) | Yes | SEO meta description for the package |
| metakeywords | VARCHAR(1024) | Yes | SEO meta keywords for the package |
| packagecatalogprice | VARCHAR(128) | Yes | Catalog display price of the package (stored as string for formatting) |
| targetname | VARCHAR(1024) | Yes | Name/label for the package target |
| packageowner | VARCHAR(1024) | Yes | Owner/creator of the package |
| packagename | VARCHAR(1024) | Yes | Full name of the package |
| showincatalog | INT | Yes | Flag indicating whether the package is visible in the catalog (1 = visible) |
| IsServiceBundleDayPackage | BOOLEAN | Yes | Whether this package is a service bundle day package |
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
packageversionwid
Foreign Keys
| Column | References |
|---|---|
| organizationid | Bi_DimCenter |
| packageid | the parent package definition |
| packagecategoryid | the package category entity |
| businessunitid | the business unit entity |
| templatepackageversionid | another package version (template) |
| packagevaliditymodelid | the validity model entity |
Enumerator Values
| Column | Values |
|---|---|
| packagetype | 4 = Series Package 5 = Day/Promo Package |
| targettype | 1 = Visit-based 2 = Value-based |
| commissiontype | 1 = Flat 2 = Percentage 3 = Tiered |
| showincatalog | (1 = show, 0 = hide) |
Was this article helpful?
Your feedback helps us improve our documentation.