Session Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 3 min readGuide
Dimension table storing session-level details for training classes, including scheduling, pricing, capacity, commission, and booking configuration.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| dimsessionwid | BIGINT IDENTITY | No | Surrogate warehouse identifier (auto-generated) |
| sessionpk | BIGINT | Yes | Source system primary key for the session |
| classfk | BIGINT | Yes | Foreign key to the parent training class |
| centerid | VARCHAR(36) | Yes | Unique identifier of the center |
| sessionname | NVARCHAR(256) | Yes | Display name of the session |
| sessioncode | NVARCHAR(32) | Yes | Short code identifying the session |
| sessionstartdt | TIMESTAMP | Yes | Scheduled start date/time of the session |
| sessionenddt | TIMESTAMP | Yes | Scheduled end date/time of the session |
| internalcost | NUMERIC(19,4) | Yes | Internal cost associated with the session |
| iscancelled | BOOLEAN | Yes | Indicates whether the session has been cancelled |
| instructoruserid | VARCHAR(36) | Yes | User ID of the assigned instructor |
| assistantuserid | VARCHAR(36) | Yes | User ID of the assigned assistant |
| roomresourceid | VARCHAR(36) | Yes | Resource ID of the room assigned to the session |
| catalogname | NVARCHAR(128) | Yes | Name used for the session in the catalog |
| showincatalog | INT | Yes | Flag indicating if session is displayed in the catalog |
| showprice | BOOLEAN | Yes | Flag indicating if the price is shown in the catalog |
| catalogprice | NVARCHAR(32) | Yes | Display price for the catalog listing |
| void | BOOLEAN | Yes | Soft-delete flag for the session record |
| capacity | INT | Yes | Maximum in-person capacity for the session |
| webcapacity | INT | Yes | Maximum web/online capacity for the session |
| isopenforreg | BOOLEAN | Yes | Indicates if the session is open for registration |
| canbook | BOOLEAN | Yes | Indicates if clients can book this session |
| allowdirectbooking | BOOLEAN | Yes | Indicates if direct booking (without approval) is allowed |
| minsbeforeclasswebbookingclose | INT | Yes | Minutes before class start when web booking closes |
| minsafterregistrationforearlycancel | INT | Yes | Minutes after registration allowed for early cancellation |
| recoverytime | INT | Yes | Recovery time in minutes after the session ends |
| comissioneligible | BOOLEAN | Yes | Indicates if the session is eligible for commission |
| commissionfactor | FLOAT | Yes | Multiplier used for commission calculation |
| commissiontype | INT | Yes | Type of commission applied |
| flatcommissionvalue | FLOAT | Yes | Flat commission amount when commission type is flat |
| earlycancellationfee | NUMERIC(19,4) | Yes | Fee charged for early cancellation |
| latecancellationfee | NUMERIC(19,4) | Yes | Fee charged for late cancellation |
| noshowfee | NUMERIC(19,4) | Yes | Fee charged for a no-show |
| allowwaitlist | BOOLEAN | Yes | Indicates if a waitlist is enabled |
| allowsubstitution | BOOLEAN | Yes | Indicates if substitution of attendees is allowed |
| lock | BOOLEAN | Yes | Indicates if the session is locked from changes |
| statusfk | INT | Yes | Foreign key to the session status enumerator |
| classrecurrencefk | BIGINT | Yes | Foreign key to the class recurrence rule |
| waitlistlockwindow | INT | Yes | Minutes before class start when the waitlist locks |
| isfreesession | BOOLEAN | Yes | Indicates if the session is free of charge |
| registrationlockwindow | FLOAT | Yes | Hours before class start when registration locks |
| automaticconfirmationlockwindow | FLOAT | Yes | Hours before class start when automatic confirmation locks |
| eventfk | BIGINT | Yes | Foreign key to the parent event |
| isinstructorsubstituted | BOOLEAN | Yes | Indicates if the instructor has been substituted |
| instructorvirtuallink | NVARCHAR(MAX) | Yes | Virtual meeting link for the instructor |
| studentvirtuallink | NVARCHAR(MAX) | Yes | Virtual meeting link for students |
| minsbeforeclassforearlycancel | INT | Yes | Minutes before class start allowed for early cancellation |
| sessiondesc | NVARCHAR(MAX) | Yes | Full description of the session |
| classname | NVARCHAR(128) | Yes | Name of the parent class |
| categoryfk | BIGINT | Yes | Foreign key to the session category |
| classcode | NVARCHAR(32) | Yes | Short code of the parent class |
| businessunitfk | BIGINT | Yes | Foreign key to the business unit |
| durationinmins | INT | Yes | Duration of the session in minutes |
| classdesc | NVARCHAR(MAX) | Yes | Description of the parent class |
| waitinglisttype | INT | Yes | Type of waiting list behavior |
| levelfk | BIGINT | Yes | Foreign key to the difficulty/skill level |
| enablepayments | BOOLEAN | Yes | Indicates if payments are enabled for the session |
| classtype | INT | Yes | Type/category of the class |
| dimsegmentid | BIGINT | Yes | Foreign key to the segment dimension |
| classvoid | BOOLEAN | Yes | Soft-delete flag for the parent class |
| initialinstructorid | VARCHAR(36) | Yes | User ID of the originally assigned instructor |
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
dimsessionwid
Foreign Keys
| Column | References |
|---|---|
| classfk | the parent training class |
| categoryfk | the session category dimension |
| businessunitfk | the business unit dimension |
| levelfk | the level dimension |
| eventfk | the event dimension |
| classrecurrencefk | the class recurrence dimension |
| dimsegmentid | the segment dimension |
Enumerator Values
| Column | Values |
|---|---|
| commissiontype | 1 = Flat 2 = Percentage 3 = Tiered |
| classtype | 0 = Regular 1 = Workshop 2 = Training |
| waitinglisttype | 0 = No Waiting List 1 = First Come First Served 2 = Priority-based |
| statusfk | 0 = Active 1 = Inactive 2 = Cancelled |
| showincatalog | 0 = Hidden 1 = Visible in Catalog |
Was this article helpful?
Your feedback helps us improve our documentation.