FCT_OBP_UBAR_APPLICATIONS_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

Synonyms

SDSNZP02_BANK..EFS_FCT_OBP_UBAR_APPLICATIONS_INSIGHT

SDSNZP02_BANK..UBAR_FCT_OBP_UBAR_APPLICATIONS_INSIGHT

Columns
# Name Data Type Length
1 FACILITY_ID CHARACTER VARYING(40) 40
2 APPLICATION_ID CHARACTER VARYING(50) 50
3 SUBMISSION_ID CHARACTER VARYING(50) 50
4 ACCOUNT_NUMBER CHARACTER VARYING(100) 100
5 SOURCE CHARACTER VARYING(3) 3
6 APPLICATION_DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
7 SUBMISSION_APPLICATION_STATUS CHARACTER VARYING(50) 50
8 FACILITY_CREATION_DATE TIMESTAMP 8
9 SUBMISSION_UNCDTL_APPROVAL_DATE TIMESTAMP 8
10 SUBMISSION_FIRST_CDTL_APPROVAL_DT TIMESTAMP 8
11 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(14) 14
22 ANZSIC_CODE CHARACTER VARYING(4) 4
23 LOAN_PURPOSE CHARACTER VARYING(50) 50
24 LOAN_PURPOSE_DESCRIPTION CHARACTER VARYING(400) 400
25 LOAN_SUB_PURPOSE CHARACTER VARYING(255) 255
26 LOAN_SUB_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
27 LOAN_VALUE_RATIO NUMERIC(35,2) 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(35,2) 19
34 SETTLE_BRANCH CHARACTER VARYING(10) 10
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(10) 10
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 APPLICATION_CHANNEL_DESCRIPTION CHARACTER VARYING(400) 400
50 APPLICATION_CHANNEL_SOURCE CHARACTER VARYING(8) 8
51 BROKER_CODE CHARACTER VARYING(40) 40
52 ACCREDITED_BROKER_ID CHARACTER VARYING(20) 20
53 ACCREDITED_BROKER_SEGMENT CHARACTER VARYING(8) 8
54 BROKER_FLAG CHARACTER VARYING(14) 14
55 LOWDOC_FLAG CHARACTER VARYING(1) 1
56 EMPLOYEE_FLAG CHARACTER VARYING(1) 1
57 ADD_LOAN_FLAG CHARACTER VARYING(1) 1
58 OFFER_STAGE_CODE CHARACTER VARYING(34) 34
59 INTEREST_ONLY_FLAG CHARACTER VARYING(1) 1
60 PREAPPROVAL_STATUS_TYPE CHARACTER VARYING(16) 16
61 NBR INTEGER 4
62 FACILITY_REPORTING_AMOUNT NUMERIC(35,2) 19
63 DISBURSEMENT_AMOUNT DOUBLE PRECISION 8
64 BASE_LOAN_AMOUNT NUMERIC(35,2) 19
65 TOTAL_LOAN_AMOUNT NUMERIC(35,2) 19
66 TOTAL_FUNDING_AMOUNT NUMERIC(35,2) 19
67 CONTRIBUTION_AMOUNT NUMERIC(35,2) 19
68 TCE_AMOUNT NUMERIC(35,2) 19
69 TOTAL_CAPITALISED_FEE_AMOUNT NUMERIC(35,2) 19
70 TOTAL_CAPITALISED_INS_AMOUNT NUMERIC(35,2) 19
71 SALES_OFFICER_USER_ID CHARACTER VARYING(254) 254
72 APPLICATION_CREATED_BY CHARACTER VARYING(254) 254
73 SUBMISSION_UNCDTL_APPROVAL_OFFICER CHARACTER VARYING(40) 40
74 APPLICATION_RISK_SCORE DOUBLE PRECISION 8
75 APPLICATION_RISK_GRADE CHARACTER VARYING(20) 20
76 FIRST_HOME_OWNER_GRANT_FLAG CHARACTER VARYING(1) 1
77 FACILITY_DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
78 DECLINE_REASON_1_CODE CHARACTER VARYING(20) 20
79 DECLINE_REASON_1_DESCRIPTION CHARACTER VARYING(255) 255
80 CALC_TOT_DAYS_LODGMT_TO_SETTLMT BIGINT 8
81 CALC_TOT_DAYS_LODGMT_TO_UNCOND BIGINT 8
82 CALC_TOT_DAYS_UNCOND_TO_SETTLMT BIGINT 8
83 CALC_TOT_DAYS_LODGMT_TO_FIRST_COND BIGINT 8
84 CALC_TOT_DAYS_FIRST_COND_TO_UNCDTL BIGINT 8
85 COST_CENTRE_CHANNEL CHARACTER VARYING(1) 1
86 GL_DEPARTMENT_CHANNEL CHARACTER VARYING(1) 1
87 CLMS_DIVISION_NAME CHARACTER VARYING(1) 1
88 HAS_AMT_DECREASED CHARACTER(1) 1
89 HAS_TERM_INCREASED CHARACTER(1) 1
90 HAS_TERM_DECREASED CHARACTER(1) 1
91 IS_BE_ADDED CHARACTER(1) 1
92 IS_BE_DELINKED CHARACTER(1) 1
93 IS_COL_ADDED CHARACTER(1) 1
94 IS_COL_DELINKED CHARACTER(1) 1
95 FIRST_APPLICATION_LODGEMENT_DATE TIMESTAMP 8
96 NEW_FIRST_APPLICATION_LODGEMENT_DATE TIMESTAMP 8
97 LAST_APPLICATION_LODGEMENT_DATE TIMESTAMP 8
98 FIRST_STRUCTURE_SOLN_CONFIRMED_DATE TIMESTAMP 8
99 LAST_STRUCTURE_SOLN_CONFIRMED_DATE TIMESTAMP 8
100 FIRST_STRUCTURE_SOLN_CONFIRMED_UID CHARACTER VARYING(254) 254
101 LAST_STRUCTURE_SOLN_CONFIRMED_UID CHARACTER VARYING(254) 254
102 FIRST_CONDITIONAL_APPROVAL_DATE TIMESTAMP 8
103 LAST_CONDITIONAL_APPROVAL_DATE TIMESTAMP 8
104 FIRST_APPLICATION_UNCONDITIONAL_APPROVAL_DATE TIMESTAMP 8
105 LAST_APPLICATION_UNCONDITIONAL_APPROVAL_DATE TIMESTAMP 8
106 FIRST_OFFER_LETTER_DISPATCH_DATE TIMESTAMP 8
107 LAST_OFFER_LETTER_DISPATCH_DATE TIMESTAMP 8
108 FIRST_OFFER_LETTER_ACCEPTANCE_DATE TIMESTAMP 8
109 LAST_OFFER_LETTER_ACCEPTANCE_DATE TIMESTAMP 8
110 BROKER_NAME CHARACTER VARYING(250) 250
111 ACCREDITED_BROKER_FULL_NAME CHARACTER VARYING(401) 401
112 ACCREDITED_BROKER_STATE CHARACTER VARYING(3) 3
113 SHORT_NAME CHARACTER VARYING(250) 250
114 ADJ_DEBT NUMERIC(22,2) 19
115 INC_AMT NUMERIC(38,2) 19
116 DTI NUMERIC(38,6) 19
117 TEAM_NAME CHARACTER VARYING(100) 100
118 SUBMISSION_DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
119 AGE_OF_APPLICATION_DAYS INTEGER 4
120 FIRST_APPLICATION_DECISION_DATE TIMESTAMP 8
121 LAST_APPLICATION_DECISION_DATE TIMESTAMP 8
122 LAST_APPLICATION_AUTO_DECISION_DATE TIMESTAMP 8
123 LAST_OFFER_LETTER_GENERATED_DATE TIMESTAMP 8
124 PRE_APPROVAL_FLAG CHARACTER VARYING(1) 1
125 PREAPP_TO_LODGEMENT_CONVERSION_DATE TIMESTAMP 8
126 CAMPAIGN_CODE CHARACTER VARYING(20) 20
127 CAMPAIGN_APPLICANT_NAME CHARACTER VARYING(250) 250