Center working hours exceptions dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table | Mapped Dimension Table Column |
|---|---|---|---|---|---|
Bi_DimCenterWorkingHoursExceptions_s3 | ExceptionDatePK | DECIMAL(19 | PK | ||
Bi_DimCenterWorkingHoursExceptions_s3 | CenterID | VARCHAR(36) | |||
Bi_DimCenterWorkingHoursExceptions_s3 | ExceptionDate | TIMESTAMP | |||
Bi_DimCenterWorkingHoursExceptions_s3 | opentime | FLOAT | |||
Bi_DimCenterWorkingHoursExceptions_s3 | closetime | FLOAT | |||
Bi_DimCenterWorkingHoursExceptions_s3 | OnlineBookingStart | FLOAT | |||
Bi_DimCenterWorkingHoursExceptions_s3 | OnlineBookingEnd | FLOAT | |||
Bi_DimCenterWorkingHoursExceptions_s3 | PeakStart | FLOAT | |||
Bi_DimCenterWorkingHoursExceptions_s3 | PeakEnd | FLOAT | |||
Bi_DimCenterWorkingHoursExceptions_s3 | Void | BOOLEAN | |||
Bi_DimCenterWorkingHoursExceptions_s3 | CreatedDate | TIMESTAMP | |||
Bi_DimCenterWorkingHoursExceptions_s3 | EtlLastUpdatedOn | TIMESTAMP | |||
Bi_DimCenterWorkingHoursExceptions_s3 | EtlLastUpdatedBy | NVARCHAR(50) | |||
Bi_DimCenterWorkingHoursExceptions_s3 | PodName | VARCHAR(20) | |||
Bi_DimCenterWorkingHoursExceptions_s3 | organizationid | VARCHAR(36) | |||
Bi_DimCenterWorkingHoursExceptions_s3 | groupid | BIGINT |