Module: Common
Type: Dimension
CAL_MONTH_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| CAL_MONTH_ID | NUMBER | 38 | 0 | True | Month Key | ||
| SOURCE_RECORD_ID | NUMBER | 38 | 0 | Source Record Id | |||
| 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_YEAR_CODE | VARCHAR2 | 16 | Year Name | ||||
| 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_MONTH_LOCALE_NAME | VARCHAR2 | 32 | Month Locale Name | ||||
| CAL_HALF_NUMBER | NUMBER | 38 | 0 | Half Number | |||
| CAL_QUARTER_NUMBER | NUMBER | 38 | 0 | Quarter in Year | |||
| CAL_TRIMESTER_NUMBER | NUMBER | 38 | 0 | Trimester Number | |||
| 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_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_MONTH_CAL_QTR_FLAG | VARCHAR2 | 16 | First Month of Quarter | ||||
| LAST_MONTH_CAL_QTR_FLAG | VARCHAR2 | 16 | Last Month of Quarter | ||||
| FIRST_MONTH_CAL_YEAR_FLAG | VARCHAR2 | 16 | First Month of Year | ||||
| LAST_MONTH_CAL_YEAR_FLAG | VARCHAR2 | 16 | Last Month of Year | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |