Date
Module: Customer Insights
Type: Dimension
ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ID | NUMBER | 38 | 0 | True | Record Identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 38 | Source Record Id | ||||
| CALENDAR_DATE | DATE | 0 | Date | ||||
| CALENDAR_DAY | NUMBER | 38 | 0 | Calendar Day | |||
| CALENDAR_MONTH | NUMBER | 38 | 0 | Calendar Month | |||
| CALENDAR_QUARTER | NUMBER | 38 | 0 | Calendar Quarter | |||
| CALENDAR_YEAR | NUMBER | 38 | 0 | Calendar Year | |||
| DAYS_IN_MONTH | NUMBER | 38 | 0 | Days In Month | |||
| DAY_NAME | VARCHAR2 | 10 | Day Name | ||||
| DAY_OF_WEEK | NUMBER | 38 | 0 | Day in Week | |||
| DAY_OF_WEEK_ISO | NUMBER | 38 | 0 | Day Of Week Iso | |||
| DAY_OF_YEAR | NUMBER | 38 | 0 | Day in Year | |||
| FIRST_DAY_IN_MONTH | DATE | 0 | First Day In Month | ||||
| FIRST_DAY_IN_WEEK | DATE | 0 | First Day In Week | ||||
| FIRST_DAY_IN_WEEK_ISO | DATE | 0 | First Day In Week Iso | ||||
| IS_LEAP_YEAR | NUMBER | 38 | 0 | Is Leap Year | |||
| IS_WEEKDAY | NUMBER | 38 | 0 | Is Weekday | |||
| LAST_DAY_IN_MONTH | DATE | 0 | Last Day In Month | ||||
| LAST_DAY_IN_WEEK | DATE | 0 | Last Day In Week | ||||
| LAST_DAY_IN_WEEK_ISO | DATE | 0 | Last Day In Week Iso | ||||
| MONTH_NAME | VARCHAR2 | 10 | Month Name | ||||
| WEEK_OF_MONTH | NUMBER | 38 | 0 | Week Of Month | |||
| WEEK_OF_MONTH_ISO | NUMBER | 38 | 0 | Week Of Month Iso | |||
| WEEK_OF_YEAR | NUMBER | 38 | 0 | Week Of Year | |||
| WEEK_OF_YEAR_ISO | NUMBER | 38 | 0 | Week Of Year Iso | |||
| YEAR_MONTH | NUMBER | 38 | 0 | Month In Year | |||
| YEAR_MONTH_DAY | VARCHAR2 | 10 | Year Month Day | ||||
| YEAR_MONTH_NAME | VARCHAR2 | 9 | Year Month | ||||
| YEAR_QUARTER | NUMBER | 38 | 0 | ||||
| YEAR_QUARTER_NAME | VARCHAR2 | 7 | Year Quarter | ||||
| YEAR_WEEK | NUMBER | 38 | 0 | ||||
| YEAR_WEEK_NAME | VARCHAR2 | 7 | Year Week | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |