FCT_BNK_LOAN_ORIGINATION_1_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

OBP Part 1 of Loan Origination Report. Summary of the applications that are at various stages of loan processing

Source Object (CTAS)

SDSNZP05_BANK..FCT_BNK_LOAN_ORIGINATION_1

Columns
# Name Data Type Length
1 SUBMISSION_ID CHARACTER VARYING(50) 50
2 APPLICATION_ID CHARACTER VARYING(50) 50
3 FACILITY_ID CHARACTER VARYING(40) 40
4 ORIGINATION_BRANCH_CC CHARACTER VARYING(10) 10
5 APPL_BRANCH_STATE_CODE CHARACTER VARYING(3) 3
6 ACCOUNT_BRANCH_STATE_CODE CHARACTER VARYING(3) 3
7 ORIGINATION_BRANCH_NAME CHARACTER VARYING(105) 105
8 ORIGINATION_BRANCH_REGION CHARACTER VARYING(240) 240
9 CHANNEL CHARACTER VARYING(10) 10
10 ORIGINATOR_NAME CHARACTER VARYING(372) 372
11 FACILITY_REPORTING_AMOUNT DOUBLE PRECISION 8
12 REQUESTED_AMOUNT DOUBLE PRECISION 8
13 APPROVED_AMT DOUBLE PRECISION 8
14 LOAN_PRODUCT_GROUP CHARACTER VARYING(105) 105
15 LOAN_PURPOSE_TYPE CHARACTER VARYING(400) 400
16 LOAN_SUBPURPOSE_TYPE CHARACTER VARYING(255) 255
17 LVL_3_REG_LOAN_PURPOSE CHARACTER VARYING(200) 200
18 INSURANCE_PRODUCT_TYPE CHARACTER VARYING(20) 20
19 EMPLOYMENT_STATUS CHARACTER VARYING(400) 400
20 FACILITY_STATUS CHARACTER VARYING(50) 50
21 DECISION_DATE TIMESTAMP 8
22 DISBURSED_AMOUNT DOUBLE PRECISION 8
23 APPLICATION_STATUS CHARACTER VARYING(50) 50
24 APPLICATION_STATUS_DATE TIMESTAMP 8
25 PRODUCT_CODE CHARACTER VARYING(30) 30
26 PROD_DESC CHARACTER VARYING(120) 120
27 OFFER_ID CHARACTER VARYING(40) 40
28 OFFER_DESC CHARACTER VARYING(120) 120
29 LVR DOUBLE PRECISION 8
30 REMOTE_SETTLEMENT_R1 CHARACTER VARYING(1) 1
31 JOINT_APPLICATION CHARACTER VARYING(1) 1
32 APP_SUBMITTED TIMESTAMP 8
33 APP_AUTO_APPROVED TIMESTAMP 8
34 CDTL_APPROVAL_DATE TIMESTAMP 8
35 UNCDTL_APPROVAL_DATE TIMESTAMP 8
36 AUTO_REFERRED TIMESTAMP 8
37 AUTO_REJECTED TIMESTAMP 8
38 MANUAL_ACCEPTED TIMESTAMP 8
39 MANUAL_REJECTED TIMESTAMP 8
40 MANUAL_FRAUD_DECLINED TIMESTAMP 8
41 OFFER_LTR_GENERATED TIMESTAMP 8
42 OFFER_LTR_DISPATCHED TIMESTAMP 8
43 OFFER_LTR_ACCEPTED TIMESTAMP 8
44 OFFER_LTR_REJECTED TIMESTAMP 8
45 REJECT_LTR_GENERATED TIMESTAMP 8
46 DECLINE_LTR_DISPATCHED TIMESTAMP 8
47 STRUCTURE_SOLN_CONFIRMED TIMESTAMP 8
48 FIRST_STRUCTURE_SOLN_CONFIRMED TIMESTAMP 8
49 ACCOUNT_OPENED TIMESTAMP 8
50 FULFILLED TIMESTAMP 8
51 APP_WITHDRAWN TIMESTAMP 8
52 SUBMISSION_INCOMPLETE TIMESTAMP 8
53 SUBMISSION_SUBMITTED TIMESTAMP 8
54 FIRST_SUBMISSION_SUBMITTED_DATE TIMESTAMP 8
55 SUBMISSION_CANCELLED TIMESTAMP 8
56 EXPIRY_DATE TIMESTAMP 8
57 SUBMISSION_MARKED_FOR_EXPIRY TIMESTAMP 8
58 SUBMISSION_EXPIRED TIMESTAMP 8
59 SUBMISSION_MARKED_FOR_EDIT_SAVED TIMESTAMP 8
60 SUBMISSION_COMPLETED TIMESTAMP 8
61 MARKED_FOR_WITHDRAW TIMESTAMP 8
62 SUBMISSION_WITHDRAWN TIMESTAMP 8
63 OPPORTUNITY_ID CHARACTER VARYING(40) 40
64 BORROWING_ENTITY CHARACTER VARYING(2509) 2509
65 IS_EXISTING_CUSTOMER CHARACTER(1) 1
66 LAST_NAME CHARACTER VARYING(50) 50
67 FIRST_NAME CHARACTER VARYING(50) 50
68 REMOTE_SETTLEMENT CHARACTER VARYING(1) 1
69 SETTLEMENT_DT TIMESTAMP 8
70 ACCOUNT_ID CHARACTER VARYING(40) 40
71 SUBMISSION_MARKED_FOR_EDIT TIMESTAMP 8
72 APP_EXPIRED TIMESTAMP 8
73 APPROVING_OFFICER CHARACTER VARYING(40) 40
74 VERIFYING_OFFICER CHARACTER VARYING(50) 50
75 ORIGINATION_OFFICER CHARACTER VARYING(254) 254
76 FIRST_HOME_BUYER_FLAG CHARACTER VARYING(1) 1
77 ANZSIC_DESCRIPTION CHARACTER VARYING(200) 200
78 ABN_ACN_NUMBER CHARACTER VARYING(30) 30
79 TOTAL_COMBINED_EXPOSURE DOUBLE PRECISION 8
80 HOME_POSTCODE CHARACTER VARYING(30) 30
81 EMPLOYER_POSTCODE CHARACTER VARYING(120) 120