Session dimension table
bi_dimsession
Field | Description | Field Type | Primary Key |
|---|---|---|---|
allowdirectbooking | boolean | ||
allowsubstitution | boolean | ||
allowwaitlist | boolean | ||
assistantuserid | varchar ( 36 ) | ||
automaticconfirmationlockwindow | double precision | ||
businessunitfk | bigint | ||
canbook | boolean | ||
capacity | The overall capacity of the session. | integer | |
catalogname | varchar ( 128 ) | ||
catalogprice | varchar ( 32 ) | ||
categoryfk | bigint | ||
centerid | varchar ( 36 ) | ||
classcode | The name of the class corresponding to the session for which the guest registered. | varchar ( 32 ) | |
classdesc | varchar ( 65535 ) | ||
classfk | bigint | ||
classname | The name of the class corresponding to the session that the guest registered for. | varchar ( 128 ) | |
classrecurrencefk | bigint | ||
classtype | integer | ||
classvoid | A flag indicating whether the class is inactive. A class is considered inactive if it has been removed from the system. -True: Class is inactive. False: Class is active. | boolean | |
comissioneligible | boolean | ||
commissionfactor | double precision | ||
commissiontype | integer | ||
dimsegmentid | bigint | ||
dimsessionwid | A unique identifier for each session. This is generated in analytics, it does not exist in the core system. | bigint | |
durationinmins | The duration of the session in minutes. | integer | |
earlycancellationfee | numeric | ||
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 | |
eventfk | bigint | ||
flatcommissionvalue | double precision | ||
initialinstructorid | varchar ( 36 ) | ||
instructoruserid | A unique identifier for the session instructor. This is a non-blank value that gets populated for every instructor. | varchar ( 36 ) | |
instructorvirtuallink | varchar ( 65535 ) | ||
internalcost | numeric | ||
iscancelled | boolean | ||
isfreesession | boolean | ||
isinstructorsubstituted | boolean | ||
isopenforreg | boolean | ||
latecancellationfee | numeric | ||
levelfk | bigint | ||
lock | boolean | ||
minsafterregistrationforearlycancel | integer | ||
minsbeforeclassforearlycancel | integer | ||
minsbeforeclasswebbookingclose | integer | ||
noshowfee | numeric | ||
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
recoverytime | integer | ||
registrationlockwindow | double precision | ||
roomresourceid | varchar ( 36 ) | ||
sessioncode | The unique code of the session that the guest registered for. | varchar ( 32 ) | |
sessiondesc | varchar ( 65535 ) | ||
sessionenddt | The date and time on which the session is scheduled to end. | timestamp without time zone | |
sessionname | The unique code of the session for which the guest registered. | varchar ( 128 ) | |
sessionpk | bigint | ||
sessionstartdt | The date and time on which the session is scheduled to start. | timestamp without time zone | |
showincatalog | integer | ||
showprice | boolean | ||
statusfk | integer | ||
studentvirtuallink | varchar ( 65535 ) | ||
void | A flag indicating if the session is inactive. A session is considered inactive if it has been removed from the system. - True: Session is inactive. - False: Session is active. | boolean | |
waitinglisttype | integer | ||
waitlistlockwindow | integer | ||
webcapacity | integer | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |