Module: Common
Type: Dimension
CAL_DAY_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| CAL_DAY_ID | NUMBER | 38 | 0 | True | Day Key | ||
| SOURCE_RECORD_ID | NUMBER | 38 | 0 | Source Record Id | |||
| CALENDAR_DATE | DATE | 0 | Date | ||||
| DAY_OF_WEEK | NUMBER | 38 | 0 | Day in Week | |||
| DAY_OF_MONTH | NUMBER | 38 | 0 | Day in Month | |||
| DAY_OF_YEAR | NUMBER | 38 | 0 | Day in Year | |||
| DAY_AGO_DATE | DATE | 0 | Day Ago Date | ||||
| DAY_AGO_ID | NUMBER | 38 | 0 | Day Ago Id | |||
| DAY_CODE | VARCHAR2 | 16 | Day Code | ||||
| DAY_LOCALE_NAME | VARCHAR2 | 32 | Day Locale Name | ||||
| JULIAN_DAY_NUMBER | NUMBER | 38 | 0 | Julian Day Number | |||
| CAL_WEEK_ID | NUMBER | 38 | 0 | Week Key | |||
| CAL_MONTH_ID | NUMBER | 38 | 0 | Month Key | |||
| CAL_QUARTER_ID | NUMBER | 38 | 0 | Quarter Key | |||
| CAL_YEAR_ID | NUMBER | 38 | 0 | Year | |||
| CAL_MONTH_CODE | VARCHAR2 | 32 | Month Code | ||||
| CAL_QUARTER_CODE | VARCHAR2 | 32 | Quarter Code | ||||
| 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_MONTH_START_DATE | DATE | 0 | Month Start Date | ||||
| CAL_MONTH_END_DATE | DATE | 0 | Month End Date | ||||
| CAL_QUARTER_START_DATE | DATE | 0 | Quarter Start Date | ||||
| CAL_QUARTER_END_DATE | DATE | 0 | Quarter End Date | ||||
| CAL_YEAR_START_DATE | DATE | 0 | Year Start Date | ||||
| CAL_YEAR_END_DATE | DATE | 0 | Year End Date | ||||
| CAL_MONTH_NUMBER | NUMBER | 38 | 0 | Month in Year | |||
| CAL_HALF_NUMBER | NUMBER | 38 | 0 | Half Number | |||
| CAL_MONTH_LOCALE_NAME | VARCHAR2 | 32 | Month Locale Name | ||||
| CAL_QUARTER_NUMBER | NUMBER | 38 | 0 | Quarter in Year | |||
| CAL_TRIMESTER_NUMBER | NUMBER | 38 | 0 | Trimester Number | |||
| CAL_WEEK_NUMBER | NUMBER | 38 | 0 | Week in Year | |||
| CAL_MONTH_END_DATE_ID | NUMBER | 38 | 0 | Month End Date Id | |||
| CAL_MONTH_START_DATE_ID | NUMBER | 38 | 0 | Month Start Date Id | |||
| 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_QUARTER_START_DATE_ID | NUMBER | 38 | 0 | Quarter Start Date Id | |||
| CAL_QUARTER_END_DATE_ID | NUMBER | 38 | 0 | Quarter End 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_DAY_CAL_WEEK_FLAG | VARCHAR2 | 16 | First Day Week Flag | ||||
| LAST_DAY_CAL_WEEK_FLAG | VARCHAR2 | 16 | Last Day Week Flag | ||||
| FIRST_DAY_CAL_MONTH_FLAG | VARCHAR2 | 16 | First Day Month Flag | ||||
| LAST_DAY_CAL_MONTH_FLAG | VARCHAR2 | 16 | Last Day Month Flag | ||||
| FIRST_DAY_CAL_QTR_FLAG | VARCHAR2 | 16 | First Day Qtr Flag | ||||
| LAST_DAY_CAL_QTR_FLAG | VARCHAR2 | 16 | Last Day Qtr Flag | ||||
| FIRST_DAY_CAL_YEAR_FLAG | VARCHAR2 | 16 | First Day Year Flag | ||||
| LAST_DAY_CAL_YEAR_FLAG | VARCHAR2 | 16 | Last Day Year Flag | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |