Week
Module: Customer Insights
Type: Dimension
YEAR_WEEK
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| YEAR_WEEK | NUMBER | 38 | 0 | True | |||
| SOURCE_RECORD_ID | VARCHAR2 | 38 | Source Record Id | ||||
| FIRST_DAY_IN_WEEK | DATE | 0 | First Day In Week | ||||
| FIRST_DAY_IN_WEEK_ISO | DATE | 0 | First Day In Week Iso | ||||
| LAST_DAY_IN_WEEK | DATE | 0 | Last Day In Week | ||||
| LAST_DAY_IN_WEEK_ISO | DATE | 0 | Last Day In Week Iso | ||||
| 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_WEEK_NAME | VARCHAR2 | 7 | Year Week | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |