FCT_OBP_H_ORIGINATION_MASTER_LN_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

OBP Insight for origination, based file for ROFTS, has data a lowest grain, multiple rows per account

Synonyms

SDSNZP02_BANK..AS516_FCT_OBP_H_ORIGINATION_MASTER_LN_INSIGHT

SDSNZP02_BANK..UBAR_FCT_OBP_H_ORIGINATION_MASTER_LN_INSIGHT

Columns
# Name Data Type Length
1 FACILITY_ID CHARACTER VARYING(40) 40
2 APPLICATION_ID CHARACTER VARYING(50) 50
3 PROD_GRP_SERIAL_NO BYTEINT 1
4 ACCOUNT_NUMBER CHARACTER VARYING(100) 100
5 SPLIT_ACCOUNT_NUMBER CHARACTER VARYING(40) 40
6 SUBMISSION_ID CHARACTER VARYING(50) 50
7 SUBMISSION_APPLICATION_STATUS CHARACTER VARYING(50) 50
8 DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
9 FIRST_SUBMISSION_DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
10 FACILITY_TYPE CHARACTER VARYING(3) 3
11 LIMIT_AMOUNT DOUBLE PRECISION 8
12 EMPLOYEE_FLAG CHARACTER VARYING(1) 1
13 REQ_LIMIT_AMOUNT DOUBLE PRECISION 8
14 PRODUCT_GRP_CODE CHARACTER VARYING(16) 16
15 FACILITY_APPROVER_ID CHARACTER VARYING(50) 50
16 FACILITY_APPROVER_NAME CHARACTER VARYING(50) 50
17 APPROVAL_TYPE CHARACTER VARYING(3) 3
18 APPROVAL_TYPE_DESCRIPTION CHARACTER VARYING(3) 3
19 BRANCH_CODE CHARACTER VARYING(10) 10
20 FACILITY_CATEGORY_CODE CHARACTER VARYING(50) 50
21 LENDING_CATEGORY_CODE CHARACTER VARYING(16) 16
22 BUSINESS_UNIT CHARACTER VARYING(40) 40
23 RELATIONSHIP_MANAGER CHARACTER VARYING(40) 40
24 LOWDOC_FLAG CHARACTER VARYING(1) 1
25 REQ_NUMBER_OF_YEARS DOUBLE PRECISION 8
26 REQ_NUMBER_OF_MONTHS DOUBLE PRECISION 8
27 APPR_NUMBER_OF_YEARS DOUBLE PRECISION 8
28 APPR_NUMBER_OF_MONTHS DOUBLE PRECISION 8
29 FACILITY_ACTIVE_OR_CLOSED CHARACTER VARYING(1) 1
30 OFFER_ID CHARACTER VARYING(40) 40
31 OFFER_NAME CHARACTER VARYING(120) 120
32 OFFER_SERIAL_NUMBER BYTEINT 1
33 PRODUCT_CODE CHARACTER VARYING(50) 50
34 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
35 PRODUCT_GROUP_ID CHARACTER VARYING(50) 50
36 PRODUCT_GROUP_NAME CHARACTER VARYING(105) 105
37 PRODUCT_CLASS CHARACTER VARYING(40) 40
38 OPPORTUNITY_ID CHARACTER VARYING(40) 40
39 SIMULATION_ID CHARACTER VARYING(50) 50
40 LOAN_PURPOSE CHARACTER VARYING(40) 40
41 LOAN_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
42 LOAN_SUB_PURPOSE CHARACTER VARYING(255) 255
43 LOAN_SUB_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
44 BASE_LOAN_AMOUNT DOUBLE PRECISION 8
45 TOTAL_FUNDING_AMOUNT DOUBLE PRECISION 8
46 TOTAL_LOAN_AMOUNT DOUBLE PRECISION 8
47 LOAN_VALUE_TIER CHARACTER VARYING(50) 50
48 FACILITY_REPORTING_AMOUNT DOUBLE PRECISION 8
49 CCY_CODE CHARACTER VARYING(3) 3
50 CONTRIBUTION_AMOUNT DOUBLE PRECISION 8
51 BORROWING_ENTITY_ID CHARACTER VARYING(50) 50
52 TOTAL_CAPITALISED_FEE_AMOUNT DOUBLE PRECISION 8
53 TOTAL_CAPITALISED_INS_AMOUNT DOUBLE PRECISION 8
54 INSURANCE_PRODUCT_TYPE CHARACTER VARYING(4) 4
55 PERS_INV_USAGE_TYPE CHARACTER VARYING(14) 14
56 BANKING_TYPE CHARACTER VARYING(6) 6
57 ACCOUNT_OPENING_DATE TIMESTAMP 8
58 ACCOUNT_CLOSURE_DATE TIMESTAMP 8
59 SCHEDULE_CODE CHARACTER VARYING(40) 40
60 FIRST_DISBURSEMENT_DATE DATE 4
61 DISBURSEMENT_AMOUNT DOUBLE PRECISION 8
62 NET_DISBURSED_AMOUNT DOUBLE PRECISION 8
63 DISBURSEMENT_TO_SETTLE_AMOUNT DOUBLE PRECISION 8
64 CAMPAIGN_CODE CHARACTER VARYING(20) 20
65 SERVICING_BRANCH_CODE CHARACTER VARYING(10) 10
66 DISBURSEMENT_COUNT BIGINT 8
67 SCHEDULED_SETTLEMENT_DATE TIMESTAMP 8
68 ACCOUNT_TERM_MONTHS BIGINT 8
69 INITIAL_RATE_TYPE_CODE CHARACTER VARYING(22) 22
70 FIXED_PERIOD_END_DATE TIMESTAMP 8
71 FIXED_RATE_TERM_MONTHS DOUBLE PRECISION 8
72 FIXED_RATE_TERM_YEARS NUMERIC(33,0) 19
73 INTEREST_RATE_TYPE CHARACTER VARYING(8) 8
74 FV_FLAG CHARACTER VARYING(1) 1
75 SOURCE_PRODUCT_CODE CHARACTER VARYING(95) 95
76 OFFER_STAGE_CODE CHARACTER VARYING(120) 120
77 ARRANGEMENT_ID CHARACTER VARYING(40) 40
78 ACCOUNT_CREATION_DATE TIMESTAMP 8
79 SPLIT_DATE TIMESTAMP 8
80 SWAP_LOAN_INDICATOR TIMESTAMP 8
81 NEW_OFFER_ID CHARACTER VARYING(40) 40
82 NEW_OFFER_NAME CHARACTER VARYING(120) 120
83 OLD_OFFER_ID CHARACTER VARYING(10) 10
84 OFFER_SWAP_DATE TIMESTAMP 8
85 FIRST_APP_ACCOUNT_ID CHARACTER VARYING(100) 100
86 FIRST_FAC_ACCOUNT_ID CHARACTER VARYING(100) 100
87 CD_APPLICATION_ID CHARACTER VARYING(50) 50
88 FACILITY_DECISION_DATE TIMESTAMP 8
89 FACILITY_DECISION_ID CHARACTER VARYING(50) 50
90 FACILITY_DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
91 FACILITY_APPROVED_AMOUNT DOUBLE PRECISION 8
92 LOAN_VALUE_RATIO DOUBLE PRECISION 8
93 LVR_GROUP CHARACTER VARYING(50) 50
94 LOAN_APPROVED_AMOUNT DOUBLE PRECISION 8
95 CAPACITY_TO_REPAY_MONTHLY_AMOUNT NUMERIC(20,2) 19
96 APPLICATION_CREATED_BY CHARACTER VARYING(254) 254
97 APPLICATION_BRANCH CHARACTER VARYING(10) 10
98 APPLICATION_STATUS CHARACTER VARYING(50) 50
99 APPLICATION_CREATION_TIMESTAMP TIMESTAMP 8
100 AGE_OF_APPLICATION_DAYS INTEGER 4
101 APPLICATION_SUBMISSION_TIMESTAMP TIMESTAMP 8
102 APPLICATION_DATA_ENTRY_BRANCH CHARACTER VARYING(10) 10
103 APPLICATION_TYPE CHARACTER VARYING(20) 20
104 APPLICATION_REQUEST_TYPE CHARACTER VARYING(20) 20
105 ADD_LOAN_FLAG CHARACTER VARYING(1) 1
106 ADD_LOAN_DATE TIMESTAMP 8
107 AMEND_DATE TIMESTAMP 8
108 COMMISION_TO_BE_PAID CHARACTER(1) 1
109 UPFRONT_REBATE DOUBLE PRECISION 8
110 APPLICATION_NATURE CHARACTER VARYING(1) 1
111 APPLICATION_RECORD_ACTIVE_OR_CLOSED CHARACTER(1) 1
112 APPLICATION_CHANNEL CHARACTER VARYING(10) 10
113 APPLICATION_CHANNEL_DESCRIPTION CHARACTER VARYING(400) 400
114 APPLICATION_CHANNEL_SOURCE CHARACTER VARYING(8) 8
115 FIRST_HOME_OWNER_GRANT_FLAG CHARACTER VARYING(1) 1
116 APPLICATION_DECISION_ID CHARACTER VARYING(50) 50
117 APPLICATION_STAGE_TYPE CHARACTER VARYING(50) 50
118 APPLICATION_DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
119 APPLICATION_DECISION_DATE TIMESTAMP 8
120 APPLICATION_RISK_SCORE DOUBLE PRECISION 8
121 APPLICATION_RISK_SCORECARD CHARACTER VARYING(20) 20
122 APPLICATION_RISK_GRADE CHARACTER VARYING(20) 20
123 DECISION_EFFECTIVE_DATE TIMESTAMP 8
124 APPLICATION_FRAUD_STATUS_TYPE CHARACTER VARYING(50) 50
125 APPLICATION_FRAUD_REASON CHARACTER VARYING(50) 50
126 APPLICATION_MANUAL_FRAUD_STATUS CHARACTER VARYING(50) 50
127 COLLATERAL_EVAL_STATUS CHARACTER VARYING(50) 50
128 VERIFICATION_EVAL_STATUS CHARACTER VARYING(50) 50
129 SUBMISSION_CREATION_DATE TIMESTAMP 8
130 FACILITY_CREATION_DATE TIMESTAMP 8
131 SUBMISSION_DATA_ENTRY_BRANCH CHARACTER VARYING(10) 10
132 SUBMISSION_CREATED_BY CHARACTER VARYING(254) 254
133 SUBMISSION_BRANCH CHARACTER VARYING(10) 10
134 SUBMISSION_DATE TIMESTAMP 8
135 SUBMISSION_STATUS CHARACTER VARYING(50) 50
136 SUBMISSION_TYPE CHARACTER VARYING(50) 50
137 SUBMISSION_REQUEST_TYPE CHARACTER VARYING(50) 50
138 SUBMISSION_ACTIVE_OR_CLOSED CHARACTER(1) 1
139 SUBMISSION_LAST_UPDATE_TIMESTAMP TIMESTAMP 8
140 SUBMISSION_WITHDRAW_DATE TIMESTAMP 8
141 SUBMISSION_EXPIRY_DATE TIMESTAMP 8
142 HEADER_ID CHARACTER VARYING(50) 50
143 SUBMISSION_CHANNEL CHARACTER VARYING(10) 10
144 SUBMISSION_CHANNEL_CODE CHARACTER VARYING(400) 400
145 SUBMISSION_CHANNEL_SOURCE CHARACTER VARYING(8) 8
146 ACCREDITED_BROKER_ID CHARACTER VARYING(20) 20
147 BROKER_CODE CHARACTER VARYING(40) 40
148 SUBMISSION_PRIORITY CHARACTER VARYING(50) 50
149 MARKET_ENTITY_ID CHARACTER VARYING(40) 40
150 BUSINESS_SEGMENT_ID CHARACTER VARYING(40) 40
151 PREAPPROVAL_STATUS_TYPE CHARACTER VARYING(1) 1
152 PREAPPROVAL_DATE TIMESTAMP 8
153 PREAPPROVAL_REQUEST_AMOUNT DOUBLE PRECISION 8
154 PREAPPROVED_AMOUNT DOUBLE PRECISION 8
155 PREAPPROVED_BY CHARACTER VARYING(254) 254
156 PRIMARY_APPLICANT_ID CHARACTER VARYING(50) 50
157 PRIMARY_APPLICANT_PARTY_ID CHARACTER VARYING(40) 40
158 PRIMARY_APPLICANT_PARTY_TYPE CHARACTER VARYING(50) 50
159 IS_PRIMARY_APPLICANT CHARACTER(1) 1
160 IS_EXISTING_CUSTOMER CHARACTER(1) 1
161 SUBMISSION_CDC_COMMIT_TIMESTAMP TIMESTAMP 8
162 SUBMISSION_CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
163 SUBMISSION_DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
164 AUTH_DECISION_STATUS CHARACTER VARYING(50) 50
165 MAN_DECISION_STATUS CHARACTER VARYING(50) 50
166 SUBMISSION_DECISION_ID CHARACTER VARYING(50) 50
167 SUBMISSION_DECISION_DATE TIMESTAMP 8
168 SUBMISSION_CDTL_APPROVAL_DATE TIMESTAMP 8
169 SUBMISSION_UNCDTL_APPROVAL_DATE TIMESTAMP 8
170 SUBMISSION_CDTL_APPROVAL_OFFICER CHARACTER VARYING(40) 40
171 SUBMISSION_UNCDTL_APPROVAL_OFFICER CHARACTER VARYING(40) 40
172 REFER_REASON_1_CODE CHARACTER VARYING(20) 20
173 REFER_REASON_1_DESCRIPTION CHARACTER VARYING(255) 255
174 DECLINE_REASON_1_CODE CHARACTER VARYING(20) 20
175 DECLINE_REASON_1_DESCRIPTION CHARACTER VARYING(255) 255
176 CREDIT_MEMO_REQ CHARACTER(1) 1
177 CREDIT_MEMO_ID CHARACTER VARYING(50) 50
178 SUB_CALL_REF_NUM CHARACTER VARYING(50) 50
179 DOWNSELL_STATUS CHARACTER VARYING(50) 50
180 OVERVIEW_REQ CHARACTER(1) 1
181 OVERVIEW_DONE CHARACTER(1) 1
182 OVERVIEW_DATE TIMESTAMP 8
183 SUBMISSION_APPROVER_ID CHARACTER VARYING(50) 50
184 FRAUD_STATUS_TYPE CHARACTER VARYING(50) 50
185 FRAUD_REASON CHARACTER VARYING(50) 50
186 MANUAL_FRAUD_STATUS CHARACTER VARYING(50) 50
187 CONDITION_WAIVED CHARACTER(1) 1
188 COVENANT_WAIVED CHARACTER(1) 1
189 VALUATION_WAIVED CHARACTER(1) 1
190 VERIFICATION_WAIVED CHARACTER(1) 1
191 AGGREGATE_LIMIT DOUBLE PRECISION 8
192 PERSONAL_AAA_AGGR DOUBLE PRECISION 8
193 PERSONAL_EXCESS DOUBLE PRECISION 8
194 SUBMISSION_DECISION_LAST_UPDATED_BY CHARACTER VARYING(254) 254
195 SUBMISSION_DECISION_LAST_UPDATE_DATE TIMESTAMP 8
196 DECISION_ACTIVE_OR_CLOSED CHARACTER(1) 1
197 OUTSIDE_AMOUNT_PRE_LOAN DOUBLE PRECISION 8
198 OUTSIDE_AMOUNT_PRE_LOAN_CCY CHARACTER VARYING(5) 5
199 OUTSIDE_AMOUNT_POST_LOAN DOUBLE PRECISION 8
200 OUTSIDE_AMOUNT_POST_LOAN_CCY CHARACTER VARYING(5) 5
201 WITHIN_AMOUNT_PRE_LOAN DOUBLE PRECISION 8
202 WITHIN_AMOUNT_PRE_LOAN_CCY CHARACTER VARYING(5) 5
203 WITHIN_AMOUNT_POST_LOAN DOUBLE PRECISION 8
204 WITHIN_AMOUNT_POST_LOAN_CCY CHARACTER VARYING(5) 5
205 APP_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
206 APPDEC_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
207 FAC_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
208 SUB_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
209 BUSINESS_END_OF_DAY_DATE DATE 4
210 IS_CURRENT_FOR_END_OF_DAY CHARACTER VARYING(1) 1
211 IS_CURRENT CHARACTER VARYING(1) 1
212 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
213 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
214 SDW_IGNITE_SOURCE CHARACTER VARYING(1) 1
215 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
216 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
217 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
218 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
219 IS_EXTERNAL_REFINANCE CHARACTER VARYING(1) 1
220 IS_FAST_REFI CHARACTER VARYING(1) 1
221 CURRENT_LENDER_NAME CHARACTER VARYING(40) 40
222 OWING_AMOUNT DOUBLE PRECISION 8
223 BROKER_NAME CHARACTER VARYING(250) 250
224 ACCREDITED_BROKER_FULL_NAME CHARACTER VARYING(401) 401
225 ACCREDITED_BROKER_STATE CHARACTER VARYING(3) 3
226 SHORT_NAME CHARACTER VARYING(250) 250
227 IS_LATEST_APPLICATION_FOR_SUBMISSION_AND_FACILITY CHARACTER VARYING(1) 1