DIM_SDW_TSDMD_OF_ALL_TIME_INSIGHT
Description
Source Object (CTAS)
Synonyms
INSNZP01_BANK..SYN_DIM_SDW_TSDMD_OF_ALL_TIME_INSIGHT
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ALL_TIME_SID | BIGINT | 8 |
| 2 | ALL_TIME_DIM_ID | CHARACTER VARYING(256) | 256 |
| 3 | GREGORIAN_CALENDAR_DATE | TIMESTAMP | 8 |
| 4 | GREGORIAN_CALENDAR_YEAR | NUMERIC(38,0) | 19 |
| 5 | GREGORIAN_CALENDAR_QUARTER | NUMERIC(38,0) | 19 |
| 6 | GREGORIAN_CALENDAR_MONTH | NUMERIC(38,0) | 19 |
| 7 | GREGORIAN_CALENDAR_WEEK | NUMERIC(38,0) | 19 |
| 8 | GREGORIAN_CALENDAR_DAY | NUMERIC(38,0) | 19 |
| 9 | GREGORIAN_WEEKDAY | CHARACTER VARYING(256) | 256 |
| 10 | GREGORIAN_MONTH_NAME | CHARACTER VARYING(256) | 256 |
| 11 | GREGORIAN_VARIANT_CODE | CHARACTER VARYING(256) | 256 |
| 12 | CALENDAR_VARIANT_CODE | CHARACTER VARYING(256) | 256 |
| 13 | CALENDAR_YEAR_VALUE | NUMERIC(38,0) | 19 |
| 14 | CALENDAR_PERIOD_NUMBER | NUMERIC(38,0) | 19 |
| 15 | CALENDAR_START_DATE | TIMESTAMP | 8 |
| 16 | CALENDAR_END_DATE | TIMESTAMP | 8 |
| 17 | CALENDAR_QUARTER_VALUE | NUMERIC(38,0) | 19 |
| 18 | CALENDAR_WEEK_VALUE | NUMERIC(38,0) | 19 |
| 19 | CALENDAR_PERIOD_COUNT | NUMERIC(38,0) | 19 |
| 20 | CALENDAR_VARIANT_NAME | CHARACTER VARYING(256) | 256 |
| 21 | CALENDAR_YEAR_END_PERIOD_IND | NUMERIC(38,0) | 19 |
| 22 | CALENDAR_TYPE_NAME | CHARACTER VARYING(256) | 256 |
| 23 | CALENDAR_GRAIN_LEVEL | CHARACTER VARYING(256) | 256 |
| 24 | GREGORIAN_YEAR_START_DATE | TIMESTAMP | 8 |
| 25 | GREGORIAN_YEAR_END_DATE | TIMESTAMP | 8 |
| 26 | GREGORIAN_QUARTER_START_DATE | TIMESTAMP | 8 |
| 27 | GREGORIAN_QUARTER_END_DATE | TIMESTAMP | 8 |
| 28 | GREGORIAN_MONTH_START_DATE | TIMESTAMP | 8 |
| 29 | GREGORIAN_MONTH_END_DATE | TIMESTAMP | 8 |
| 30 | CALENDAR_YEAR_START_DATE | TIMESTAMP | 8 |
| 31 | CALENDAR_YEAR_END_DATE | TIMESTAMP | 8 |
| 32 | CALENDAR_QUARTER_START_DATE | TIMESTAMP | 8 |
| 33 | CALENDAR_QUARTER_END_DATE | TIMESTAMP | 8 |
| 34 | CALENDAR_PERIOD_START_DATE | TIMESTAMP | 8 |
| 35 | CALENDAR_PERIOD_END_DATE | TIMESTAMP | 8 |
| 36 | CALENDAR_YEAR_ORDINAL | NUMERIC(38,0) | 19 |
| 37 | CALENDAR_QUARTER_ORDINAL | NUMERIC(38,0) | 19 |
| 38 | CALENDAR_PERIOD_ORDINAL | NUMERIC(38,0) | 19 |
| 39 | GREGORIAN_YEAR_CAPTION | CHARACTER VARYING(20) | 20 |
| 40 | GREGORIAN_QUARTER_CAPTION | CHARACTER VARYING(20) | 20 |
| 41 | GREGORIAN_MONTH_CAPTION | CHARACTER VARYING(20) | 20 |
| 42 | GREGORIAN_DAY_CAPTION | CHARACTER VARYING(20) | 20 |
| 43 | CALENDAR_YEAR_CAPTION | CHARACTER VARYING(20) | 20 |
| 44 | CALENDAR_PERIOD_CAPTION | CHARACTER VARYING(20) | 20 |
| 45 | CALENDAR_QUARTER_CAPTION | CHARACTER VARYING(20) | 20 |
| 46 | CREATED_DATE | TIMESTAMP | 8 |
| 47 | CHANGED_DATE | TIMESTAMP | 8 |
| 48 | BUSINESS_LOAD_DATE | TIMESTAMP | 8 |
| 49 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 50 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 51 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 52 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |