DIM_CI_DATE_V
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | DATE_KEY | INTEGER | 4 |
| 2 | CAL_YEAR_CUST | INTEGER | 4 |
| 3 | CAL_YEAR_LABEL_CUST | CHARACTER VARYING(200) | 200 |
| 4 | EXCLUDED_FLAG | CHARACTER VARYING(1) | 1 |
| 5 | CAL_YEAR | INTEGER | 4 |
| 6 | CAL_YEAR_LABEL | CHARACTER VARYING(200) | 200 |
| 7 | CAL_QUARTER | INTEGER | 4 |
| 8 | CAL_QUARTER_LABEL | CHARACTER VARYING(402) | 402 |
| 9 | CAL_MONTH | INTEGER | 4 |
| 10 | CAL_MONTH_LABEL | CHARACTER VARYING(401) | 401 |
| 11 | CAL_DAY | INTEGER | 4 |
| 12 | CAL_DAY_LABEL | CHARACTER VARYING(200) | 200 |
| 13 | CALENDAR_DATE | DATE | 4 |
| 14 | CALENDAR_DATE_EOD | TIMESTAMP | 8 |
| 15 | EOW_SUN | CHARACTER VARYING(200) | 200 |
| 16 | EOW_FRI | CHARACTER VARYING(200) | 200 |
| 17 | EOM | CHARACTER VARYING(200) | 200 |
| 18 | EOY | CHARACTER VARYING(200) | 200 |
| 19 | DAY_TYPE_LABEL | CHARACTER VARYING(9) | 9 |
| 20 | DAY_TYPE_ID | INTEGER | 4 |
| 21 | WEEK_TYPE_LABEL | CHARACTER VARYING(9) | 9 |
| 22 | WEEK_TYPE_ID | INTEGER | 4 |
| 23 | MONTH_TYPE_LABEL | CHARACTER VARYING(10) | 10 |
| 24 | MONTH_TYPE_ID | INTEGER | 4 |
| 25 | QUARTER_TYPE_LABEL | CHARACTER VARYING(12) | 12 |
| 26 | QUARTER_TYPE_ID | INTEGER | 4 |
| 27 | CALENDAR_YEAR_TYPE_LABEL | CHARACTER VARYING(18) | 18 |
| 28 | CALENDAR_YEAR_TYPE_ID | INTEGER | 4 |
| 29 | CURRENT_FY | BIGINT | 8 |
| 30 | FINANCIAL_YEAR_TYPE_LABEL | CHARACTER VARYING(19) | 19 |
| 31 | FINANCIAL_YEAR_TYPE_ID | INTEGER | 4 |
| 32 | R12_MONTH_TYPE_LABEL | CHARACTER VARYING(17) | 17 |
| 33 | R12_MONTH_TYPE_ID | INTEGER | 4 |
| 34 | R13_MONTH_TYPE_LABEL | CHARACTER VARYING(17) | 17 |
| 35 | R13_MONTH_TYPE_ID | INTEGER | 4 |
| 36 | HALF_TYPE_LABEL | CHARACTER VARYING(14) | 14 |
| 37 | HALF_TYPE_ID | INTEGER | 4 |