Session dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table |
|---|---|---|---|---|
Bi_DimSession_s3 | DimSegmentID | DECIMAL(19,0) | ||
Bi_DimSession_s3 | sessionpk | DECIMAL(19,0) | PK | |
Bi_DimSession_s3 | classfk | DECIMAL(19,0) | ||
Bi_DimSession_s3 | organizationid | VARCHAR(36) | ||
Bi_DimSession_s3 | CenterID | VARCHAR(36) | ||
Bi_DimSession_s3 | sessionname | NVARCHAR(512) | ||
Bi_DimSession_s3 | sessioncode | NVARCHAR(128) | ||
Bi_DimSession_s3 | sessionstartdt | TIMESTAMP | ||
Bi_DimSession_s3 | sessionenddt | TIMESTAMP | ||
Bi_DimSession_s3 | internalcost | DECIMAL(19,4) | ||
Bi_DimSession_s3 | iscancelled | BOOLEAN | ||
Bi_DimSession_s3 | instructoruserid | VARCHAR(36) | ||
Bi_DimSession_s3 | assistantuserid | VARCHAR(36) | ||
Bi_DimSession_s3 | roomresourceid | VARCHAR(36) | ||
Bi_DimSession_s3 | catalogname | NVARCHAR(512) | ||
Bi_DimSession_s3 | showincatalog | INT | ||
Bi_DimSession_s3 | showprice | BOOLEAN | ||
Bi_DimSession_s3 | catalogprice | NVARCHAR(128) | ||
Bi_DimSession_s3 | void | BOOLEAN | ||
Bi_DimSession_s3 | capacity | INT | ||
Bi_DimSession_s3 | webcapacity | INT | ||
Bi_DimSession_s3 | isopenforreg | BOOLEAN | ||
Bi_DimSession_s3 | canbook | BOOLEAN | ||
Bi_DimSession_s3 | allowdirectbooking | BOOLEAN | ||
Bi_DimSession_s3 | minsbeforeclasswebbookingclose | INT | ||
Bi_DimSession_s3 | minsafterregistrationforearlycancel | INT | ||
Bi_DimSession_s3 | recoverytime | INT | ||
Bi_DimSession_s3 | comissioneligible | BOOLEAN | ||
Bi_DimSession_s3 | commissionfactor | FLOAT | ||
Bi_DimSession_s3 | commissiontype | INT | ||
Bi_DimSession_s3 | flatcommissionvalue | FLOAT | ||
Bi_DimSession_s3 | earlycancellationfee | DECIMAL(19,4) | ||
Bi_DimSession_s3 | latecancellationfee | DECIMAL(19,4) | ||
Bi_DimSession_s3 | noshowfee | DECIMAL(19,4) | ||
Bi_DimSession_s3 | allowwaitlist | BOOLEAN | ||
Bi_DimSession_s3 | allowsubstitution | BOOLEAN | ||
Bi_DimSession_s3 | lock | BOOLEAN | ||
Bi_DimSession_s3 | statusfk | INT | ||
Bi_DimSession_s3 | classrecurrencefk | DECIMAL(19,0) | ||
Bi_DimSession_s3 | waitlistlockwindow | INT | ||
Bi_DimSession_s3 | isfreesession | BOOLEAN | ||
Bi_DimSession_s3 | registrationlockwindow | FLOAT | ||
Bi_DimSession_s3 | automaticconfirmationlockwindow | FLOAT | ||
Bi_DimSession_s3 | eventfk | DECIMAL(19,0) | ||
Bi_DimSession_s3 | isinstructorsubstituted | BOOLEAN | ||
Bi_DimSession_s3 | instructorvirtuallink | NVARCHAR(65535) | ||
Bi_DimSession_s3 | studentvirtuallink | NVARCHAR(65535) | ||
Bi_DimSession_s3 | minsbeforeclassforearlycancel | INT | ||
Bi_DimSession_s3 | sessiondesc | NVARCHAR(65535) | ||
Bi_DimSession_s3 | classname | NVARCHAR(512) | ||
Bi_DimSession_s3 | categoryfk | DECIMAL(19,0) | ||
Bi_DimSession_s3 | classcode | NVARCHAR(128) | ||
Bi_DimSession_s3 | businessunitfk | DECIMAL(19,0) | ||
Bi_DimSession_s3 | durationinmins | INT | ||
Bi_DimSession_s3 | classdesc | NVARCHAR(65535) | ||
Bi_DimSession_s3 | waitinglisttype | INT | ||
Bi_DimSession_s3 | levelfk | DECIMAL(19,0) | ||
Bi_DimSession_s3 | enablepayments | BOOLEAN | ||
Bi_DimSession_s3 | classtype | INT | ||
Bi_DimSession_s3 | EtlLastUpdatedOn | TIMESTAMP | ||
Bi_DimSession_s3 | EtlLastUpdatedBy | NVARCHAR(50) | ||
Bi_DimSession_s3 | ClassVoid | BOOLEAN | ||
Bi_DimSession_s3 | InitialInstructorID | VARCHAR(36) | ||
Bi_DimSession_s3 | PodName | VARCHAR(20) | ||
Bi_DimSession_s3 | groupid | BIGINT |