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.