FCT_BANK_CV19_FOLLOWUP_6M_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 GCIS_ID CHARACTER VARYING(9) 9
2 BRAND CHARACTER VARYING(3) 3
3 OCID CHARACTER VARYING(70) 70
4 EMAIL CHARACTER VARYING(400) 400
5 MOBILE_PH CHARACTER VARYING(200) 200
6 CUST_NUM INTEGER 4
7 CUST_FIRST_NAME CHARACTER VARYING(50) 50
8 CUST_LAST_NAME CHARACTER VARYING(50) 50
9 LOAN_ACCT_1 CHARACTER VARYING(3) 3
10 ASSISTANCE_END_DATE_1 CHARACTER VARYING(10) 10
11 LOAN_01_REPAYMENT_DATE CHARACTER VARYING(10) 10
12 HARDSHIP_CASE_1 CHARACTER VARYING(10) 10
13 LOAN_ACCT_2 CHARACTER VARYING(3) 3
14 ASSISTANCE_END_DATE_2 CHARACTER VARYING(10) 10
15 LOAN_02_REPAYMENT_DATE CHARACTER VARYING(10) 10
16 HARDSHIP_CASE_2 CHARACTER VARYING(10) 10
17 LOAN_ACCT_3 CHARACTER VARYING(3) 3
18 ASSISTANCE_END_DATE_3 CHARACTER VARYING(10) 10
19 LOAN_03_REPAYMENT_DATE CHARACTER VARYING(10) 10
20 HARDSHIP_CASE_3 CHARACTER VARYING(10) 10
21 LOAN_ACCT_4 CHARACTER VARYING(3) 3
22 ASSISTANCE_END_DATE_4 CHARACTER VARYING(10) 10
23 LOAN_04_REPAYMENT_DATE CHARACTER VARYING(10) 10
24 HARDSHIP_CASE_4 CHARACTER VARYING(10) 10
25 LOAN_ACCT_5 CHARACTER VARYING(3) 3
26 ASSISTANCE_END_DATE_5 CHARACTER VARYING(10) 10
27 LOAN_05_REPAYMENT_DATE CHARACTER VARYING(10) 10
28 HARDSHIP_CASE_5 CHARACTER VARYING(10) 10
29 LOAN_1 CHARACTER VARYING(40) 40
30 LOAN_2 CHARACTER VARYING(40) 40
31 LOAN_3 CHARACTER VARYING(40) 40
32 LOAN_4 CHARACTER VARYING(40) 40
33 LOAN_5 CHARACTER VARYING(40) 40
34 RESPOND_BY_DATE CHARACTER VARYING(10) 10
35 ORIGINAL_CONTACT_DATE CHARACTER VARYING(10) 10
36 FOLLOW_UP_DATE CHARACTER VARYING(10) 10
37 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
38 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
39 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
40 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8