INT_REG_HIST_KYC_CUSTOMER

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..INT_REG_HIST_KYC_CUSTOMER_V

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