CRS_DIM_ATOCRS_HIST_CUSTOMER_INDICIA_PREV
Description
Synonyms
SDSNZP02_BANK..ATOCRS_CRS_DIM_ATOCRS_HIST_CUSTOMER_INDICIA_PREV
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | REC_TYPE | CHARACTER VARYING(4) | 4 |
| 2 | SOURCE_SYSTEM | CHARACTER VARYING(11) | 11 |
| 3 | DATA_SOURCE_APPLICATION | CHARACTER VARYING(14) | 14 |
| 4 | FOREIGN_INDICIA_RECORD_TYPE | CHARACTER VARYING(22) | 22 |
| 5 | FOREIGN_INDICIA_RECORD_SUB_TYPE | CHARACTER VARYING(272) | 272 |
| 6 | FOREIGN_INDICIA_DATA_SOURCE | CHARACTER VARYING(49) | 49 |
| 7 | GCIS_CUSTOMER_NUMBER | BIGINT | 8 |
| 8 | PRDT_SYS_CODE | CHARACTER VARYING(10) | 10 |
| 9 | PRDT_SYS_CUST_NUM | CHARACTER VARYING(50) | 50 |
| 10 | FOREIGN_INDICIA_COUNTRY_CODE | CHARACTER VARYING(255) | 255 |
| 11 | FOREIGN_INDICIA_COUNTRY | CHARACTER VARYING(255) | 255 |
| 12 | FOREIGN_INDICIA_START_TIMESTAMP | TIMESTAMP | 8 |
| 13 | FOREIGN_INDICIA_END_TIMESTAMP | TIMESTAMP | 8 |
| 14 | SRC_FIELD1 | CHARACTER VARYING(50) | 50 |
| 15 | SRC_FIELD2 | CHARACTER VARYING(120) | 120 |
| 16 | SRC_FIELD3 | CHARACTER VARYING(120) | 120 |
| 17 | SRC_FIELD4 | CHARACTER VARYING(120) | 120 |
| 18 | SRC_FIELD5 | CHARACTER VARYING(70) | 70 |
| 19 | SRC_FIELD6 | CHARACTER VARYING(50) | 50 |
| 20 | SRC_FIELD7 | CHARACTER VARYING(50) | 50 |
| 21 | SRC_FIELD8 | CHARACTER VARYING(30) | 30 |
| 22 | SRC_FIELD9 | CHARACTER VARYING(70) | 70 |
| 23 | SRC_FIELD10 | CHARACTER VARYING(100) | 100 |
| 24 | RECORD_START_TIMESTAMP | TIMESTAMP | 8 |
| 25 | RECORD_END_TIMESTAMP | TIMESTAMP | 8 |
| 26 | INDICIA_INFLOW_DATE | DATE | 4 |
| 27 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 28 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 29 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 30 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |