FCT_BANK_NROD_CUSTOMER_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..FCT_BANK_NROD_CUSTOMER

Columns
# Name Data Type Length
1 RUN_TIMESTAMP CHARACTER VARYING(200) 200
2 CUSTOMER_SOURCE_UNIQUE_ID CHARACTER VARYING(32) 32
3 ORGUNIT_CODE CHARACTER VARYING(10) 10
4 CUSTOMER_SOURCE_REF_ID CHARACTER VARYING(32) 32
5 PERSON_TITLE CHARACTER VARYING(50) 50
6 FIRST_NAME CHARACTER VARYING(150) 150
7 MIDDLE_NAMES CHARACTER VARYING(700) 700
8 LAST_NAME CHARACTER VARYING(100) 100
9 SUFFIX CHARACTER VARYING(50) 50
10 CUSTOMER_NAME CHARACTER VARYING(1000) 1000
11 COMPANY_NAME CHARACTER VARYING(1000) 1000
12 COMPANY_FORM CHARACTER VARYING(20) 20
13 REGISTERED_NUMBER CHARACTER VARYING(30) 30
14 INCORPORATION_DATE CHARACTER VARYING(1) 1
15 INCORPORATION_COUNTRY_CODE CHARACTER VARYING(3) 3
16 BUSINESS_TYPE CHARACTER VARYING(100) 100
17 BUSINESS_SEGMENT_1 CHARACTER VARYING(60) 60
18 BUSINESS_SEGMENT_2 CHARACTER VARYING(60) 60
19 INITIALS CHARACTER VARYING(5) 5
20 DATE_OF_BIRTH CHARACTER VARYING(200) 200
21 NAME_OF_BIRTH CHARACTER VARYING(100) 100
22 ADDRESS CHARACTER VARYING(400) 400
23 ZONE CHARACTER VARYING(100) 100
24 CITY CHARACTER VARYING(100) 100
25 POSTAL_CODE CHARACTER VARYING(20) 20
26 COUNTRY_OF_RESIDENCE CHARACTER VARYING(3) 3
27 COUNTRY_OF_ORIGIN CHARACTER VARYING(3) 3
28 NATIONALITY_CODE CHARACTER VARYING(3) 3
29 PLACE_OF_BIRTH CHARACTER VARYING(50) 50
30 GENDER_CODE CHARACTER VARYING(10) 10
31 PRIME_BRANCH_ID CHARACTER VARYING(32) 32
32 RELATIONSHIP_MGR_ID CHARACTER VARYING(32) 32
33 EMPLOYEE_FLAG CHARACTER VARYING(1) 1
34 EMPLOYEE_NUMBER CHARACTER VARYING(10) 10
35 MARITAL_STATUS CHARACTER VARYING(10) 10
36 OCCUPATION CHARACTER VARYING(50) 50
37 EMPLOYMENT_STATUS CHARACTER VARYING(10) 10
38 ACQUISITION_DATE CHARACTER VARYING(1) 1
39 CANCELLED_DATE CHARACTER VARYING(1) 1
40 CUSTOMER_TYPE_CODE CHARACTER VARYING(20) 20
41 CUSTOMER_STATUS_CODE CHARACTER VARYING(10) 10
42 CUSTOMER_SEGMENT_1 CHARACTER VARYING(50) 50
43 CUSTOMER_SEGMENT_2 CHARACTER VARYING(50) 50
44 CUSTOMER_SEGMENT_3 CHARACTER VARYING(50) 50
45 RESIDENCE_FLAG CHARACTER VARYING(1) 1
46 SPECIAL_ATTENTION_FLAG CHARACTER VARYING(1) 1
47 DECEASED_FLAG CHARACTER VARYING(1) 1
48 DORMANT_OVERRIDE_DATE CHARACTER VARYING(1) 1
49 RISK_SCORE CHARACTER VARYING(1) 1
50 BANKRUPT_FLAG CHARACTER VARYING(1) 1
51 COMPENSATION_REQD_FLAG CHARACTER VARYING(1) 1
52 CUSTOMER_COMPLAINT_FLAG CHARACTER VARYING(1) 1
53 END_RELATIONSHIP_FLAG CHARACTER VARYING(1) 1
54 MERCHANT_NUMBER CHARACTER VARYING(20) 20
55 FACE_TO_FACE_FLAG CHARACTER VARYING(1) 1
56 CHANNEL CHARACTER VARYING(10) 10
57 AGE CHARACTER VARYING(1) 1
58 NEAR_BORDER_FLAG CHARACTER VARYING(1) 1
59 INTENDED_PRODUCT_USE CHARACTER VARYING(3) 3
60 SOURCE_OF_FUNDS CHARACTER VARYING(3) 3
61 COMPLEX_STRUCTURE CHARACTER VARYING(1) 1
62 EXPECTED_ANNUAL_TURNOVER CHARACTER VARYING(1) 1
63 TRADING_DURATION CHARACTER VARYING(1) 1
64 BALANCE_SHEET_TOTAL CHARACTER VARYING(1) 1
65 VAT_NUMBER CHARACTER VARYING(50) 50
66 BROKER_CODE CHARACTER VARYING(50) 50
67 BLACK_LISTED_FLAG CHARACTER VARYING(1) 1
68 DOMAIN_CODE CHARACTER VARYING(50) 50
69 COMMENTS CHARACTER VARYING(4000) 4000
70 PEP_FLAG_INGESTED CHARACTER VARYING(1) 1
71 WIRE_IN_NUMBER CHARACTER VARYING(1) 1
72 WIRE_OUT_NUMBER CHARACTER VARYING(1) 1
73 WIRE_IN_VOLUME CHARACTER VARYING(1) 1
74 WIRE_OUT_VOLUME CHARACTER VARYING(1) 1
75 CASH_IN_VOLUME CHARACTER VARYING(1) 1
76 CASH_OUT_VOLUME CHARACTER VARYING(1) 1
77 CHECK_IN_VOLUME CHARACTER VARYING(1) 1
78 CHECK_OUT_VOLUME CHARACTER VARYING(1) 1
79 OVERALL_SCORE_ADJUSTMENT CHARACTER VARYING(1) 1
80 TAX_NUMBER CHARACTER VARYING(25) 25
81 TAX_NUMBER_ISSUED_BY CHARACTER VARYING(3) 3
82 CUSTOMER_CATEGORY_CODE CHARACTER VARYING(20) 20
83 OWN_AFFILIATE_FLAG CHARACTER VARYING(1) 1
84 MARKETING_SERVICE_LEVEL CHARACTER VARYING(255) 255
85 SANCTIONED_FLAG_INGESTED CHARACTER VARYING(1) 1
86 PEP_TYPE_INGESTED CHARACTER VARYING(30) 30
87 PEP_RELATED_FLAG_INGESTED CHARACTER VARYING(1) 1
88 ADDRESS_VALID_FROM CHARACTER VARYING(1) 1
89 ADDRESS_VALID_TO CHARACTER VARYING(1) 1
90 EMAIL CHARACTER VARYING(256) 256
91 EMAIL_VALID_FROM CHARACTER VARYING(1) 1
92 EMAIL_VALID_TO CHARACTER VARYING(1) 1
93 PHONE_COUNTRY_CODE CHARACTER VARYING(5) 5
94 PHONE_AREA_CODE CHARACTER VARYING(5) 5
95 PHONE_NUMBER CHARACTER VARYING(20) 20
96 PHONE_EXTENSION CHARACTER VARYING(6) 6
97 PHONE_VALID_FROM CHARACTER VARYING(1) 1
98 PHONE_VALID_TO CHARACTER VARYING(1) 1
99 ALTERNATE_NAME CHARACTER VARYING(1000) 1000
100 TAX_NUMBER_TYPE CHARACTER VARYING(100) 100
101 BUSINESS_CLASSIFICATION_CODE CHARACTER VARYING(32) 32
102 BUSINESS_CLASSIFICATION_SYSTEM CHARACTER VARYING(100) 100