ZenotiHelp

Workshop Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide

Dimension table storing workshop (track) details including scheduling, pricing, capacity, and classification attributes.

Columns

Column Name Data Type Nullable Description
dimworkshopwid BIGINT IDENTITY No Surrogate warehouse identifier (auto-generated)
trackpk BIGINT Yes Source system primary key for the track/workshop
classfk BIGINT Yes Foreign key to the parent training class
centerid VARCHAR(36) Yes Unique identifier of the center
trackname NVARCHAR(128) Yes Display name of the track
trackcode NVARCHAR(32) Yes Short code identifying the track
trackstartdt TIMESTAMP Yes Scheduled start date/time of the track
trackenddt TIMESTAMP Yes Scheduled end date/time of the track
internalcost NUMERIC(19,4) Yes Internal cost associated with the workshop
price NUMERIC(19,4) Yes Price of the workshop
iscancelled BOOLEAN Yes Indicates whether the workshop has been cancelled
void BOOLEAN Yes Soft-delete flag for the workshop record
isopenforreg BOOLEAN Yes Indicates if the workshop is open for registration
isfreesession BOOLEAN Yes Indicates if the workshop is free of charge
canbook BOOLEAN Yes Indicates if clients can book this workshop
lock BOOLEAN Yes Indicates if the workshop is locked from changes
capacity INT Yes Maximum capacity for the workshop
statusfk INT Yes Foreign key to the workshop status enumerator
workshopname NVARCHAR(128) Yes Name of the parent workshop definition
categoryfk BIGINT Yes Foreign key to the workshop category
workshopcode NVARCHAR(32) Yes Short code of the parent workshop definition
businessunitfk BIGINT Yes Foreign key to the business unit
durationinmins INT Yes Duration of the workshop in minutes
workshopdesc NVARCHAR(MAX) Yes Description of the parent workshop definition
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 workshop
classtype INT Yes Type/category of the class
dimsegmentid BIGINT Yes Foreign key to the segment dimension
workshopvoid BOOLEAN Yes Soft-delete flag for the parent workshop definition

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

dimworkshopwid

Foreign Keys

Column References
classfk the parent training class
categoryfk the workshop category dimension
businessunitfk the business unit dimension
levelfk the level dimension
dimsegmentid the segment dimension

Enumerator Values

Column Values
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
Was this article helpful?
Your feedback helps us improve our documentation.