FCT_BNK_ROFT_ORIGINATION_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.

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(105) 105
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(40) 40
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(10) 10
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 REFER_REASON_1_CODE CHARACTER VARYING(20) 20
83 REFER_REASON_1_DESCRIPTION CHARACTER VARYING(255) 255
84 DECLINE_REASON_1_CODE CHARACTER VARYING(20) 20
85 DECLINE_REASON_1_DESCRIPTION CHARACTER VARYING(255) 255
86 APPROVED_AMOUNT NUMERIC(35,2) 19
87 BASE_LOAN_AMOUNT NUMERIC(35,2) 19
88 TOTAL_FUNDING_AMOUNT NUMERIC(35,2) 19
89 TOTAL_LOAN_AMOUNT NUMERIC(35,2) 19
90 LOAN_VALUE_TIER CHARACTER VARYING(50) 50
91 LOAN_VALUE_RATIO NUMERIC(35,2) 19
92 LVR_GROUP CHARACTER VARYING(50) 50
93 LOAN_APPROVED_AMOUNT NUMERIC(35,2) 19
94 CAPACITY_TO_REPAY_MONTHLY_AMOUNT NUMERIC(20,2) 19
95 FACILITY_REPORTING_AMOUNT NUMERIC(35,2) 19
96 CONTRIBUTION_AMOUNT NUMERIC(35,2) 19
97 CCY_CODE CHARACTER VARYING(3) 3
98 TOTAL_CAPITALISED_FEE_AMOUNT NUMERIC(35,2) 19
99 TOTAL_CAPITALISED_INS_AMOUNT NUMERIC(35,2) 19
100 DISBURSEMENT_AMOUNT NUMERIC(35,2) 19
101 DISBURSEMENT_COUNT BIGINT 8
102 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
103 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
104 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
105 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
106 INTEREST_RATE_TYPE CHARACTER VARYING(8) 8
107 FV_FLAG CHARACTER VARYING(1) 1
108 OFFER_STAGE_CODE CHARACTER VARYING(120) 120
109 FIXED_RATE_TERM_MONTHS NUMERIC(35,2) 19
110 FIXED_PERIOD_END_DATE TIMESTAMP 8
111 ACCOUNT_TERM_MONTHS BIGINT 8
112 SIMULATION_ID CHARACTER VARYING(50) 50
113 IS_CURRENT CHARACTER VARYING(1) 1
114 PERS_INV_USAGE_TYPE CHARACTER VARYING(14) 14
115 INSURANCE_PRODUCT_TYPE CHARACTER VARYING(4) 4
116 ACCREDITED_BROKER_ID CHARACTER VARYING(20) 20
117 BROKER_CODE CHARACTER VARYING(40) 40
118 OFFER_NAME CHARACTER VARYING(120) 120
119 LOAN_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
120 LOAN_SUB_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
121 REGION CHARACTER VARYING(240) 240
122 GEOGRAPHIC_STATE CHARACTER VARYING(3) 3
123 COST_CENTRE_NAME CHARACTER VARYING(240) 240
124 CAMPAIGN_CODE CHARACTER VARYING(20) 20
125 SWAP_LOAN_INDICATOR TIMESTAMP 8
126 OLD_OFFER_ID CHARACTER VARYING(10) 10
127 OFFER_SWAP_DATE TIMESTAMP 8
128 ADD_LOAN_FLAG CHARACTER VARYING(1) 1
129 ADD_LOAN_DATE TIMESTAMP 8
130 COMMISION_TO_BE_PAID CHARACTER(1) 1
131 BUSINESS_SEGMENT_ID CHARACTER VARYING(40) 40
132 PREAPPROVAL_STATUS_TYPE CHARACTER VARYING(1) 1
133 PREAPPROVAL_DATE TIMESTAMP 8
134 PREAPPROVAL_REQUEST_AMOUNT NUMERIC(35,2) 19
135 PREAPPROVED_AMOUNT NUMERIC(35,2) 19
136 PREAPPROVED_BY CHARACTER VARYING(254) 254
137 DOWNSELL_STATUS CHARACTER VARYING(50) 50
138 FRAUD_STATUS_TYPE CHARACTER VARYING(50) 50
139 FRAUD_REASON CHARACTER VARYING(50) 50
140 MANUAL_FRAUD_STATUS CHARACTER VARYING(50) 50
141 CONDITION_WAIVED CHARACTER(1) 1
142 COVENANT_WAIVED CHARACTER(1) 1
143 VALUATION_WAIVED CHARACTER(1) 1
144 VERIFICATION_WAIVED CHARACTER(1) 1
145 FIRST_APPLICATION_LODGEMENT_DATE TIMESTAMP 8
146 LAST_APPLICATION_LODGEMENT_DATE TIMESTAMP 8
147 FIRST_APPLICATION_APPROVAL_DATE TIMESTAMP 8
148 LAST_APPLICATION_APPROVAL_DATE TIMESTAMP 8
149 LAST_APPLICATION_UNCONDITIONAL_APPROVAL_DATE TIMESTAMP 8
150 LAST_OFFER_LETTER_GENERATED_DATE TIMESTAMP 8
151 LAST_OFFER_LETTER_DISPATCH_DATE TIMESTAMP 8
152 LAST_OFFER_LETTER_ACCEPTANCE_DATE TIMESTAMP 8
153 LAST_OFFER_LETTER_DECLINED_DATE TIMESTAMP 8
154 FIRST_APPLICATION_DECISION_DATE TIMESTAMP 8
155 LAST_APPLICATION_DECISION_DATE TIMESTAMP 8
156 FIRST_APPLICATION_AUTO_DECISION_DATE TIMESTAMP 8
157 LAST_APPLICATION_AUTO_DECISION_DATE TIMESTAMP 8
158 FIRST_APPLICATION_MANUAL_DECISION_DATE TIMESTAMP 8
159 LAST_APPLICATION_MANUAL_DECISION_DATE TIMESTAMP 8
160 LAST_APPLICATION_DECISION_ACCEPTED_DATE TIMESTAMP 8
161 NUMBER_OF_APPLICATION_MANUAL_DECISIONS BIGINT 8
162 FIRST_DISBURSEMENT_TXN_DATE TIMESTAMP 8
163 LAST_DISBURSEMENT_TXN_DATE TIMESTAMP 8
164 FIRST_DISBURSEMENT_LOG_AMOUNT NUMERIC(35,2) 19
165 TOTAL_DISBURSEMENT_LOG_AMOUNT NUMERIC(35,2) 19
166 LATEST_SUBMISSION_OR_APPLICATION_STATUS_DATE_TIME TIMESTAMP 8
167 CURRENT_APPLICATION_STATE CHARACTER VARYING(251) 251
168 CURRENT_APPLICATION_LODGEMENT_DATE TIMESTAMP 8
169 CURRENT_APPLICATION_AUTO_DECISION_DATE TIMESTAMP 8
170 CURRENT_APPLICATION_AUTO_APPROVAL_DATE TIMESTAMP 8
171 CURRENT_APPLICATION_MANUAL_APPROVAL_DATE TIMESTAMP 8
172 CURRENT_APPLICATION_MANUAL_DECISION_DATE TIMESTAMP 8
173 CURRENT_APPLICATION_DECISION_ACCEPTED_DATE TIMESTAMP 8
174 CURRENT_APPLICATION_APPROVAL_DATE TIMESTAMP 8
175 CURRENT_APPLICATION_STRUCTURE_SOLN_CONFIRMED_DATE TIMESTAMP 8
176 CURRENT_OFFER_LETTER_DISPATCH_DATE TIMESTAMP 8
177 CURRENT_OFFER_LETTER_ACCEPTANCE_DATE TIMESTAMP 8
178 CURRENT_OFFER_LETTER_DECLINED_DATE TIMESTAMP 8
179 CURRENT_SETTLEMENT_INSTRUCTIONS_COMPLETED_DATE TIMESTAMP 8
180 CURRENT_APPLICATION_FULFILLED_TIMESTAMP TIMESTAMP 8
181 CURRENT_APPLICATION_AUTO_REFERRED_DATE TIMESTAMP 8
182 CURRENT_APPLICATION_REFERRED_DATE TIMESTAMP 8
183 CURRENT_APPLICATION_FRAUD_DECLINE_DATE TIMESTAMP 8
184 CURRENT_APPLICATION_REJECTED_DATE TIMESTAMP 8
185 CURRENT_APPLICATION_WITHDRAWN_DATE TIMESTAMP 8
186 CURRENT_APPLICATION_AUTO_REJECTED_DATE TIMESTAMP 8
187 MANUAL_DECISION_COMPLETED_USERID CHARACTER VARYING(254) 254
188 MANUAL_DECISION_COMPLETED_NAME CHARACTER VARYING(201) 201
189 TEAM_NAME CHARACTER VARYING(100) 100
190 REQUEST_TYPE CHARACTER VARYING(9) 9
191 AGENT_ID CHARACTER VARYING(20) 20
192 BDM_USER_ID CHARACTER VARYING(254) 254
193 POLICY_DEVIATION_APPLIED CHARACTER VARYING(1) 1
194 PREAPPROVAL_FLAG CHARACTER VARYING(1) 1
195 CAMPAIGN_CODE_ORIG CHARACTER VARYING(50) 50
196 TCE_AMOUNT NUMERIC(35,2) 19
197 ADD_LOANS_DISBURSEMENT_DATE TIMESTAMP 8
198 STAR_RATING CHARACTER VARYING(8) 8
199 LODGEMENT_TO_FIRST_DECISION_DAYS NUMERIC(14,1) 19
200 FIRST_TO_LAST_DECISION_DAYS NUMERIC(14,1) 19
201 LAST_DECISION_TO_OFFER_GENERATED_DAYS NUMERIC(14,1) 19
202 OFFER_GENERATED_TO_DISPATCHED_DAYS NUMERIC(14,1) 19
203 OFFER_DISPATCHED_TO_ACCEPTED_DAYS NUMERIC(14,1) 19
204 OFFER_ACCEPTED_TO_ACCOUNT_CREATED_DAYS NUMERIC(14,1) 19
205 ACCOUNT_CREATED_TO_SETTLEMENT_DAYS NUMERIC(14,1) 19
206 LODGEMENT_TO_APPROVAL_DAYS NUMERIC(14,1) 19
207 ACCEPT_DECISION_TO_OFFER_ROLLOUT_DAYS NUMERIC(14,1) 19
208 APPROVAL_TO_OFFER_ROLLOUT_DAYS NUMERIC(14,1) 19
209 OFFER_ACCEPT_TO_ACCOUNT_CREATED_DAYS NUMERIC(14,1) 19
210 SUBMISSION_TO_AUTO_DECISION_DAYS NUMERIC(14,1) 19
211 ACCOUNT_CREATED_TO_FULFILLED_DAYS NUMERIC(14,1) 19
212 UNCOND_APPROVAL_TO_DISBURSEMENT_DAYS NUMERIC(14,1) 19
213 COND_APPROVAL_TO_DISBURSEMENT_DAYS NUMERIC(14,1) 19
214 ACCOUNT_CREATED_TO_DISBURSMENT_DAYS NUMERIC(14,1) 19
215 LODGEMENT_TO_SETTLEMENT_DAYS NUMERIC(14,1) 19
216 LODGEMENT_TO_UNCOND_APPROVAL_DAYS NUMERIC(14,1) 19
217 LODGEMENT_TO_COND_APPROVAL_DAYS NUMERIC(14,1) 19
218 UNCOND_APPROVAL_TO_FULFILLED_DAYS NUMERIC(14,1) 19
219 COND_APPROVAL_TO_UNCOND_APP_DAYS NUMERIC(14,1) 19
220 MANAGER_ID CHARACTER VARYING(50) 50
221 IS_EXTERNAL_REFINANCE CHARACTER VARYING(1) 1
222 IS_FAST_REFI CHARACTER VARYING(1) 1
223 CURRENT_LENDER_NAME CHARACTER VARYING(40) 40
224 OWING_AMOUNT DOUBLE PRECISION 8
225 AUTO_APPROVED_LOAN_FLG CHARACTER VARYING(1) 1
226 DTI NUMERIC(20,2) 19