ZenotiHelp

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.