FCT_BNK_ROFT_DRAFT_AND_COMPLETE_SUBMISSION_LN_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

OBP table showing the latest record for Sub, fac, app, acc combination for originating loans. Table also holds DRAFT submissions prior to details being completed

Columns
# Name Data Type Length
1 SUBMISSION_ID CHARACTER VARYING(50) 50
2 FACILITY_ID CHARACTER VARYING(40) 40
3 APPLICATION_ID CHARACTER VARYING(50) 50
4 PROD_GRP_SERIAL_NO BYTEINT 1
5 ACCOUNT_NUMBER CHARACTER VARYING(100) 100
6 SPLIT_ACCOUNT_NUMBER CHARACTER VARYING(40) 40
7 SUBMISSION_APPLICATION_STATUS CHARACTER VARYING(50) 50
8 DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
9 BANK_CODE CHARACTER VARYING(4) 4
10 BANKING_TYPE CHARACTER VARYING(6) 6
11 APPLICATION_BRANCH_CODE CHARACTER VARYING(10) 10
12 ACCOUNT_OPENING_DATE TIMESTAMP 8
13 ACCOUNT_CREATION_DATE TIMESTAMP 8
14 ACCOUNT_CLOSURE_DATE TIMESTAMP 8
15 FIRST_DISBURSEMENT_DATE DATE 4
16 SCHEDULED_SETTLEMENT_DATE TIMESTAMP 8
17 SOURCE_PRODUCT_CODE CHARACTER VARYING(95) 95
18 OFFER_ID CHARACTER VARYING(40) 40
19 PRODUCT_CODE CHARACTER VARYING(50) 50
20 PRODUCT_GROUP_ID CHARACTER VARYING(50) 50
21 PRODUCT_DESC CHARACTER VARYING(120) 120
22 PRODUCT_GROUP_NAME CHARACTER VARYING(120) 120
23 PRODUCT_GRP_CODE CHARACTER VARYING(16) 16
24 PRODUCT_CLASS CHARACTER VARYING(40) 40
25 OPPORTUNITY_ID CHARACTER VARYING(40) 40
26 LOAN_PURPOSE_CODE CHARACTER VARYING(50) 50
27 LOAN_SUB_PURPOSE_CODE CHARACTER VARYING(255) 255
28 FACILITY_TYPE CHARACTER VARYING(3) 3
29 SUBMISSION_CREATION_DATE TIMESTAMP 8
30 FACILITY_CREATION_DATE TIMESTAMP 8
31 AGE_OF_APPLICATION_DAYS INTEGER 4
32 APPLICATION_CREATION_DATE TIMESTAMP 8
33 APPLICATION_CREATED_BY CHARACTER VARYING(254) 254
34 BORROWING_ENTITY_ID CHARACTER VARYING(50) 50
35 PRIMARY_APPLICANT_PARTY_ID CHARACTER VARYING(40) 40
36 IS_PRIMARY_APPLICANT CHARACTER(1) 1
37 IS_EXISTING_CUSTOMER CHARACTER(1) 1
38 PRIMARY_APPLICANT_PARTY_TYPE CHARACTER VARYING(50) 50
39 APPLICATION_DATA_ENTRY_BRANCH CHARACTER VARYING(10) 10
40 APPLICATION_STATUS CHARACTER VARYING(50) 50
41 APPROVAL_TYPE CHARACTER VARYING(3) 3
42 APPROVAL_TYPE_DESCRIPTION CHARACTER VARYING(3) 3
43 APPROVER_ID CHARACTER VARYING(50) 50
44 APPROVER_NAME CHARACTER VARYING(50) 50
45 BUSINESS_UNIT CHARACTER VARYING(40) 40
46 RELATIONSHIP_MANAGER CHARACTER VARYING(40) 40
47 APPLICATION_DECISION_DATE TIMESTAMP 8
48 APPLICATION_DECISION_ID CHARACTER VARYING(50) 50
49 APPLICATION_DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
50 APPLICATION_CHANNEL CHARACTER VARYING(100) 100
51 APPLICATION_CHANNEL_DESCRIPTION CHARACTER VARYING(400) 400
52 APPLICATION_CHANNEL_SOURCE CHARACTER VARYING(8) 8
53 FIRST_HOME_OWNER_GRANT_FLAG CHARACTER VARYING(1) 1
54 APPLICATION_RISK_SCORE DOUBLE PRECISION 8
55 APPLICATION_RISK_SCORECARD CHARACTER VARYING(20) 20
56 APPLICATION_RISK_GRADE CHARACTER VARYING(20) 20
57 APPLICATION_FRAUD_STATUS_TYPE CHARACTER VARYING(50) 50
58 APPLICATION_FRAUD_REASON CHARACTER VARYING(50) 50
59 APPLICATION_MANUAL_FRAUD_STATUS CHARACTER VARYING(50) 50
60 COLLATERAL_EVAL_STATUS CHARACTER VARYING(50) 50
61 VERIFICATION_EVAL_STATUS CHARACTER VARYING(50) 50
62 EMPLOYEE_FLAG CHARACTER VARYING(1) 1
63 LENDING_CATEGORY_CODE CHARACTER VARYING(16) 16
64 LOWDOC_FLAG CHARACTER VARYING(1) 1
65 SCHEDULE_CODE CHARACTER VARYING(40) 40
66 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
67 SUBMISSION_CREATED_BY CHARACTER VARYING(254) 254
68 SUBMISSION_BRANCH CHARACTER VARYING(10) 10
69 SUBMISSION_DATA_ENTRY_BRANCH CHARACTER VARYING(10) 10
70 SUBMISSION_DATE TIMESTAMP 8
71 SUBMISSION_STATUS CHARACTER VARYING(50) 50
72 SUBMISSION_DECISION_DATE TIMESTAMP 8
73 SUBMISSION_DECISION_ID CHARACTER VARYING(50) 50
74 SUBMISSION_DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
75 SUBMISSION_CDTL_APPROVAL_DATE TIMESTAMP 8
76 SUBMISSION_UNCDTL_APPROVAL_DATE TIMESTAMP 8
77 SUBMISSION_CDTL_APPROVAL_OFFICER CHARACTER VARYING(40) 40
78 SUBMISSION_UNCDTL_APPROVAL_OFFICER CHARACTER VARYING(40) 40
79 FACILITY_DECISION_DATE TIMESTAMP 8
80 FACILITY_DECISION_ID CHARACTER VARYING(50) 50
81 FACILITY_DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
82 FIRST_SUBMISSION_DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
83 REFER_REASON_1_CODE CHARACTER VARYING(20) 20
84 REFER_REASON_1_DESCRIPTION CHARACTER VARYING(255) 255
85 DECLINE_REASON_1_CODE CHARACTER VARYING(20) 20
86 DECLINE_REASON_1_DESCRIPTION CHARACTER VARYING(255) 255
87 APPROVED_AMOUNT NUMERIC(35,2) 19
88 BASE_LOAN_AMOUNT NUMERIC(35,2) 19
89 TOTAL_FUNDING_AMOUNT NUMERIC(35,2) 19
90 TOTAL_LOAN_AMOUNT NUMERIC(35,2) 19
91 LOAN_VALUE_TIER CHARACTER VARYING(50) 50
92 LOAN_VALUE_RATIO NUMERIC(35,2) 19
93 LVR_GROUP CHARACTER VARYING(50) 50
94 LOAN_APPROVED_AMOUNT NUMERIC(35,2) 19
95 CAPACITY_TO_REPAY_MONTHLY_AMOUNT NUMERIC(20,2) 19
96 FACILITY_REPORTING_AMOUNT NUMERIC(35,2) 19
97 CONTRIBUTION_AMOUNT NUMERIC(35,2) 19
98 CCY_CODE CHARACTER VARYING(3) 3
99 TOTAL_CAPITALISED_FEE_AMOUNT NUMERIC(35,2) 19
100 TOTAL_CAPITALISED_INS_AMOUNT NUMERIC(35,2) 19
101 DISBURSEMENT_AMOUNT NUMERIC(35,2) 19
102 DISBURSEMENT_COUNT BIGINT 8
103 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
104 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
105 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
106 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
107 INTEREST_RATE_TYPE CHARACTER VARYING(50) 50
108 FV_FLAG CHARACTER VARYING(1) 1
109 OFFER_STAGE_CODE CHARACTER VARYING(120) 120
110 FIXED_RATE_TERM_MONTHS NUMERIC(35,2) 19
111 FIXED_PERIOD_END_DATE TIMESTAMP 8
112 ACCOUNT_TERM_MONTHS BIGINT 8
113 SIMULATION_ID CHARACTER VARYING(50) 50
114 IS_CURRENT CHARACTER VARYING(1) 1
115 PERS_INV_USAGE_TYPE CHARACTER VARYING(14) 14
116 INSURANCE_PRODUCT_TYPE CHARACTER VARYING(4) 4
117 ACCREDITED_BROKER_ID CHARACTER VARYING(20) 20
118 BROKER_CODE CHARACTER VARYING(40) 40
119 OFFER_NAME CHARACTER VARYING(120) 120
120 LOAN_PURPOSE_DESCRIPTION CHARACTER VARYING(400) 400
121 LOAN_SUB_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
122 REGION CHARACTER VARYING(240) 240
123 GEOGRAPHIC_STATE CHARACTER VARYING(3) 3
124 COST_CENTRE_NAME CHARACTER VARYING(240) 240
125 CAMPAIGN_CODE CHARACTER VARYING(20) 20
126 SWAP_LOAN_INDICATOR TIMESTAMP 8
127 OLD_OFFER_ID CHARACTER VARYING(10) 10
128 OFFER_SWAP_DATE TIMESTAMP 8
129 ADD_LOAN_FLAG CHARACTER VARYING(1) 1
130 ADD_LOAN_DATE TIMESTAMP 8
131 AMEND_DATE TIMESTAMP 8
132 COMMISION_TO_BE_PAID CHARACTER(1) 1
133 BUSINESS_SEGMENT_ID CHARACTER VARYING(40) 40
134 PREAPPROVAL_STATUS_TYPE CHARACTER VARYING(1) 1
135 PREAPPROVAL_DATE TIMESTAMP 8
136 PREAPPROVAL_REQUEST_AMOUNT NUMERIC(35,2) 19
137 PREAPPROVED_AMOUNT NUMERIC(35,2) 19
138 PREAPPROVED_BY CHARACTER VARYING(254) 254
139 DOWNSELL_STATUS CHARACTER VARYING(50) 50
140 FRAUD_STATUS_TYPE CHARACTER VARYING(50) 50
141 FRAUD_REASON CHARACTER VARYING(50) 50
142 MANUAL_FRAUD_STATUS CHARACTER VARYING(50) 50
143 CONDITION_WAIVED CHARACTER(1) 1
144 COVENANT_WAIVED CHARACTER(1) 1
145 VALUATION_WAIVED CHARACTER(1) 1
146 VERIFICATION_WAIVED CHARACTER(1) 1
147 FIRST_APPLICATION_LODGEMENT_DATE TIMESTAMP 8
148 LAST_APPLICATION_LODGEMENT_DATE TIMESTAMP 8
149 FIRST_APPLICATION_APPROVAL_DATE TIMESTAMP 8
150 LAST_APPLICATION_APPROVAL_DATE TIMESTAMP 8
151 LAST_APPLICATION_UNCONDITIONAL_APPROVAL_DATE TIMESTAMP 8
152 LAST_OFFER_LETTER_GENERATED_DATE TIMESTAMP 8
153 LAST_OFFER_LETTER_DISPATCH_DATE TIMESTAMP 8
154 LAST_OFFER_LETTER_ACCEPTANCE_DATE TIMESTAMP 8
155 LAST_OFFER_LETTER_DECLINED_DATE TIMESTAMP 8
156 FIRST_APPLICATION_DECISION_DATE TIMESTAMP 8
157 LAST_APPLICATION_DECISION_DATE TIMESTAMP 8
158 FIRST_APPLICATION_AUTO_DECISION_DATE TIMESTAMP 8
159 LAST_APPLICATION_AUTO_DECISION_DATE TIMESTAMP 8
160 FIRST_APPLICATION_MANUAL_DECISION_DATE TIMESTAMP 8
161 LAST_APPLICATION_MANUAL_DECISION_DATE TIMESTAMP 8
162 LAST_APPLICATION_DECISION_ACCEPTED_DATE TIMESTAMP 8
163 NUMBER_OF_APPLICATION_MANUAL_DECISIONS BIGINT 8
164 FIRST_DISBURSEMENT_TXN_DATE TIMESTAMP 8
165 LAST_DISBURSEMENT_TXN_DATE TIMESTAMP 8
166 FIRST_DISBURSEMENT_LOG_AMOUNT NUMERIC(35,2) 19
167 TOTAL_DISBURSEMENT_LOG_AMOUNT NUMERIC(35,2) 19
168 LATEST_SUBMISSION_OR_APPLICATION_STATUS_DATE_TIME TIMESTAMP 8
169 CURRENT_APPLICATION_STATE CHARACTER VARYING(251) 251
170 CURRENT_APPLICATION_LODGEMENT_DATE TIMESTAMP 8
171 CURRENT_APPLICATION_AUTO_DECISION_DATE TIMESTAMP 8
172 CURRENT_APPLICATION_AUTO_APPROVAL_DATE TIMESTAMP 8
173 CURRENT_APPLICATION_MANUAL_APPROVAL_DATE TIMESTAMP 8
174 CURRENT_APPLICATION_MANUAL_DECISION_DATE TIMESTAMP 8
175 CURRENT_APPLICATION_DECISION_ACCEPTED_DATE TIMESTAMP 8
176 CURRENT_APPLICATION_APPROVAL_DATE TIMESTAMP 8
177 CURRENT_APPLICATION_STRUCTURE_SOLN_CONFIRMED_DATE TIMESTAMP 8
178 CURRENT_OFFER_LETTER_DISPATCH_DATE TIMESTAMP 8
179 CURRENT_OFFER_LETTER_ACCEPTANCE_DATE TIMESTAMP 8
180 CURRENT_OFFER_LETTER_DECLINED_DATE TIMESTAMP 8
181 CURRENT_SETTLEMENT_INSTRUCTIONS_COMPLETED_DATE TIMESTAMP 8
182 CURRENT_APPLICATION_FULFILLED_TIMESTAMP TIMESTAMP 8
183 CURRENT_APPLICATION_AUTO_REFERRED_DATE TIMESTAMP 8
184 CURRENT_APPLICATION_REFERRED_DATE TIMESTAMP 8
185 CURRENT_APPLICATION_FRAUD_DECLINE_DATE TIMESTAMP 8
186 CURRENT_APPLICATION_REJECTED_DATE TIMESTAMP 8
187 CURRENT_APPLICATION_WITHDRAWN_DATE TIMESTAMP 8
188 CURRENT_APPLICATION_AUTO_REJECTED_DATE TIMESTAMP 8
189 MANUAL_DECISION_COMPLETED_USERID CHARACTER VARYING(254) 254
190 MANUAL_DECISION_COMPLETED_NAME CHARACTER VARYING(201) 201
191 TEAM_NAME CHARACTER VARYING(100) 100
192 REQUEST_TYPE CHARACTER VARYING(9) 9
193 AGENT_ID CHARACTER VARYING(20) 20
194 BDM_USER_ID CHARACTER VARYING(254) 254
195 POLICY_DEVIATION_APPLIED CHARACTER VARYING(1) 1
196 PREAPPROVAL_FLAG CHARACTER VARYING(1) 1
197 CAMPAIGN_CODE_ORIG CHARACTER VARYING(50) 50
198 TCE_AMOUNT NUMERIC(35,2) 19
199 ADD_LOANS_DISBURSEMENT_DATE TIMESTAMP 8
200 STAR_RATING CHARACTER VARYING(8) 8
201 LODGEMENT_TO_FIRST_DECISION_DAYS NUMERIC(14,1) 19
202 FIRST_TO_LAST_DECISION_DAYS NUMERIC(14,1) 19
203 LAST_DECISION_TO_OFFER_GENERATED_DAYS NUMERIC(14,1) 19
204 OFFER_GENERATED_TO_DISPATCHED_DAYS NUMERIC(14,1) 19
205 OFFER_DISPATCHED_TO_ACCEPTED_DAYS NUMERIC(14,1) 19
206 OFFER_ACCEPTED_TO_ACCOUNT_CREATED_DAYS NUMERIC(14,1) 19
207 ACCOUNT_CREATED_TO_SETTLEMENT_DAYS NUMERIC(14,1) 19
208 LODGEMENT_TO_APPROVAL_DAYS NUMERIC(14,1) 19
209 ACCEPT_DECISION_TO_OFFER_ROLLOUT_DAYS NUMERIC(14,1) 19
210 APPROVAL_TO_OFFER_ROLLOUT_DAYS NUMERIC(14,1) 19
211 OFFER_ACCEPT_TO_ACCOUNT_CREATED_DAYS NUMERIC(14,1) 19
212 SUBMISSION_TO_AUTO_DECISION_DAYS NUMERIC(14,1) 19
213 ACCOUNT_CREATED_TO_FULFILLED_DAYS NUMERIC(14,1) 19
214 UNCOND_APPROVAL_TO_DISBURSEMENT_DAYS NUMERIC(14,1) 19
215 COND_APPROVAL_TO_DISBURSEMENT_DAYS NUMERIC(14,1) 19
216 ACCOUNT_CREATED_TO_DISBURSMENT_DAYS NUMERIC(14,1) 19
217 LODGEMENT_TO_SETTLEMENT_DAYS NUMERIC(14,1) 19
218 LODGEMENT_TO_UNCOND_APPROVAL_DAYS NUMERIC(14,1) 19
219 LODGEMENT_TO_COND_APPROVAL_DAYS NUMERIC(14,1) 19
220 UNCOND_APPROVAL_TO_FULFILLED_DAYS NUMERIC(14,1) 19
221 COND_APPROVAL_TO_UNCOND_APP_DAYS NUMERIC(14,1) 19
222 MANAGER_ID CHARACTER VARYING(50) 50
223 HAS_AMT_DECREASED CHARACTER(1) 1
224 HAS_TERM_INCREASED CHARACTER(1) 1
225 HAS_TERM_DECREASED CHARACTER(1) 1
226 IS_BE_ADDED CHARACTER(1) 1
227 IS_BE_DELINKED CHARACTER(1) 1
228 IS_COL_ADDED CHARACTER(1) 1
229 IS_COL_DELINKED CHARACTER(1) 1
230 BROKER_NAME CHARACTER VARYING(250) 250
231 ACCREDITED_BROKER_FULL_NAME CHARACTER VARYING(401) 401
232 ACCREDITED_BROKER_STATE CHARACTER VARYING(3) 3
233 SHORT_NAME CHARACTER VARYING(250) 250