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.