FCT_BANK_NROD_CONNECTED_PARTY_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..FCT_BANK_NROD_CONNECTED_PARTY

Columns
# Name Data Type Length
1 CONNECTED_PARTY_SRC_UNIQUE_ID CHARACTER VARYING(32) 32
2 CONNECTED_PARTY_SRC_REF_ID CHARACTER VARYING(100) 100
3 ORGUNIT_CODE CHARACTER VARYING(10) 10
4 PERSON_TITLE CHARACTER VARYING(50) 50
5 FIRST_NAME CHARACTER VARYING(150) 150
6 MIDDLE_NAME CHARACTER VARYING(700) 700
7 LAST_NAME CHARACTER VARYING(100) 100
8 SUFFIX CHARACTER VARYING(50) 50
9 CONNECTED_PARTY_NAME CHARACTER VARYING(1000) 1000
10 COMPANY_NAME CHARACTER VARYING(1000) 1000
11 COMPANY_FORM CHARACTER VARYING(20) 20
12 REGISTERED_NUMBER CHARACTER VARYING(30) 30
13 INCORPORATION_DATE CHARACTER VARYING(10) 10
14 INCORPORATION_COUNTRY_CODE CHARACTER VARYING(3) 3
15 BUSINESS_TYPE CHARACTER VARYING(100) 100
16 BUSINESS_SEGMENT_1 CHARACTER VARYING(60) 60
17 BUSINESS_SEGMENT_2 CHARACTER VARYING(60) 60
18 DATE_OF_BIRTH CHARACTER VARYING(200) 200
19 COUNTRY_OF_BIRTH CHARACTER VARYING(3) 3
20 ADDRESS CHARACTER VARYING(100) 100
21 ZONE CHARACTER VARYING(100) 100
22 CITY CHARACTER VARYING(100) 100
23 POSTAL_CODE CHARACTER VARYING(20) 20
24 COUNTRY_OF_RESIDENCE CHARACTER VARYING(3) 3
25 COUNTRY_OF_ORIGIN CHARACTER VARYING(3) 3
26 NATIONALITY_CODE CHARACTER VARYING(3) 3
27 PLACE_OF_BIRTH CHARACTER VARYING(50) 50
28 GENDER_CODE CHARACTER VARYING(10) 10
29 MARITAL_STATUS CHARACTER VARYING(10) 10
30 OCCUPATION CHARACTER VARYING(50) 50
31 PARTY_TYPE_CODE CHARACTER VARYING(20) 20
32 RESIDENCE_FLAG CHARACTER VARYING(1) 1
33 BANKRUPT_FLAG CHARACTER VARYING(1) 1
34 SOURCE_OF_FUNDS CHARACTER VARYING(20) 20
35 COMPLEX_STRUCTURE CHARACTER VARYING(1) 1
36 VAT_NUMBER CHARACTER VARYING(50) 50
37 BLACK_LISTED_FLAG_INGESTED CHARACTER VARYING(1) 1
38 SANCTIONED_FLAG_INGESTED CHARACTER VARYING(1) 1
39 PEP_FLAG_INGESTED CHARACTER VARYING(1) 1
40 PEP_TYPE_INGESTED CHARACTER VARYING(32) 32
41 PEP_RELATED_FLAG_INGESTED CHARACTER VARYING(1) 1
42 TAX_NUMBER CHARACTER VARYING(25) 25
43 TAX_NUMBER_ISSUED_BY CHARACTER VARYING(3) 3
44 PASSPORT_NUMBER CHARACTER VARYING(50) 50
45 PASSPORT_ISSUED_BY CHARACTER VARYING(3) 3
46 PASSPORT_VALID_FROM CHARACTER VARYING(16) 16
47 PASSPORT_VALID_TO CHARACTER VARYING(16) 16
48 OVERALL_SCORE_ADJUSTMENT CHARACTER VARYING(1) 1
49 COMMENTS CHARACTER VARYING(200) 200
50 CUSTOMER_SOURCE_UNIQUE_ID CHARACTER VARYING(32) 32
51 SOURCE_SYSTEM CHARACTER VARYING(30) 30
52 DELETED_FLAG CHARACTER VARYING(1) 1
53 PARTY_CATEGORY_CODE CHARACTER VARYING(20) 20
54 INITIALS CHARACTER VARYING(5) 5
55 NAME_OF_BIRTH CHARACTER VARYING(100) 100
56 EMPLOYMENT_STATUS CHARACTER VARYING(10) 10
57 GROSS_MONTHLY_INCOME CHARACTER VARYING(1) 1
58 NET_DISPOSABLE_MONTHLY_INCOME CHARACTER VARYING(1) 1
59 UNSECURED_DEBT CHARACTER VARYING(1) 1
60 TOTAL_DEBT CHARACTER VARYING(1) 1
61 EXISTING_ACCOUNT_SRC_UNIQUE_ID CHARACTER VARYING(32) 32
62 EXISTING_ACCOUNT_SRC_REF_ID CHARACTER VARYING(32) 32
63 EXISTING_BRANCH_ID CHARACTER VARYING(32) 32
64 ADDRESS_VALID_FROM CHARACTER VARYING(1) 1
65 ADDRESS_VALID_TO CHARACTER VARYING(1) 1
66 EMAIL CHARACTER VARYING(256) 256
67 EMAIL_VALID_FROM CHARACTER VARYING(1) 1
68 EMAIL_VALID_TO CHARACTER VARYING(1) 1
69 PHONE_COUNTRY_CODE CHARACTER VARYING(5) 5
70 PHONE_AREA_CODE CHARACTER VARYING(5) 5
71 PHONE_NUMBER CHARACTER VARYING(20) 20
72 PHONE_EXTENSION CHARACTER VARYING(20) 20
73 PHONE_VALID_FROM CHARACTER VARYING(1) 1
74 PHONE_VALID_TO CHARACTER VARYING(1) 1
75 ALTERNATE_NAME CHARACTER VARYING(100) 100
76 TAX_NUMBER_TYPE CHARACTER VARYING(100) 100
77 BUSINESS_CLASSIFICATION_CODE CHARACTER VARYING(32) 32
78 BUSINESS_CLASSIFICATION_SYSTEM CHARACTER VARYING(100) 100