Center holidays dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table | Mapped Dimension Table Column |
|---|---|---|---|---|---|
Bi_DimCenterHolidays_s3 | CenterHolidayId | VARCHAR(36) | PK | ||
Bi_DimCenterHolidays_s3 | centerid | VARCHAR(36) | |||
Bi_DimCenterHolidays_s3 | holiday | TIMESTAMP | |||
Bi_DimCenterHolidays_s3 | Holiday_Desc | NVARCHAR(800) | |||
Bi_DimCenterHolidays_s3 | recurring | BOOLEAN | |||
Bi_DimCenterHolidays_s3 | void | BOOLEAN | |||
Bi_DimCenterHolidays_s3 | EtlLastUpdatedOn | TIMESTAMP | |||
Bi_DimCenterHolidays_s3 | EtlLastUpdatedBy | NVARCHAR(50) | |||
Bi_DimCenterHolidays_s3 | PodName | VARCHAR(20) | |||
Bi_DimCenterHolidays_s3 | organizationID | VARCHAR(36) | |||
Bi_DimCenterHolidays_s3 | groupid | BIGINT |