Workshop dimension table
bi_dimworkshop
Field | Description | Field Type | Primary Key |
|---|---|---|---|
businessunitfk | bigint | ||
canbook | boolean | ||
capacity | integer | ||
categoryfk | bigint | ||
centerid | varchar ( 36 ) | ||
classfk | bigint | ||
classtype | integer | ||
dimsegmentid | bigint | ||
dimworkshopwid | bigint | ||
durationinmins | The duration of the workshop track in minutes. | integer | |
enablepayments | boolean | ||
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 | |
internalcost | numeric | ||
iscancelled | boolean | ||
isfreesession | boolean | ||
isopenforreg | boolean | ||
levelfk | bigint | ||
lock | boolean | ||
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
price | numeric | ||
statusfk | integer | ||
trackcode | The unique code of the workshop track for which the guest registered. | varchar ( 32 ) | |
trackenddt | The date and time on which the workshop track is scheduled to end. | timestamp without time zone | |
trackname | The name of the workshop track for which the guest registered. | varchar ( 128 ) | |
trackpk | bigint | ||
trackstartdt | The date and time on which the workshop track is scheduled to start. | timestamp without time zone | |
void | A flag indicating if the workshop track is inactive. A workshop track is considered inactive if it has been removed from the system. - True: Track is inactive. - False: Track is active. | boolean | |
waitinglisttype | integer | ||
workshopcode | The unique code of the workshop for which the guest registered. | varchar ( 32 ) | |
workshopdesc | varchar ( 65535 ) | ||
workshopname | The name of the workshop for which the guest registered. | varchar ( 128 ) | |
workshopvoid | A flag indicating if the workshop is inactive. A workshop is considered inactive if it has been removed from the system. - True: Workshop is inactive. - False: Workshop is active. | boolean | |
groupid | Internal to Zenoti. Used for data processing. | BIGINT |