FCT_ASIC516_LOANS_UNDER_HEM_DASHBOARD_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 FACILITY_ID CHARACTER VARYING(20) 20
2 SUBMISSION_ID CHARACTER VARYING(50) 50
3 ACCOUNT_NUMBER CHARACTER VARYING(100) 100
4 SOURCE CHARACTER VARYING(3) 3
5 SUBMISSION_APPLICATION_STATUS CHARACTER VARYING(100) 100
6 APPLICATION_STATUS_GROUP NATIONAL CHARACTER VARYING(250) 250
7 FACILITY_CREATION_DATE TIMESTAMP 8
8 SUBMISSION_UNCDTL_APPROVAL_DATE TIMESTAMP 8
9 SUBMISSION_FIRST_CDTL_APPROVAL_DT TIMESTAMP 8
10 LODGEMENT_DATE TIMESTAMP 8
11 FIRST_APPLICATION_LODGEMENT_DATE TIMESTAMP 8
12 DISBURSEMENT_DATE TIMESTAMP 8
13 PRODUCT_GROUP CHARACTER VARYING(120) 120
14 PRODUCT_CODE CHARACTER VARYING(50) 50
15 SOURCE_PRODUCT_CODE CHARACTER VARYING(95) 95
16 PRODUCT_1_DESC CHARACTER VARYING(100) 100
17 PRODUCT_2_DESC CHARACTER VARYING(100) 100
18 PRODUCT_3_DESC CHARACTER VARYING(100) 100
19 PRODUCT_4_DESC CHARACTER VARYING(100) 100
20 PRODUCT_5_DESC CHARACTER VARYING(100) 100
21 PERS_INV_USAGE_TYPE CHARACTER VARYING(60) 60
22 ANZSIC_CODE CHARACTER VARYING(250) 250
23 LOAN_PURPOSE CHARACTER VARYING(250) 250
24 LOAN_PURPOSE_DESCRIPTION CHARACTER VARYING(400) 400
25 LOAN_SUB_PURPOSE CHARACTER VARYING(255) 255
26 LOAN_SUB_PURPOSE_DESCRIPTION CHARACTER VARYING(256) 256
27 LOAN_VALUE_RATIO NUMERIC(36,3) 19
28 LVR_GROUP CHARACTER VARYING(9) 9
29 SCHEDULED_FEE_AMT DOUBLE PRECISION 8
30 ACTUAL_FEE_AMT DOUBLE PRECISION 8
31 PRDT_INTEREST_RATE DOUBLE PRECISION 8
32 ACT_INTEREST_RATE DOUBLE PRECISION 8
33 DISCOUNT_PCT NUMERIC(38,6) 19
34 SETTLE_BRANCH CHARACTER VARYING(240) 240
35 SETTLE_BRANCH_CC_LVL_01_NAME CHARACTER VARYING(240) 240
36 SETTLE_BRANCH_CC_LVL_02_NAME CHARACTER VARYING(240) 240
37 SETTLE_BRANCH_CC_LVL_03_NAME CHARACTER VARYING(240) 240
38 SETTLE_BRANCH_CC_LVL_04_NAME CHARACTER VARYING(240) 240
39 SETTLE_BRANCH_CC_LVL_05_NAME CHARACTER VARYING(240) 240
40 SETTLE_BRANCH_CC_LVL_06_NAME CHARACTER VARYING(240) 240
41 SALES_BRANCH CHARACTER VARYING(240) 240
42 SALES_BRANCH_CC_LVL_01_NAME CHARACTER VARYING(240) 240
43 SALES_BRANCH_CC_LVL_02_NAME CHARACTER VARYING(240) 240
44 SALES_BRANCH_CC_LVL_03_NAME CHARACTER VARYING(240) 240
45 SALES_BRANCH_CC_LVL_04_NAME CHARACTER VARYING(240) 240
46 SALES_BRANCH_CC_LVL_05_NAME CHARACTER VARYING(240) 240
47 SALES_BRANCH_CC_LVL_06_NAME CHARACTER VARYING(240) 240
48 APPLICATION_CHANNEL CHARACTER VARYING(100) 100
49 COST_CENTRE_CHANNEL CHARACTER VARYING(30) 30
50 GL_DEPARTMENT_CHANNEL CHARACTER VARYING(30) 30
51 CLMS_DIVISION_NAME CHARACTER VARYING(256) 256
52 ACCREDITED_BROKER_SEGMENT CHARACTER VARYING(50) 50
53 BROKER_FLAG CHARACTER VARYING(14) 14
54 LOWDOC_FLAG CHARACTER VARYING(1) 1
55 EMPLOYEE_FLAG CHARACTER VARYING(1) 1
56 ADD_LOAN_FLAG CHARACTER VARYING(1) 1
57 OFFER_STAGE_CODE CHARACTER VARYING(34) 34
58 INTEREST_ONLY_FLAG CHARACTER VARYING(1) 1
59 PREAPPROVAL_STATUS_TYPE CHARACTER VARYING(16) 16
60 NBR INTEGER 4
61 FACILITY_REPORTING_AMOUNT NUMERIC(35,2) 19
62 TCE_AMOUNT NUMERIC(35,2) 19
63 SALES_OFFICER_USER_ID CHARACTER VARYING(254) 254
64 APPLICATION_CREATED_BY CHARACTER VARYING(254) 254
65 SUBMISSION_UNCDTL_APPROVAL_OFFICER CHARACTER VARYING(40) 40
66 FIRST_HOME_OWNER_GRANT_FLAG CHARACTER VARYING(1) 1
67 DECLINE_REASON_1_CODE CHARACTER VARYING(20) 20
68 DECLINE_REASON_1_DESCRIPTION CHARACTER VARYING(255) 255
69 CALC_TOT_DAYS_LODGMT_TO_SETTLMT BIGINT 8
70 CALC_TOT_DAYS_LODGMT_TO_UNCOND BIGINT 8
71 CALC_TOT_DAYS_UNCOND_TO_SETTLMT BIGINT 8
72 CALC_TOT_DAYS_LODGMT_TO_FIRST_COND BIGINT 8
73 CALC_TOT_DAYS_FIRST_COND_TO_UNCDTL BIGINT 8
74 ORIGINAL_REQUESTED_AMOUNT DOUBLE PRECISION 8
75 HAS_AMT_DECREASED CHARACTER(1) 1
76 HAS_TERM_INCREASED CHARACTER(1) 1
77 HAS_TERM_DECREASED CHARACTER(1) 1
78 IS_BE_ADDED CHARACTER(1) 1
79 IS_BE_DELINKED CHARACTER(1) 1
80 IS_COL_ADDED CHARACTER(1) 1
81 IS_COL_DELINKED CHARACTER(1) 1
82 NEW_FIRST_APPLICATION_LODGEMENT_DATE TIMESTAMP 8
83 LAST_APPLICATION_LODGEMENT_DATE TIMESTAMP 8
84 FIRST_STRUCTURE_SOLN_CONFIRMED_DATE TIMESTAMP 8
85 LAST_STRUCTURE_SOLN_CONFIRMED_DATE TIMESTAMP 8
86 FIRST_CONDITIONAL_APPROVAL_DATE TIMESTAMP 8
87 LAST_CONDITIONAL_APPROVAL_DATE TIMESTAMP 8
88 FIRST_APPLICATION_UNCONDITIONAL_APPROVAL_DATE TIMESTAMP 8
89 LAST_APPLICATION_UNCONDITIONAL_APPROVAL_DATE TIMESTAMP 8
90 FIRST_OFFER_LETTER_DISPATCH_DATE TIMESTAMP 8
91 LAST_OFFER_LETTER_DISPATCH_DATE TIMESTAMP 8
92 FIRST_OFFER_LETTER_ACCEPTANCE_DATE TIMESTAMP 8
93 LAST_OFFER_LETTER_ACCEPTANCE_DATE TIMESTAMP 8
94 SHORT_NAME CHARACTER VARYING(250) 250
95 NO_APPS BIGINT 8
96 NO_GUARANTOR NUMERIC(38,0) 19
97 NO_ENTITY_APPS NUMERIC(38,0) 19
98 TOT_DEBT NUMERIC(38,5) 19
99 GROSS_INCOME NUMERIC(38,6) 19
100 DTI_RATIO NUMERIC(38,6) 19
101 SERVICING_AMOUNT NUMERIC(20,2) 19
102 TEAM_NAME CHARACTER VARYING(100) 100
103 SUBMISSION_DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
104 AGE_OF_APPLICATION_DAYS INTEGER 4
105 FIRST_APPLICATION_DECISION_DATE TIMESTAMP 8
106 LAST_APPLICATION_DECISION_DATE TIMESTAMP 8
107 LAST_APPLICATION_AUTO_DECISION_DATE TIMESTAMP 8
108 LAST_OFFER_LETTER_GENERATED_DATE TIMESTAMP 8
109 PRE_APPROVAL_FLAG CHARACTER VARYING(1) 1
110 PREAPP_TO_LODGEMENT_CONVERSION_DATE TIMESTAMP 8
111 I_CODE CHARACTER VARYING(40) 40
112 AGGREGATOR_NAME NATIONAL CHARACTER VARYING(250) 250
113 A_CODE CHARACTER VARYING(20) 20
114 BROKER_NAME CHARACTER VARYING(511) 511
115 BROKER_GIVEN_NAMES CHARACTER VARYING(255) 255
116 BROKER_SURNAME CHARACTER VARYING(255) 255
117 UNIQUE_IDENTIFIER CHARACTER VARYING(255) 255
118 BROKER_BUSINESS_NAME CHARACTER VARYING(100) 100
119 BROKER_STATE CHARACTER VARYING(240) 240
120 LICENSE_TYPE NATIONAL CHARACTER VARYING(15) 15
121 APPLICATION_RISK_SCORE CHARACTER VARYING(20) 20
122 APPLICATION_RISK_GRADE CHARACTER VARYING(26) 26
123 ORIGINATION_RISK_SCORE CHARACTER VARYING(5) 5
124 ORIGINATION_RISK_GRADE NATIONAL CHARACTER VARYING(5) 5
125 ORIGINATION_RISK_GRADE_GROUP NATIONAL CHARACTER VARYING(250) 250
126 DISBURSED_LOAN CHARACTER VARYING(1) 1
127 TOT_NET_INCOME DOUBLE PRECISION 8
128 TOT_NO_OF_ADULT INTEGER 4
129 TOT_NO_OF_DEPENDENTS INTEGER 4
130 HH1_CTR_CALCULATED_EXPENSE DOUBLE PRECISION 8
131 HH1_CUST_ENTERED_EXPENSE DOUBLE PRECISION 8
132 HH1_NET_INCOME DOUBLE PRECISION 8
133 HH1_GROSS_INCOME DOUBLE PRECISION 8
134 HH1_NO_OF_ADULT INTEGER 4
135 HH1_NO_OF_DEPENDENTS INTEGER 4
136 HH2_CTR_CALCULATED_EXPENSE DOUBLE PRECISION 8
137 HH2_CUST_ENTERED_EXPENSE DOUBLE PRECISION 8
138 HH2_NET_INCOME DOUBLE PRECISION 8
139 HH2_GROSS_INCOME DOUBLE PRECISION 8
140 HH2_NO_OF_ADULT INTEGER 4
141 HH2_NO_OF_DEPENDENTS INTEGER 4
142 HH1_CDLE_VS_HEM CHARACTER VARYING(4) 4
143 HH2_CDLE_VS_HEM CHARACTER VARYING(20) 20
144 DATA_REFRESH_TIMESTAMP TIMESTAMP 8