FCT_SNTA_AML_CUSTOMER_INSIGHT
Description
Synonyms
SDSNZP02_BANK..SYN_SNT_FCT_SNTA_AML_CUSTOMER_INSIGHT
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | EFFECTIVE_START_TIMESTAMP | TIMESTAMP | 8 |
| 2 | EFFECTIVE_END_TIMESTAMP | TIMESTAMP | 8 |
| 3 | INSERT_OR_UPDATE | CHARACTER VARYING(1) | 1 |
| 4 | CUSTOMER_SOURCE_UNIQUE_ID | CHARACTER VARYING(13) | 13 |
| 5 | SOURCE_SYS_CODE | CHARACTER VARYING(3) | 3 |
| 6 | CUSTOMER_CIS_REF_ID | INTEGER | 4 |
| 7 | TITLE | CHARACTER VARYING(30) | 30 |
| 8 | FIRST_NAME | CHARACTER VARYING(30) | 30 |
| 9 | MIDDLE_NAME | CHARACTER VARYING(60) | 60 |
| 10 | LAST_NAME | CHARACTER VARYING(40) | 40 |
| 11 | SUFFIX | CHARACTER VARYING(30) | 30 |
| 12 | CUSTOMER_NAME | CHARACTER VARYING(1014) | 1014 |
| 13 | COMPANY_NAME | CHARACTER VARYING(1014) | 1014 |
| 14 | COMPANY_FORM | CHARACTER VARYING(1) | 1 |
| 15 | REGISTERED_NUMBER | CHARACTER VARYING(9) | 9 |
| 16 | INCORPORATION_DATE | CHARACTER VARYING(1) | 1 |
| 17 | BUSINESS_TYPE | CHARACTER VARYING(1) | 1 |
| 18 | BUSINESS_SEGMENT_1 | CHARACTER VARYING(1) | 1 |
| 19 | BUSINESS_SEGMENT_2 | CHARACTER VARYING(1) | 1 |
| 20 | INITIALS | CHARACTER VARYING(1) | 1 |
| 21 | DATE_OF_BIRTH | CHARACTER VARYING(200) | 200 |
| 22 | NAME_OF_BIRTH | CHARACTER VARYING(1) | 1 |
| 23 | ADDRESS_LINE_1 | CHARACTER VARYING(50) | 50 |
| 24 | ADDRESS_LINE_2 | CHARACTER VARYING(50) | 50 |
| 25 | ADDRESS_LINE_3 | CHARACTER VARYING(50) | 50 |
| 26 | ADDRESS_LINE_4 | CHARACTER VARYING(50) | 50 |
| 27 | ADDRESS_LINE_5 | CHARACTER VARYING(50) | 50 |
| 28 | ZONE | CHARACTER VARYING(40) | 40 |
| 29 | STATE | CHARACTER VARYING(30) | 30 |
| 30 | POSTAL_CODE | CHARACTER VARYING(10) | 10 |
| 31 | COUNTRY_OF_RESIDENCE | CHARACTER VARYING(2) | 2 |
| 32 | COUNTRY_OF_ORIGIN | CHARACTER VARYING(1) | 1 |
| 33 | NATIONALITY_CODE | CHARACTER VARYING(1) | 1 |
| 34 | PLACE_OF_BIRTH | CHARACTER VARYING(1) | 1 |
| 35 | GENDER_CODE | CHARACTER VARYING(1) | 1 |
| 36 | BRANCH_ID | CHARACTER VARYING(1) | 1 |
| 37 | RELATIONSHIP_MGR_ID | CHARACTER VARYING(1) | 1 |
| 38 | EMPLOYEE_FLAG | CHARACTER VARYING(1) | 1 |
| 39 | EMPLOYEE_NUMBER | CHARACTER VARYING(1) | 1 |
| 40 | MARITAL_STATUS | CHARACTER VARYING(1) | 1 |
| 41 | OCCUPATION | CHARACTER VARYING(256) | 256 |
| 42 | EMPLOYMENT_STATUS | CHARACTER VARYING(1) | 1 |
| 43 | ACQUISITION_DATE | CHARACTER VARYING(200) | 200 |
| 44 | CANCELLED_DATE | CHARACTER VARYING(1) | 1 |
| 45 | CUSTOMER_TYPE_CODE | CHARACTER VARYING(12) | 12 |
| 46 | CUSTOMER_STATUS_CODE | CHARACTER VARYING(1) | 1 |
| 47 | CUSTOMER_SEGMENT_1 | CHARACTER VARYING(1) | 1 |
| 48 | CUSTOMER_SEGMENT_2 | CHARACTER VARYING(1) | 1 |
| 49 | CUSTOMER_SEGMENT_3 | CHARACTER VARYING(1) | 1 |
| 50 | RESIDENCE_FLAG | CHARACTER VARYING(1) | 1 |
| 51 | SPECIAL_ATTENTION_FLAG | CHARACTER VARYING(1) | 1 |
| 52 | DECEASED_FLAG | CHARACTER VARYING(1) | 1 |
| 53 | DORMANT_STATUS_FLAG | CHARACTER VARYING(1) | 1 |
| 54 | LAST_UPDATED_TIMESTAMP | TIMESTAMP | 8 |
| 55 | RISK_SCORE | CHARACTER VARYING(1) | 1 |
| 56 | ARRESTED_FLAG | CHARACTER VARYING(1) | 1 |
| 57 | CHARGED_OFFENCE | CHARACTER VARYING(1) | 1 |
| 58 | DATE_CHARGED | CHARACTER VARYING(1) | 1 |
| 59 | LEGAL_OUTCOME | CHARACTER VARYING(1) | 1 |
| 60 | LEGAL_REP_FIRM | CHARACTER VARYING(1) | 1 |
| 61 | LEGAL_REP_NAME | CHARACTER VARYING(1) | 1 |
| 62 | LEGAL_REP_ADDRESS | CHARACTER VARYING(1) | 1 |
| 63 | BANKRUPT_FLAG | CHARACTER VARYING(1) | 1 |
| 64 | COMPENSATION_REQD_FLAG | CHARACTER VARYING(1) | 1 |
| 65 | CUSTOMER_COMPLAINT_FLAG | CHARACTER VARYING(1) | 1 |
| 66 | END_RELATIONSHIP_FLAG | CHARACTER VARYING(1) | 1 |
| 67 | MERCHANT_NUMBER | CHARACTER VARYING(1) | 1 |
| 68 | FACE_TO_FACE_FLAG | CHARACTER VARYING(1) | 1 |
| 69 | CHANNEL | CHARACTER VARYING(1) | 1 |
| 70 | AGE | CHARACTER VARYING(1) | 1 |
| 71 | NEAR_BORDER_FLAG | CHARACTER VARYING(1) | 1 |
| 72 | INTENDED_PRODUCT_USE | CHARACTER VARYING(1) | 1 |
| 73 | SOURCE_OF_FUNDS | CHARACTER VARYING(1) | 1 |
| 74 | COMPLEX_STRUCTURE | CHARACTER VARYING(1) | 1 |
| 75 | EXPECTED_ANNUAL_TURNOVER | CHARACTER VARYING(1) | 1 |
| 76 | TRADING_DURATION | CHARACTER VARYING(1) | 1 |
| 77 | BALANCE_SHEET_TOTAL | CHARACTER VARYING(1) | 1 |
| 78 | BROKER_CODE | CHARACTER VARYING(1) | 1 |
| 79 | VAT_NUMBER | CHARACTER VARYING(11) | 11 |
| 80 | BLACK_LISTED_FLAG | CHARACTER VARYING(1) | 1 |
| 81 | ORG_UNIT_CODE | CHARACTER VARYING(7) | 7 |
| 82 | DOMAIN_ID | CHARACTER VARYING(1) | 1 |
| 83 | TELEPHONE_NUMBER | CHARACTER VARYING(20) | 20 |
| 84 | COUNTRY_OF_CITIZENSHIP | CHARACTER VARYING(1) | 1 |
| 85 | COUNTRY_OF_INCORPORATION | CHARACTER VARYING(1) | 1 |
| 86 | EMAIL_ADDRESS | CHARACTER VARYING(100) | 100 |
| 87 | STAFF_CODE | CHARACTER VARYING(20) | 20 |
| 88 | STAFF_PACKAGE | CHARACTER VARYING(7) | 7 |
| 89 | MOBILE_NUMBER | CHARACTER VARYING(20) | 20 |
| 90 | WORK_NUMBER | CHARACTER VARYING(20) | 20 |