CRS_DIM_ATOCRS_CRS_INDV_DD_MAILOUT_PREV
Description
Synonyms
SDSNZP02_BANK..ATOCRS_CRS_DIM_ATOCRS_CRS_INDV_DD_MAILOUT_PREV
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | RUN_DATE_TIME | CHARACTER VARYING(200) | 200 |
| 2 | GCIS_CUSTOMER_NUMBER | INTEGER | 4 |
| 3 | CUSTOMER_TYPE | CHARACTER VARYING(20) | 20 |
| 4 | CUSTOMER_NAME_GENERIC | CHARACTER VARYING(1387) | 1387 |
| 5 | ADDRESS_LINE_1 | CHARACTER VARYING(122) | 122 |
| 6 | ADDRESS_LINE_2 | CHARACTER VARYING(122) | 122 |
| 7 | ADDRESS_LINE_3 | CHARACTER VARYING(122) | 122 |
| 8 | ADDRESS_CITY | CHARACTER VARYING(72) | 72 |
| 9 | ADDRESS_STATE | CHARACTER VARYING(72) | 72 |
| 10 | ADDRESS_POST_CODE | CHARACTER VARYING(32) | 32 |
| 11 | ADDRESS_COUNTRY | CHARACTER VARYING(26) | 26 |
| 12 | RELATIONSHIP_MANAGER_ID | CHARACTER VARYING(40) | 40 |
| 13 | RELATIONSHIP_MANAGER_NAME | CHARACTER VARYING(255) | 255 |
| 14 | RELATIONSHIP_MANAGER_SOURCE | CHARACTER VARYING(4) | 4 |
| 15 | INDV_TITLE | CHARACTER VARYING(120) | 120 |
| 16 | INDV_FIRST_NAME | CHARACTER VARYING(1014) | 1014 |
| 17 | INDV_MIDDLE_NAME_INITIAL | CHARACTER VARYING(101) | 101 |
| 18 | INDV_LAST_NAME | CHARACTER VARYING(100) | 100 |
| 19 | INDV_SUFFIX | CHARACTER VARYING(50) | 50 |
| 20 | ENTITY_NAME | CHARACTER VARYING(1) | 1 |
| 21 | GCIS_PROFILE_STATUS | CHARACTER VARYING(8) | 8 |
| 22 | DECEASED_IND | CHARACTER VARYING(3) | 3 |
| 23 | CHK_SUNCORP_ENTITY_FLAG | CHARACTER VARYING(1) | 1 |
| 24 | FOREIGN_INDICIA_FLAG | CHARACTER VARYING(1) | 1 |
| 25 | FOREIGN_INDICIA_COUNTRY_CODE | CHARACTER VARYING(255) | 255 |
| 26 | CUSTOMER_THROUGH_FOREIGN_RELATION | CHARACTER VARYING(1) | 1 |
| 27 | AML_BOCP_FOREIGN_INDICIA_FLAG | CHARACTER VARYING(1) | 1 |
| 28 | DERIVED_CRS_ENTITY_TYPE | CHARACTER VARYING(1) | 1 |
| 29 | DERIVED_FATCA_ENTITY_TYPE | CHARACTER VARYING(1) | 1 |
| 30 | DERIVED_FFI_TYPE | CHARACTER VARYING(1) | 1 |
| 31 | CURRENT_GIIN | CHARACTER VARYING(1) | 1 |
| 32 | EMAIL_ADDRESS | CHARACTER VARYING(120) | 120 |
| 33 | MOBILE_NUMBER | CHARACTER VARYING(45) | 45 |
| 34 | CUSTOMER_IDENTIFIER | CHARACTER VARYING(404) | 404 |
| 35 | REPLY_PAID_ENVELOPE | CHARACTER VARYING(50) | 50 |
| 36 | DATA_DATE | TIMESTAMP | 8 |
| 37 | LOAD_ID | INTEGER | 4 |
| 38 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 39 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 40 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 41 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |