ZenotiHelp

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.