Date dimension table
Table Name | Column Name | Column Type | Primary Key |
|---|---|---|---|
Bi_DimDate_s3 | DateKey | INT | PK |
Bi_DimDate_s3 | Date | TIMESTAMP | |
Bi_DimDate_s3 | FullDateUK | CHAR(40) | |
Bi_DimDate_s3 | FullDateUSA | CHAR(40) | |
Bi_DimDate_s3 | DayOfMonth | VARCHAR(8) | |
Bi_DimDate_s3 | DaySuffix | VARCHAR(16) | |
Bi_DimDate_s3 | DayName | VARCHAR(36) | |
Bi_DimDate_s3 | DayOfWeekUSA | CHAR(4) | |
Bi_DimDate_s3 | DayOfWeekUK | CHAR(4) | |
Bi_DimDate_s3 | DayOfWeekInMonth | VARCHAR(8) | |
Bi_DimDate_s3 | DayOfWeekInYear | VARCHAR(8) | |
Bi_DimDate_s3 | DayOfQuarter | VARCHAR(12) | |
Bi_DimDate_s3 | DayOfYear | VARCHAR(12) | |
Bi_DimDate_s3 | WeekOfMonth | VARCHAR(4) | |
Bi_DimDate_s3 | WeekOfQuarter | VARCHAR(8) | |
Bi_DimDate_s3 | WeekOfYear | VARCHAR(8) | |
Bi_DimDate_s3 | Month | VARCHAR(8) | |
Bi_DimDate_s3 | MonthName | VARCHAR(36) | |
Bi_DimDate_s3 | MonthOfQuarter | VARCHAR(8) | |
Bi_DimDate_s3 | Quarter | CHAR(4) | |
Bi_DimDate_s3 | QuarterName | VARCHAR(36) | |
Bi_DimDate_s3 | Year | CHAR(16) | |
Bi_DimDate_s3 | YearName | CHAR(28) | |
Bi_DimDate_s3 | MonthYear | CHAR(40) | |
Bi_DimDate_s3 | MMYYYY | CHAR(24) | |
Bi_DimDate_s3 | FirstDayOfMonth | DATE | |
Bi_DimDate_s3 | LastDayOfMonth | DATE | |
Bi_DimDate_s3 | FirstDayOfQuarter | DATE | |
Bi_DimDate_s3 | LastDayOfQuarter | DATE | |
Bi_DimDate_s3 | FirstDayOfYear | DATE | |
Bi_DimDate_s3 | LastDayOfYear | DATE | |
Bi_DimDate_s3 | IsHolidayUSA | BOOLEAN | |
Bi_DimDate_s3 | IsWeekday | BOOLEAN | |
Bi_DimDate_s3 | HolidayUSA | VARCHAR(200) | |
Bi_DimDate_s3 | IsHolidayUK | BOOLEAN | |
Bi_DimDate_s3 | HolidayUK | VARCHAR(200) | |
Bi_DimDate_s3 | FiscalDayOfYear | VARCHAR(12) | |
Bi_DimDate_s3 | FiscalWeekOfYear | VARCHAR(12) | |
Bi_DimDate_s3 | FiscalMonth | VARCHAR(8) | |
Bi_DimDate_s3 | FiscalQuarter | CHAR(4) | |
Bi_DimDate_s3 | FiscalQuarterName | VARCHAR(36) | |
Bi_DimDate_s3 | FiscalYear | CHAR(16) | |
Bi_DimDate_s3 | FiscalYearName | CHAR(28) | |
Bi_DimDate_s3 | FiscalMonthYear | CHAR(40) | |
Bi_DimDate_s3 | FiscalMMYYYY | CHAR(24) | |
Bi_DimDate_s3 | FiscalFirstDayOfMonth | DATE | |
Bi_DimDate_s3 | FiscalLastDayOfMonth | DATE | |
Bi_DimDate_s3 | FiscalFirstDayOfQuarter | DATE | |
Bi_DimDate_s3 | FiscalLastDayOfQuarter | DATE | |
Bi_DimDate_s3 | FiscalFirstDayOfYear | DATE | |
Bi_DimDate_s3 | FiscalLastDayOfYear | DATE | |
Bi_DimDate_s3 | void | BOOLEAN | |
Bi_DimDate_s3 | EtlLastUpdatedOn | TIMESTAMP | |
Bi_DimDate_s3 | EtlLastUpdatedBy | NVARCHAR(50) | |
Bi_DimDate_s3 | PodName | VARCHAR(20) | |
Bi_DimDate_s3 | groupid | BIGINT |