CV19_CUSTOMER_RESPONSES_6M_BKP

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 GCIS_ID CHARACTER VARYING(9) 9
2 CUSTOMER_FIRSTNAME CHARACTER VARYING(50) 50
3 CUSTOMER_LASTNAME CHARACTER VARYING(50) 50
4 NUMBER_OF_BORROWERS INTEGER 4
5 NUMBER_OF_GUARANTORS INTEGER 4
6 NUMBER_OF_LOANS INTEGER 4
7 FURTHER_ASSISTANCE_REQUIRED CHARACTER VARYING(100) 100
8 ASSISTANCE_PREFERRED CHARACTER VARYING(100) 100
9 PAYG_EMPLOYEE CHARACTER VARYING(5) 5
10 MAIN_SOURCE_OF_INCOME CHARACTER VARYING(100) 100
11 PAYG_NORMALCY_PERIOD CHARACTER VARYING(100) 100
12 PAYG_COVID19_IMPACT CHARACTER VARYING(100) 100
13 HOUSEHOLD_ADULTS CHARACTER VARYING(100) 100
14 HOUSEHOLD_CHILDREN CHARACTER VARYING(100) 100
15 PERS_ASSET_OWNOCCPROP NUMERIC(20,2) 19
16 PERS_ASSET_INVESTPROP NUMERIC(20,2) 19
17 PERS_ASSET_VEHPLNTMACH NUMERIC(20,2) 19
18 PERS_ASSET_CASHBANKACCTS NUMERIC(20,2) 19
19 PERS_ASSET_INVSTMTSSHARES NUMERIC(20,2) 19
20 PERS_ASSET_INCPROTNLIFEINS NUMERIC(20,2) 19
21 PERS_ASSET_SUPER NUMERIC(20,2) 19
22 PERS_ASSET_FURNPERSEFFECTS NUMERIC(20,2) 19
23 PERS_ASSET_OTHER NUMERIC(20,2) 19
24 PERS_LIAB_SUNHOMELOANS NUMERIC(20,2) 19
25 PERS_LIAB_SUNINVSTMTLOANS NUMERIC(20,2) 19
26 PERS_LIAB_OTHHOMELOANS NUMERIC(20,2) 19
27 PERS_LIAB_BUSLOANS NUMERIC(20,2) 19
28 PERS_LIAB_UNSECPERSLOANSLEASES NUMERIC(20,2) 19
29 PERS_LIAB_CC_STORECARDS NUMERIC(20,2) 19
30 PERS_LIAB_INCOMETAXDEBTS NUMERIC(20,2) 19
31 PERS_LIAB_OTHER NUMERIC(20,2) 19
32 PERS_INCOME_SALARYWAGES NUMERIC(20,2) 19
33 PERS_INCOME_RENTAL NUMERIC(20,2) 19
34 PERS_INCOME_OTHER_INVSTMT NUMERIC(20,2) 19
35 PERS_INCOME_GOV NUMERIC(20,2) 19
36 PERS_EXP_HOMELOAN NUMERIC(20,2) 19
37 PERS_EXP_BUSINESSLOAN NUMERIC(20,2) 19
38 PERS_EXP_UNSECUREDPERSONALLEASES NUMERIC(20,2) 19
39 PERS_EXP_CC_STORECARD NUMERIC(20,2) 19
40 PERS_EXP_PAYLATER NUMERIC(20,2) 19
41 PERS_EXP_OTHERDEBTS NUMERIC(20,2) 19
42 PERS_EXP_RENT NUMERIC(20,2) 19
43 PERS_EXP_INSURANCE NUMERIC(20,2) 19
44 PERS_EXP_SCHOOL_CHILDCARE NUMERIC(20,2) 19
45 PERS_EXP_ELECTRICITY NUMERIC(20,2) 19
46 PERS_EXP_GAS NUMERIC(20,2) 19
47 PERS_EXP_TELEPHONE_INTERNET NUMERIC(20,2) 19
48 PERS_EXP_MEDICAL NUMERIC(20,2) 19
49 PERS_EXP_RATES NUMERIC(20,2) 19
50 PERS_EXP_CARTRAVEL NUMERIC(20,2) 19
51 PERS_EXP_FOOD NUMERIC(20,2) 19
52 PERS_EXP_CLOTHING NUMERIC(20,2) 19
53 PERS_EXP_ENTERTAINMENT NUMERIC(20,2) 19
54 PERS_EXP_PETS NUMERIC(20,2) 19
55 PERS_EXP_OTHER NUMERIC(20,2) 19
56 BUSINESS_INCOME CHARACTER VARYING(10) 10
57 BUS_REDUCTION CHARACTER VARYING(20) 20
58 BUS_RECOVER CHARACTER VARYING(5) 5
59 BUS_NORMALCY_PERIOD CHARACTER VARYING(100) 100
60 BUS_COVID19_IMPACT CHARACTER VARYING(250) 250
61 BUS_COVID19_ASSISTANCE CHARACTER VARYING(10) 10
62 BUS_ASSET_CASHBANKACCTS NUMERIC(20,2) 19
63 BUS_ASSET_INVENTORY NUMERIC(20,2) 19
64 BUS_ASSET_PREPAIDEXP NUMERIC(20,2) 19
65 BUS_ASSET_CURRENTOTHER NUMERIC(20,2) 19
66 BUS_ASSET_LEASEHOLDS NUMERIC(20,2) 19
67 BUS_ASSET_PROPLAND NUMERIC(20,2) 19
68 BUS_ASSET_FURNEQUIPTOOLS NUMERIC(20,2) 19
69 BUS_ASSET_VEHS NUMERIC(20,2) 19
70 BUS_ASSET_FIXEDOTHER NUMERIC(20,2) 19
71 BUS_LIAB_CCPAYABLE NUMERIC(20,2) 19
72 BUS_LIAB_ACCNTSPAYABLE NUMERIC(20,2) 19
73 BUS_LIAB_BUSLOANS NUMERIC(20,2) 19
74 BUS_LIAB_ACCRUEDWAGES NUMERIC(20,2) 19
75 BUS_LIAB_INCOMETAX NUMERIC(20,2) 19
76 BUS_LIAB_OTHER NUMERIC(20,2) 19
77 BUS_INCOME_TOTALREV NUMERIC(20,2) 19
78 BUS_INCOME_GOVASSIST NUMERIC(20,2) 19
79 BUS_INCOME_COSTOFGOODS NUMERIC(20,2) 19
80 BUS_INCOME_OTHER NUMERIC(20,2) 19
81 BUS_EXP_ACCTINGLEGAL NUMERIC(20,2) 19
82 BUS_EXP_ADVERTISING NUMERIC(20,2) 19
83 BUS_EXP_DEPRECIATION NUMERIC(20,2) 19
84 BUS_EXP_ELECTRICITY NUMERIC(20,2) 19
85 BUS_EXP_INSURANCE NUMERIC(20,2) 19
86 BUS_EXP_RENT NUMERIC(20,2) 19
87 BUS_EXP_REPAIRSMAINTCE NUMERIC(20,2) 19
88 BUS_EXPENSES_TRAINING NUMERIC(20,2) 19
89 BUS_EXP_WAGESSALARIES NUMERIC(20,2) 19
90 BUS_EXP_OTHER NUMERIC(20,2) 19
91 BUS_IMPACT_PL CHARACTER VARYING(250) 250
92 INDUSTRY CHARACTER VARYING(100) 100
93 OTHER_INFORMATION CHARACTER VARYING(250) 250
94 CUSTOMER_TCE NUMERIC(20,2) 19
95 SECURITY_VALUE NUMERIC(20,2) 19
96 SECURITY_ADDRESS CHARACTER VARYING(255) 255
97 LVR NUMERIC(10,2) 19
98 LMI CHARACTER VARYING(1) 1
99 LOAN_01 CHARACTER VARYING(40) 40
100 LOAN_01_ACCOUNT_TYPE CHARACTER VARYING(100) 100
101 LOAN_01_BALANCE NUMERIC(20,2) 19
102 LOAN_01_REPAYMENT_TYPE CHARACTER VARYING(5) 5
103 LOAN_01_MINIMUM_REPAYMENT_AMOUNT NUMERIC(20,2) 19
104 LOAN_01_REPAYMENT_DATE CHARACTER VARYING(10) 10
105 LOAN_01_ORIGINATION_DATE CHARACTER VARYING(10) 10
106 LOAN_01_DAYS_PAST_DUE NUMERIC(8,0) 19
107 LOAN_01_ADVANCE_POSITION NUMERIC(20,2) 19
108 LOAN_01_ARREARS_POSITION NUMERIC(20,2) 19
109 LOAN_01_OFFSET_BALANCE NUMERIC(20,2) 19
110 LOAN_02 CHARACTER VARYING(40) 40
111 LOAN_02_ACCOUNT_TYPE CHARACTER VARYING(100) 100
112 LOAN_02_BALANCE NUMERIC(20,2) 19
113 LOAN_02_REPAYMENT_TYPE CHARACTER VARYING(5) 5
114 LOAN_02_MINIMUM_REPAYMENT_AMOUNT NUMERIC(20,2) 19
115 LOAN_02_REPAYMENT_DATE CHARACTER VARYING(10) 10
116 LOAN_02_ORIGINATION_DATE CHARACTER VARYING(10) 10
117 LOAN_02_DAYS_PAST_DUE NUMERIC(8,0) 19
118 LOAN_02_ADVANCE_POSITION NUMERIC(20,2) 19
119 LOAN_02_ARREARS_POSITION NUMERIC(20,2) 19
120 LOAN_02_OFFSET_BALANCE NUMERIC(20,2) 19
121 LOAN_03 CHARACTER VARYING(40) 40
122 LOAN_03_ACCOUNT_TYPE CHARACTER VARYING(100) 100
123 LOAN_03_BALANCE NUMERIC(20,2) 19
124 LOAN_03_REPAYMENT_TYPE CHARACTER VARYING(5) 5
125 LOAN_03_MINIMUM_REPAYMENT_AMOUNT NUMERIC(20,2) 19
126 LOAN_03_REPAYMENT_DATE CHARACTER VARYING(10) 10
127 LOAN_03_ORIGINATION_DATE CHARACTER VARYING(10) 10
128 LOAN_03_DAYS_PAST_DUE INTEGER 4
129 LOAN_03_ADVANCE_POSITION NUMERIC(20,2) 19
130 LOAN_03_ARREARS_POSITION NUMERIC(20,2) 19
131 LOAN_03_OFFSET_BALANCE NUMERIC(20,2) 19
132 LOAN_04 CHARACTER VARYING(40) 40
133 LOAN_04_ACCOUNT_TYPE CHARACTER VARYING(100) 100
134 LOAN_04_BALANCE NUMERIC(20,2) 19
135 LOAN_04_REPAYMENT_TYPE CHARACTER VARYING(5) 5
136 LOAN_04_MINIMUM_REPAYMENT_AMOUNT NUMERIC(20,2) 19
137 LOAN_04_REPAYMENT_DATE CHARACTER VARYING(10) 10
138 LOAN_04_ORIGINATION_DATE CHARACTER VARYING(10) 10
139 LOAN_04_DAYS_PAST_DUE INTEGER 4
140 LOAN_04_ADVANCE_POSITION NUMERIC(20,2) 19
141 LOAN_04_ARREARS_POSITION NUMERIC(20,2) 19
142 LOAN_04_OFFSET_BALANCE NUMERIC(20,2) 19
143 LOAN_05 CHARACTER VARYING(40) 40
144 LOAN_05_ACCOUNT_TYPE CHARACTER VARYING(100) 100
145 LOAN_05_BALANCE NUMERIC(20,2) 19
146 LOAN_05_REPAYMENT_TYPE CHARACTER VARYING(5) 5
147 LOAN_05_MINIMUM_REPAYMENT_AMOUNT NUMERIC(20,2) 19
148 LOAN_05_REPAYMENT_DATE CHARACTER VARYING(10) 10
149 LOAN_05_ORIGINATION_DATE CHARACTER VARYING(10) 10
150 LOAN_05_DAYS_PAST_DUE INTEGER 4
151 LOAN_05_ADVANCE_POSITION NUMERIC(20,2) 19
152 LOAN_05_ARREARS_POSITION NUMERIC(20,2) 19
153 LOAN_05_OFFSET_BALANCE NUMERIC(20,2) 19
154 COLLECTION_CASE_ID_01 CHARACTER VARYING(10) 10
155 COLLECTION_CASE_ID_02 CHARACTER VARYING(10) 10
156 COLLECTION_CASE_ID_03 CHARACTER VARYING(10) 10
157 COLLECTION_CASE_ID_04 CHARACTER VARYING(10) 10
158 COLLECTION_CASE_ID_05 CHARACTER VARYING(10) 10
159 BORROWER_ADDRESS CHARACTER VARYING(400) 400
160 EMAIL CHARACTER VARYING(400) 400
161 MOBILE_PH CHARACTER VARYING(200) 200
162 LOAD_DATE CHARACTER VARYING(10) 10
163 FILE_DATE CHARACTER VARYING(10) 10
164 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
165 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
166 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
167 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8