| 1 |
DATE_KEY |
INTEGER |
4 |
| 2 |
RANK_DIFF |
BIGINT |
8 |
| 3 |
CAL_YEAR |
INTEGER |
4 |
| 4 |
CAL_YEAR_LABEL |
CHARACTER VARYING(13) |
13 |
| 5 |
CAL_QUARTER |
INTEGER |
4 |
| 6 |
CAL_QUARTER_LABEL |
CHARACTER VARYING(13) |
13 |
| 7 |
CAL_MONTH |
INTEGER |
4 |
| 8 |
CAL_MONTH_LABEL |
CHARACTER VARYING(13) |
13 |
| 9 |
CAL_DAY |
INTEGER |
4 |
| 10 |
CAL_DAY_LABEL |
CHARACTER VARYING(13) |
13 |
| 11 |
CAL_CURRENT_MONTH |
CHARACTER VARYING(20) |
20 |
| 12 |
CAL_LAST_MONTH |
CHARACTER VARYING(20) |
20 |
| 13 |
CAL_CURRENT_WEEK |
CHARACTER VARYING(20) |
20 |
| 14 |
CAL_LAST_WEEK |
CHARACTER VARYING(20) |
20 |
| 15 |
CAL_YTD |
CHARACTER VARYING(10) |
10 |
| 16 |
PRIOR_CAL_YTD |
CHARACTER VARYING(15) |
15 |
| 17 |
CAL_QTD |
CHARACTER VARYING(10) |
10 |
| 18 |
PRIOR_CAL_QTD |
CHARACTER VARYING(15) |
15 |
| 19 |
ACCOUNTING_CALENDAR_YEAR |
INTEGER |
4 |
| 20 |
ACCOUNTING_QTR |
INTEGER |
4 |
| 21 |
ACCOUNTING_YEAR |
INTEGER |
4 |
| 22 |
ACCOUNTING_YEAR_LABEL |
CHARACTER VARYING(13) |
13 |
| 23 |
ACCOUNTING_QUARTER |
INTEGER |
4 |
| 24 |
ACCOUNTING_QUARTER_LABEL |
CHARACTER VARYING(13) |
13 |
| 25 |
ACCOUNTING_MONTH_KEY |
INTEGER |
4 |
| 26 |
ACCOUNTING_FULL_MONTH_KEY |
DATE |
4 |
| 27 |
ACCOUNTING_MONTH_LABEL |
CHARACTER VARYING(13) |
13 |
| 28 |
ACCOUNTING_DAY |
INTEGER |
4 |
| 29 |
ACCOUNTING_DAY_LABEL |
CHARACTER VARYING(13) |
13 |
| 30 |
WEEK_ENDING |
CHARACTER VARYING(13) |
13 |
| 31 |
ACCOUNTING_CURRENT_MONTH |
CHARACTER VARYING(18) |
18 |
| 32 |
ACCOUNTING_CURRENT_MONTH_DAY_KEY |
INTEGER |
4 |
| 33 |
ACCOUNTING_LAST_MONTH |
CHARACTER VARYING(18) |
18 |
| 34 |
ACCOUNTING_CURRENT_MONTH_LAST_YEAR |
CHARACTER VARYING(30) |
30 |
| 35 |
ACCOUNTING_YTD |
CHARACTER VARYING(8) |
8 |
| 36 |
ACCOUNTING_YTD_MONTH_KEY |
INTEGER |
4 |
| 37 |
ACCOUNTING_PRIOR_YTD |
CHARACTER VARYING(15) |
15 |
| 38 |
ACCOUNTING_PRIOR_YTD_MONTH_KEY |
INTEGER |
4 |
| 39 |
PRIOR_YEAR_MONTH |
CHARACTER VARYING(20) |
20 |
| 40 |
ACCOUNTING_QTD |
CHARACTER VARYING(10) |
10 |
| 41 |
ACCOUNTING_QTD_MONTH_KEY |
INTEGER |
4 |
| 42 |
ACCOUNTING_PRIOR_QTD |
CHARACTER VARYING(15) |
15 |
| 43 |
ACCOUNTING_PRIOR_QTD_MONTH_KEY |
INTEGER |
4 |
| 44 |
ROLLING_26_WEEKS |
CHARACTER VARYING(25) |
25 |
| 45 |
ROLLING_13_WEEKS |
CHARACTER VARYING(25) |
25 |
| 46 |
CURRENT_WEEK |
CHARACTER VARYING(25) |
25 |
| 47 |
PRIOR_WEEK |
CHARACTER VARYING(25) |
25 |
| 48 |
ROLLING_1_YEAR |
CHARACTER VARYING(25) |
25 |
| 49 |
ROLLING_2_YEARS |
CHARACTER VARYING(25) |
25 |
| 50 |
ROLLING_3_YEARS |
CHARACTER VARYING(25) |
25 |
| 51 |
ROLLING_5_YEARS |
CHARACTER VARYING(25) |
25 |
| 52 |
ACCOUNTING_EOM_DAY |
INTEGER |
4 |
| 53 |
ACCOUNTING_EOQ_DAY |
INTEGER |
4 |
| 54 |
ACCOUNTING_CURRENT_QTR |
CHARACTER VARYING(15) |
15 |
| 55 |
ACCOUNTING_PRIOR_QTR |
CHARACTER VARYING(15) |
15 |
| 56 |
INCEPTION_DATE_CODE |
CHARACTER(4) |
4 |