SDW_TSDWR_CL
Description
Synonyms
SDSNZP02_BANK..ATOCRS_SDW_TSDWR_CL
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | CL_ID | BIGINT | 8 |
| 2 | CL_SCM_ID | BIGINT | 8 |
| 3 | SRC_STM_ID | BIGINT | 8 |
| 4 | ETL_CL_CODE | CHARACTER VARYING(24) | 24 |
| 5 | LOAD_ST_F | CHARACTER VARYING(1) | 1 |
| 6 | ISRT_RUN_AUDT_ID | BIGINT | 8 |
| 7 | UDT_RUN_AUDT_ID | BIGINT | 8 |
| 8 | CL_CODE | CHARACTER VARYING(24) | 24 |
| 9 | EFF_DT | TIMESTAMP | 8 |
| 10 | END_DT | TIMESTAMP | 8 |
| 11 | STD_CL_CODE | CHARACTER VARYING(6) | 6 |
| 12 | SHRT_NM | CHARACTER VARYING(256) | 256 |
| 13 | NM | CHARACTER VARYING(256) | 256 |
| 14 | DSC | CHARACTER VARYING(256) | 256 |
| 15 | HIER_PRN_NM | CHARACTER VARYING(256) | 256 |
| 16 | HIER_GPRN_NM | CHARACTER VARYING(256) | 256 |
| 17 | HIER_GGPRN_NM | CHARACTER VARYING(256) | 256 |
| 18 | HIER_LVL_4_NM | CHARACTER VARYING(256) | 256 |
| 19 | HIER_LVL_5_NM | CHARACTER VARYING(256) | 256 |
| 20 | HIER_LVL_6_NM | CHARACTER VARYING(256) | 256 |
| 21 | HIER_LVL_7_NM | CHARACTER VARYING(256) | 256 |
| 22 | HIER_LVL_8_NM | CHARACTER VARYING(256) | 256 |
| 23 | HIER_LVL_9_NM | CHARACTER VARYING(256) | 256 |
| 24 | ATTR_1_VAL | CHARACTER VARYING(64) | 64 |
| 25 | ATTR_2_VAL | CHARACTER VARYING(64) | 64 |
| 26 | ATTR_3_VAL | CHARACTER VARYING(64) | 64 |
| 27 | CL_ST_CODE | CHARACTER VARYING(12) | 12 |
| 28 | STD_SHRT_NM | CHARACTER VARYING(256) | 256 |
| 29 | STD_NM | CHARACTER VARYING(256) | 256 |
| 30 | STD_DSC | CHARACTER VARYING(256) | 256 |
| 31 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 32 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 33 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 34 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |