Months
Module: Customer Insights
Type: Dimension
YEAR_MONTH
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| YEAR_MONTH | NUMBER | 38 | 0 | True | Month In Year | ||
| SOURCE_RECORD_ID | VARCHAR2 | 38 | Source Record Id | ||||
| 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 | |||
| FIRST_DAY_IN_MONTH | DATE | 0 | First Day In Month | ||||
| IS_LEAP_YEAR | NUMBER | 38 | 0 | Is Leap Year | |||
| LAST_DAY_IN_MONTH | DATE | 0 | Last Day In Month | ||||
| MONTH_NAME | VARCHAR2 | 10 | Month Name | ||||
| YEAR_MONTH_NAME | VARCHAR2 | 9 | Year Month | ||||
| YEAR_QUARTER | NUMBER | 38 | 0 | ||||
| YEAR_QUARTER_NAME | VARCHAR2 | 7 | Year Quarter | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |