FCT_BNK_ROFT_DRAFT_AND_COMPLETE_SUBMISSION_LN

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

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