Module: Common
Type: Dimension
CAL_WEEK_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| CAL_WEEK_ID | NUMBER | 38 | 0 | True | Week Key | ||
| SOURCE_RECORD_ID | NUMBER | 38 | 0 | Source Record Id | |||
| CAL_YEAR_ID | NUMBER | 38 | 0 | Year | |||
| CAL_WEEK_CODE | VARCHAR2 | 32 | Week Name | ||||
| CAL_YEAR_CODE | VARCHAR2 | 16 | Year Name | ||||
| CAL_WEEK_START_DATE | DATE | 0 | Week Start Date | ||||
| CAL_WEEK_END_DATE | DATE | 0 | Week End Date | ||||
| CAL_YEAR_START_DATE | DATE | 0 | Year Start Date | ||||
| CAL_YEAR_END_DATE | DATE | 0 | Year End Date | ||||
| CAL_WEEK_NUMBER | NUMBER | 38 | 0 | Week in Year | |||
| CAL_WEEK_END_DATE_ID | NUMBER | 38 | 0 | Week End Date Id | |||
| CAL_WEEK_START_DATE_ID | NUMBER | 38 | 0 | Week Start Date Id | |||
| CAL_YEAR_END_DATE_ID | NUMBER | 38 | 0 | Year End Date Id | |||
| CAL_YEAR_START_DATE_ID | NUMBER | 38 | 0 | Year Start Date Id | |||
| FIRST_WEEK_CAL_YEAR_FLAG | VARCHAR2 | 16 | First Week of Year | ||||
| LAST_WEEK_CAL_YEAR_FLAG | VARCHAR2 | 16 | Last Week of Year | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |