Workshop dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table |
|---|---|---|---|---|
Bi_DimWorkshop_s3 | DimSegmentID | DECIMAL(19,0) | ||
Bi_DimWorkshop_s3 | trackpk | DECIMAL(19,0) | PK | |
Bi_DimWorkshop_s3 | classfk | DECIMAL(19,0) | ||
Bi_DimWorkshop_s3 | organizationid | VARCHAR(36) | ||
Bi_DimWorkshop_s3 | centerid | VARCHAR(36) | ||
Bi_DimWorkshop_s3 | trackname | NVARCHAR(512) | ||
Bi_DimWorkshop_s3 | trackcode | NVARCHAR(128) | ||
Bi_DimWorkshop_s3 | trackstartdt | TIMESTAMP | ||
Bi_DimWorkshop_s3 | trackenddt | TIMESTAMP | ||
Bi_DimWorkshop_s3 | internalcost | DECIMAL(19,4) | ||
Bi_DimWorkshop_s3 | price | DECIMAL(19,4) | ||
Bi_DimWorkshop_s3 | iscancelled | BOOLEAN | ||
Bi_DimWorkshop_s3 | void | BOOLEAN | ||
Bi_DimWorkshop_s3 | isopenforreg | BOOLEAN | ||
Bi_DimWorkshop_s3 | isfreesession | BOOLEAN | ||
Bi_DimWorkshop_s3 | canbook | BOOLEAN | ||
Bi_DimWorkshop_s3 | lock | BOOLEAN | ||
Bi_DimWorkshop_s3 | capacity | INT | ||
Bi_DimWorkshop_s3 | statusfk | INT | ||
Bi_DimWorkshop_s3 | workshopname | NVARCHAR(512) | ||
Bi_DimWorkshop_s3 | categoryfk | DECIMAL(19,0) | ||
Bi_DimWorkshop_s3 | workshopcode | NVARCHAR(128) | ||
Bi_DimWorkshop_s3 | businessunitfk | DECIMAL(19,0) | ||
Bi_DimWorkshop_s3 | durationinmins | INT | ||
Bi_DimWorkshop_s3 | workshopdesc | NVARCHAR(65535) | ||
Bi_DimWorkshop_s3 | waitinglisttype | INT | ||
Bi_DimWorkshop_s3 | levelfk | DECIMAL(19,0) | ||
Bi_DimWorkshop_s3 | enablepayments | BOOLEAN | ||
Bi_DimWorkshop_s3 | classtype | INT | ||
Bi_DimWorkshop_s3 | EtlLastUpdatedOn | TIMESTAMP | ||
Bi_DimWorkshop_s3 | EtlLastUpdatedBy | NVARCHAR(50) | ||
Bi_DimWorkshop_s3 | WorkshopVoid | BOOLEAN | ||
Bi_DimWorkshop_s3 | PodName | VARCHAR(20) | ||
Bi_DimWorkshop_s3 | groupid | BIGINT |