INT_NROD_CONNECTED_KYC_CUSTOMER

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..INT_NROD_CONNECTED_KYC_CUSTOMER_V

Columns
# Name Data Type Length
1 CUSTOMER_ID BIGINT 8
2 HUB_CUSTOMER_ID BIGINT 8
3 KYC_STATUS CHARACTER VARYING(1) 1
4 CLASSIFICATION_ID BIGINT 8
5 PARTNERSHIP_FULL_NAME CHARACTER VARYING(200) 200
6 BUSINESS_NAME CHARACTER VARYING(120) 120
7 COUNTRY_ESTABLISHED CHARACTER VARYING(2) 2
8 ACTIVE_STATUS CHARACTER VARYING(10) 10
9 DOMESTIC_COMPANY_NAME CHARACTER VARYING(200) 200
10 DOMESTIC_COMPANY_TYPE CHARACTER VARYING(15) 15
11 FOREIGN_COMPANY_NAME CHARACTER VARYING(200) 200
12 FOREIGN_COMPANY_TYPE CHARACTER VARYING(15) 15
13 FOREIGN_COUNTRY_CODE CHARACTER VARYING(2) 2
14 FIRST_NAME CHARACTER VARYING(100) 100
15 MIDDLE_NAME CHARACTER VARYING(100) 100
16 LAST_NAME CHARACTER VARYING(100) 100
17 DOB TIMESTAMP 8
18 INC_ASSOC_NAME CHARACTER VARYING(200) 200
19 REG_COOPERATIVE_NAME CHARACTER VARYING(200) 200
20 TRUST_NAME CHARACTER VARYING(200) 200
21 TRUST_TYPE CHARACTER VARYING(5) 5
22 OTHER_TRUST_TYPE_DESC CHARACTER VARYING(100) 100
23 COUNTRY_CODE CHARACTER VARYING(2) 2
24 UNINC_ASSOC_NAME CHARACTER VARYING(200) 200
25 PREIND_CUSTOMER_NAME CHARACTER VARYING(1014) 1014
26 PREIND_DATE_OF_BIRTH TIMESTAMP 8
27 PREORG_CUSTOMER_NAME CHARACTER VARYING(1014) 1014
28 GOV_ENTITY_NAME CHARACTER VARYING(200) 200
29 SOLTRAD_BUSINESS_NAME CHARACTER VARYING(200) 200
30 RESIDENTIAL_ADDRESS_TYPE_CODE CHARACTER VARYING(5) 5
31 RESIDENTIAL_ADDRESS_LINE_1 CHARACTER VARYING(50) 50
32 RESIDENTIAL_ADDRESS_LINE_2 CHARACTER VARYING(50) 50
33 RESIDENTIAL_ADDRESS_LINE_3 CHARACTER VARYING(50) 50
34 RESIDENTIAL_CITY_TWN_SUBURB CHARACTER VARYING(50) 50
35 RESIDENTIAL_STATE CHARACTER VARYING(30) 30
36 RESIDENTIAL_POST_CODE CHARACTER VARYING(10) 10
37 RESIDENTIAL_COUNTRY CHARACTER VARYING(2) 2
38 RESIDENTIAL_RELATED_PARTY_ID BIGINT 8
39 MAIL_ADDRESS_TYPE_CODE CHARACTER VARYING(5) 5
40 MAIL_ADDRESS_LINE_1 CHARACTER VARYING(50) 50
41 MAIL_ADDRESS_LINE_2 CHARACTER VARYING(50) 50
42 MAIL_ADDRESS_LINE_3 CHARACTER VARYING(50) 50
43 MAIL_CITY_TWN_SUBURB CHARACTER VARYING(50) 50
44 MAIL_STATE CHARACTER VARYING(30) 30
45 MAIL_POST_CODE CHARACTER VARYING(10) 10
46 MAIL_COUNTRY CHARACTER VARYING(2) 2
47 MAIL_RELATED_PARTY_ID BIGINT 8
48 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
49 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
50 IS_CURRENT CHARACTER VARYING(1) 1