DATE table
| Column name | Data type | Description |
|---|---|---|
| DATEID | SMALLINT | Primary key, a unique ID value for each row. Each row represents a day in the calendar year. |
| CALDATE | DATE | Calendar date, such as
2008-06-24.
|
| DAY | CHAR(3) | Day of week (short form), such as
SA.
|
| WEEK | SMALLINT | Week number, such as
26.
|
| MONTH | CHAR(5) | Month name (short form), such as
JUN.
|
| QTR | CHAR(5) | Quarter number (1
through
4).
|
| YEAR | SMALLINT | Four-digit year
(2008).
|
| HOLIDAY | BOOLEAN | Flag that denotes whether the day is a public holiday (U.S.). |