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