Package user dimension table
bi_dimpackageuser
Field | Description | Field Type | Primary Key |
|---|---|---|---|
businessunitid | Unique identifier of the business unit to which the package belongs | varchar ( 36 ) | |
centerid | Identifier of the associated center | varchar ( 36 ) | |
closed | Flag indicating whether the package has been closed out | boolean | |
closedby | Identifier of the user who closed the package | varchar ( 36 ) | |
closedinvoice | Identifier of the invoice associated with the closure of the package | varchar ( 36 ) | |
closedon | Timestamp indicating when the package was closed | timestamp without time zone | |
creationdate | Date when the package was originally created | timestamp without time zone | |
enddate | Date on which the package's validity period ends | timestamp without time zone | |
enddatewithgraceperiod | Extended end date that includes any configured grace period beyond the standard expiry date, giving guests additional time to use remaining package benefits | timestamp without time zone | |
etllastupdatedby | ETL system admin user who inserted or updated the corresponding record in this table | varchar ( 50 ) | |
etllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in this table | timestamp without time zone | |
firstname | First name of the guest who purchased the package | varchar ( 1024 ) | |
invoiceid | Identifier of the sale invoice through which the package was purchased | varchar ( 36 ) | |
invoiceitemid | Identifier of the invoice item associated with the package | varchar ( 36 ) | |
lastname | Last name of the guest who purchased the package | varchar ( 1024 ) | |
organizationid | Unique identifier of the organization | varchar ( 36 ) | |
packagecode | Alphanumeric code assigned to the package at the time of creation. Used as a short identifier for the package in reports and POS | varchar ( 1024 ) | |
packageid | Identifier of the package plan | varchar ( 36 ) | |
packagename | Display name of the package | varchar ( 1024 ) | |
packageprice | Price of the package at time of purchase | numeric | |
packagestatus | Current status of the guest's package. Possible values represent states such as Active, Expired, Cancelled, Frozen, or Closed | integer | |
packageuserid | Unique identifier of the user-package association | varchar ( 36 ) | |
packageuserpk | Primary key of the user–package record in the Zenoti source database | numeric | |
packageuserwid | Surrogate warehouse key for the package user dimension | bigint | Yes |
podid | Unique identifier of the point of delivery | integer | |
podname | Name of the point of delivery | varchar ( 20 ) | |
salecenterid | Unique identifier of the center where the package was originally sold. May differ from centerid when a package is sold at one center and redeemed at another | varchar ( 36 ) | |
startdate | Date from which the package becomes active and guests can begin redeeming benefits | timestamp without time zone | |
userid | Identifier of the guest who purchased the package | varchar ( 36 ) | |
void | Soft-delete flag; TRUE means the record is logically deleted | boolean | |
groupid | Internal to Zenoti. Used for data processing. | BIGINT |