Date dimension table
bi_dimdate
Field | Description | Field Type | Primary Key |
|---|---|---|---|
date | timestamp without time zone | ||
datekey | integer | ||
datewid | bigint | ||
dayname | varchar ( 36 ) | ||
dayofmonth | varchar ( 8 ) | ||
dayofquarter | varchar ( 12 ) | ||
dayofweekinmonth | varchar ( 8 ) | ||
dayofweekinyear | varchar ( 8 ) | ||
dayofweekuk | character | ||
dayofweekusa | character | ||
dayofyear | varchar ( 12 ) | ||
daysuffix | varchar ( 16 ) | ||
etllastupdatedby | ETL system admin user who inserted or updated the corresponding record in this table. | varchar ( 50 ) | |
etllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in this table. | timestamp without time zone | |
firstdayofmonth | date | ||
firstdayofquarter | date | ||
firstdayofyear | date | ||
fiscaldayofyear | varchar ( 12 ) | ||
fiscalfirstdayofmonth | date | ||
fiscalfirstdayofquarter | date | ||
fiscalfirstdayofyear | date | ||
fiscallastdayofmonth | date | ||
fiscallastdayofquarter | date | ||
fiscallastdayofyear | date | ||
fiscalmmyyyy | character | ||
fiscalmonth | varchar ( 8 ) | ||
fiscalmonthyear | character | ||
fiscalquarter | character | ||
fiscalquartername | varchar ( 36 ) | ||
fiscalweekofyear | varchar ( 12 ) | ||
fiscalyear | character | ||
fiscalyearname | character | ||
fulldateuk | character | ||
fulldateusa | character | ||
holidayuk | varchar ( 200 ) | ||
holidayusa | varchar ( 200 ) | ||
isholidayuk | boolean | ||
isholidayusa | boolean | ||
isweekday | boolean | ||
lastdayofmonth | date | ||
lastdayofquarter | date | ||
lastdayofyear | date | ||
mmyyyy | character | ||
month | varchar ( 8 ) | ||
monthname | varchar ( 36 ) | ||
monthofquarter | varchar ( 8 ) | ||
monthyear | character | ||
podname | varchar ( 20 ) | ||
quarter | character | ||
quartername | varchar ( 36 ) | ||
void | boolean | ||
weekofmonth | varchar ( 4 ) | ||
weekofquarter | varchar ( 8 ) | ||
weekofyear | varchar ( 8 ) | ||
year | character | ||
yearname | character | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |