Skip to main content

Center timing dimension table

Table Name

Column Name

Column Type

Primary Key

Mapped Dimension Table

Mapped Dimension Table Column

Bi_DimCenterTiming_s3

CenterTimingPK

DECIMAL(19,0)

PK

Bi_DimCenterTiming_s3

CenterID

VARCHAR(36)

Bi_DimCenterTiming_s3

centerName

NVARCHAR(512)

Bi_DimCenterTiming_s3

DayOfWeek

VARCHAR(80)

Bi_DimCenterTiming_s3

CenterStartTime

FLOAT

Bi_DimCenterTiming_s3

CenterEndTime

FLOAT

Bi_DimCenterTiming_s3

OnlineBookingStartTime

FLOAT

Bi_DimCenterTiming_s3

OnlineBookingEndTime

FLOAT

Bi_DimCenterTiming_s3

cntrtimngPK

VARCHAR(50)

Bi_DimCenterTiming_s3

EtlLastUpdatedOn

TIMESTAMP

Bi_DimCenterTiming_s3

EtlLastUpdatedBy

NVARCHAR(50)

Bi_DimCenterTiming_s3

PodName

VARCHAR(20)

Bi_DimCenterTiming_s3

organizationid

VARCHAR(36)

Bi_DimCenterTiming_s3

groupid

BIGINT