FCT_OBP_ROFT_ORIGINATION_LN_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..FCT_OBP_ROFT_ORIGINATION_LN

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 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(8) 8
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(200) 200
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 IS_EXTERNAL_REFINANCE CHARACTER VARYING(1) 1
148 IS_FAST_REFI CHARACTER VARYING(1) 1
149 CURRENT_LENDER_NAME CHARACTER VARYING(40) 40
150 OWING_AMOUNT DOUBLE PRECISION 8
151 MANAGER_ID CHARACTER VARYING(50) 50
152 BDM_USER_ID CHARACTER VARYING(254) 254
153 FIRST_APPLICATION_LODGEMENT_DATE TIMESTAMP 8
154 LAST_APPLICATION_LODGEMENT_DATE TIMESTAMP 8
155 FIRST_APPLICATION_APPROVAL_DATE TIMESTAMP 8
156 LAST_APPLICATION_APPROVAL_DATE TIMESTAMP 8
157 LAST_APPLICATION_UNCONDITIONAL_APPROVAL_DATE TIMESTAMP 8
158 LAST_OFFER_LETTER_GENERATED_DATE TIMESTAMP 8
159 LAST_OFFER_LETTER_DISPATCH_DATE TIMESTAMP 8
160 LAST_OFFER_LETTER_ACCEPTANCE_DATE TIMESTAMP 8
161 LAST_OFFER_LETTER_DECLINED_DATE TIMESTAMP 8
162 FIRST_APPLICATION_DECISION_DATE TIMESTAMP 8
163 LAST_APPLICATION_DECISION_DATE TIMESTAMP 8
164 FIRST_APPLICATION_AUTO_DECISION_DATE TIMESTAMP 8
165 LAST_APPLICATION_AUTO_DECISION_DATE TIMESTAMP 8
166 FIRST_APPLICATION_MANUAL_DECISION_DATE TIMESTAMP 8
167 LAST_APPLICATION_MANUAL_DECISION_DATE TIMESTAMP 8
168 LAST_APPLICATION_DECISION_ACCEPTED_DATE TIMESTAMP 8
169 NUMBER_OF_APPLICATION_MANUAL_DECISIONS BIGINT 8
170 FIRST_DISBURSEMENT_TXN_DATE TIMESTAMP 8
171 LAST_DISBURSEMENT_TXN_DATE TIMESTAMP 8
172 FIRST_DISBURSEMENT_LOG_AMOUNT NUMERIC(35,2) 19
173 TOTAL_DISBURSEMENT_LOG_AMOUNT NUMERIC(35,2) 19
174 LATEST_SUBMISSION_OR_APPLICATION_STATUS_DATE_TIME TIMESTAMP 8
175 CURRENT_APPLICATION_STATE CHARACTER VARYING(251) 251
176 CURRENT_APPLICATION_LODGEMENT_DATE TIMESTAMP 8
177 CURRENT_APPLICATION_AUTO_DECISION_DATE TIMESTAMP 8
178 CURRENT_APPLICATION_AUTO_APPROVAL_DATE TIMESTAMP 8
179 CURRENT_APPLICATION_MANUAL_APPROVAL_DATE TIMESTAMP 8
180 CURRENT_APPLICATION_MANUAL_DECISION_DATE TIMESTAMP 8
181 CURRENT_APPLICATION_DECISION_ACCEPTED_DATE TIMESTAMP 8
182 CURRENT_APPLICATION_APPROVAL_DATE TIMESTAMP 8
183 CURRENT_APPLICATION_STRUCTURE_SOLN_CONFIRMED_DATE TIMESTAMP 8
184 CURRENT_OFFER_LETTER_DISPATCH_DATE TIMESTAMP 8
185 CURRENT_OFFER_LETTER_ACCEPTANCE_DATE TIMESTAMP 8
186 CURRENT_OFFER_LETTER_DECLINED_DATE TIMESTAMP 8
187 CURRENT_SETTLEMENT_INSTRUCTIONS_COMPLETED_DATE TIMESTAMP 8
188 CURRENT_APPLICATION_FULFILLED_TIMESTAMP TIMESTAMP 8
189 CURRENT_APPLICATION_AUTO_REFERRED_DATE TIMESTAMP 8
190 CURRENT_APPLICATION_REFERRED_DATE TIMESTAMP 8
191 CURRENT_APPLICATION_FRAUD_DECLINE_DATE TIMESTAMP 8
192 CURRENT_APPLICATION_REJECTED_DATE TIMESTAMP 8
193 CURRENT_APPLICATION_WITHDRAWN_DATE TIMESTAMP 8
194 CURRENT_APPLICATION_AUTO_REJECTED_DATE TIMESTAMP 8
195 MANUAL_DECISION_COMPLETED_USERID CHARACTER VARYING(254) 254
196 MANUAL_DECISION_COMPLETED_NAME CHARACTER VARYING(201) 201
197 TEAM_NAME CHARACTER VARYING(100) 100
198 REQUEST_TYPE CHARACTER VARYING(9) 9
199 AGENT_ID CHARACTER VARYING(20) 20
200 POLICY_DEVIATION_APPLIED CHARACTER VARYING(1) 1
201 PREAPPROVAL_FLAG CHARACTER VARYING(1) 1
202 CAMPAIGN_CODE_ORIG CHARACTER VARYING(50) 50
203 TCE_AMOUNT NUMERIC(35,2) 19
204 ADD_LOANS_DISBURSEMENT_DATE TIMESTAMP 8
205 STAR_RATING CHARACTER VARYING(8) 8
206 LODGEMENT_TO_FIRST_DECISION_DAYS NUMERIC(14,1) 19
207 FIRST_TO_LAST_DECISION_DAYS NUMERIC(14,1) 19
208 LAST_DECISION_TO_OFFER_GENERATED_DAYS NUMERIC(14,1) 19
209 OFFER_GENERATED_TO_DISPATCHED_DAYS NUMERIC(14,1) 19
210 OFFER_DISPATCHED_TO_ACCEPTED_DAYS NUMERIC(14,1) 19
211 OFFER_ACCEPTED_TO_ACCOUNT_CREATED_DAYS NUMERIC(14,1) 19
212 ACCOUNT_CREATED_TO_SETTLEMENT_DAYS NUMERIC(14,1) 19
213 LODGEMENT_TO_APPROVAL_DAYS NUMERIC(14,1) 19
214 ACCEPT_DECISION_TO_OFFER_ROLLOUT_DAYS NUMERIC(14,1) 19
215 APPROVAL_TO_OFFER_ROLLOUT_DAYS NUMERIC(14,1) 19
216 OFFER_ACCEPT_TO_ACCOUNT_CREATED_DAYS NUMERIC(14,1) 19
217 SUBMISSION_TO_AUTO_DECISION_DAYS NUMERIC(14,1) 19
218 ACCOUNT_CREATED_TO_FULFILLED_DAYS NUMERIC(14,1) 19
219 UNCOND_APPROVAL_TO_DISBURSEMENT_DAYS NUMERIC(14,1) 19
220 COND_APPROVAL_TO_DISBURSEMENT_DAYS NUMERIC(14,1) 19
221 ACCOUNT_CREATED_TO_DISBURSMENT_DAYS NUMERIC(14,1) 19
222 LODGEMENT_TO_SETTLEMENT_DAYS NUMERIC(14,1) 19
223 LODGEMENT_TO_UNCOND_APPROVAL_DAYS NUMERIC(14,1) 19
224 LODGEMENT_TO_COND_APPROVAL_DAYS NUMERIC(14,1) 19
225 UNCOND_APPROVAL_TO_FULFILLED_DAYS NUMERIC(14,1) 19
226 COND_APPROVAL_TO_UNCOND_APP_DAYS NUMERIC(14,1) 19
227 HAS_AMT_DECREASED CHARACTER(1) 1
228 HAS_TERM_INCREASED CHARACTER(1) 1
229 HAS_TERM_DECREASED CHARACTER(1) 1
230 IS_BE_ADDED CHARACTER(1) 1
231 IS_BE_DELINKED CHARACTER(1) 1
232 IS_COL_ADDED CHARACTER(1) 1
233 IS_COL_DELINKED CHARACTER(1) 1
234 AUTO_APPROVED_LOAN_FLG CHARACTER VARYING(1) 1
235 BROKER_NAME CHARACTER VARYING(250) 250
236 ACCREDITED_BROKER_FULL_NAME CHARACTER VARYING(401) 401
237 ACCREDITED_BROKER_STATE CHARACTER VARYING(3) 3
238 SHORT_NAME CHARACTER VARYING(250) 250
239 DTI NUMERIC(20,2) 19