Module: Common
Type: Dimension
CAL_QUARTER_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| CAL_QUARTER_ID | NUMBER | 38 | 0 | True | Quarter Key | ||
| SOURCE_RECORD_ID | NUMBER | 38 | 0 | Source Record Id | |||
| CAL_YEAR_ID | NUMBER | 38 | 0 | Year | |||
| CAL_QUARTER_CODE | VARCHAR2 | 32 | Quarter Code | ||||
| CAL_YEAR_CODE | VARCHAR2 | 16 | Year Name | ||||
| 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_HALF_NUMBER | NUMBER | 38 | 0 | Half Number | |||
| CAL_QUARTER_NUMBER | NUMBER | 38 | 0 | Quarter in Year | |||
| 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_QUARTER_CAL_YEAR_FLAG | VARCHAR2 | 16 | First Quarter of Year | ||||
| LAST_QUARTER_CAL_YEAR_FLAG | VARCHAR2 | 16 | Last Quarter of Year | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |