ZenotiHelp

Package User Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide

Dimension table storing denormalized package-user purchase details including package pricing, status, closure information, and user demographics. Populated from package purchase transactional data.

Columns

Column Name Data Type Nullable Description
packageuserwid BIGINT IDENTITY No Surrogate warehouse key for the package user dimension
packageuserid VARCHAR(36) Yes Unique identifier of the user-package association
packageid VARCHAR(36) Yes Identifier of the package plan
userid VARCHAR(36) Yes Identifier of the guest/user who purchased the package
creationdate TIMESTAMP Yes Timestamp when the package-user record was created
startdate TIMESTAMP Yes Effective start timestamp of the package
enddate TIMESTAMP Yes Effective end timestamp of the package
invoiceid VARCHAR(36) Yes Identifier of the sale invoice
enddatewithgraceperiod TIMESTAMP Yes End date extended by the configured grace period
closed BOOLEAN Yes Flag indicating whether the package has been closed out
closedby VARCHAR(36) Yes Identifier of the user who closed the package
closedon TIMESTAMP Yes Timestamp when the package was closed
closedinvoice VARCHAR(36) Yes Identifier of the invoice associated with closure
packageuserpk NUMERIC(19,0) Yes Source system primary key for the package-user record
packagestatus INTEGER Yes Numeric status code of the package
invoiceitemid VARCHAR(36) Yes Identifier of the invoice item associated with the package
void BOOLEAN Yes Soft-delete flag; TRUE means the record is logically deleted
podid INTEGER Yes Identifier of the source pod
packageprice NUMERIC(19,4) Yes Price of the package at time of purchase
businessunitid VARCHAR(36) Yes Identifier of the business unit
salecenterid VARCHAR(36) Yes Identifier of the center where the sale occurred
packagecode VARCHAR(1024) Yes Short code of the package plan
packagename VARCHAR(1024) Yes Display name of the package plan
firstname VARCHAR(1024) Yes First name of the package holder
lastname VARCHAR(1024) Yes Last name of the package holder
centerid VARCHAR(36) Yes Identifier of the associated center

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

packageuserwid

Foreign Keys

Column References
userid Bi_DimUser / Bi_DimGuest
packageid Bi_DimPackage.packageid
invoiceid Fact invoice reference
invoiceitemid Fact invoice item reference
salecenterid Bi_DimCenter.centerid
centerid Bi_DimCenter.centerid
businessunitid Bi_DimBusinessUnit.businessunitid

Enumerator Values

Column Values
packagestatus 0 = All
1 = Active
2 = Inactive
3 = Expired
4 = Closed
Was this article helpful?
Your feedback helps us improve our documentation.