FCT_APPLICATIONS_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..FCT_APPLICATIONS

Synonyms

INSNZP01_BANK..SYN_FCT_APPLICATIONS_INSIGHT

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 FACILITY_CREATION_DATE TIMESTAMP 8
7 SUBMISSION_UNCDTL_APPROVAL_DATE TIMESTAMP 8
8 SUBMISSION_FIRST_CDTL_APPROVAL_DT TIMESTAMP 8
9 LODGEMENT_DATE TIMESTAMP 8
10 FIRST_APPLICATION_LODGEMENT_DATE TIMESTAMP 8
11 DISBURSEMENT_DATE TIMESTAMP 8
12 PRODUCT_GROUP CHARACTER VARYING(120) 120
13 PRODUCT_CODE CHARACTER VARYING(50) 50
14 SOURCE_PRODUCT_CODE CHARACTER VARYING(95) 95
15 PRODUCT_1_DESC CHARACTER VARYING(100) 100
16 PRODUCT_2_DESC CHARACTER VARYING(100) 100
17 PRODUCT_3_DESC CHARACTER VARYING(100) 100
18 PRODUCT_4_DESC CHARACTER VARYING(100) 100
19 PRODUCT_5_DESC CHARACTER VARYING(100) 100
20 PERS_INV_USAGE_TYPE CHARACTER VARYING(60) 60
21 ANZSIC_CODE CHARACTER VARYING(250) 250
22 LOAN_PURPOSE CHARACTER VARYING(250) 250
23 LOAN_PURPOSE_DESCRIPTION CHARACTER VARYING(400) 400
24 LOAN_SUB_PURPOSE CHARACTER VARYING(255) 255
25 LOAN_SUB_PURPOSE_DESCRIPTION CHARACTER VARYING(256) 256
26 LOAN_VALUE_RATIO NUMERIC(36,3) 19
27 LVR_GROUP CHARACTER VARYING(9) 9
28 SCHEDULED_FEE_AMT DOUBLE PRECISION 8
29 ACTUAL_FEE_AMT DOUBLE PRECISION 8
30 PRDT_INTEREST_RATE DOUBLE PRECISION 8
31 ACT_INTEREST_RATE DOUBLE PRECISION 8
32 DISCOUNT_PCT NUMERIC(38,6) 19
33 SETTLE_BRANCH CHARACTER VARYING(240) 240
34 SETTLE_BRANCH_CC_LVL_01_NAME CHARACTER VARYING(240) 240
35 SETTLE_BRANCH_CC_LVL_02_NAME CHARACTER VARYING(240) 240
36 SETTLE_BRANCH_CC_LVL_03_NAME CHARACTER VARYING(240) 240
37 SETTLE_BRANCH_CC_LVL_04_NAME CHARACTER VARYING(240) 240
38 SETTLE_BRANCH_CC_LVL_05_NAME CHARACTER VARYING(240) 240
39 SETTLE_BRANCH_CC_LVL_06_NAME CHARACTER VARYING(240) 240
40 SALES_BRANCH CHARACTER VARYING(240) 240
41 SALES_BRANCH_CC_LVL_01_NAME CHARACTER VARYING(240) 240
42 SALES_BRANCH_CC_LVL_02_NAME CHARACTER VARYING(240) 240
43 SALES_BRANCH_CC_LVL_03_NAME CHARACTER VARYING(240) 240
44 SALES_BRANCH_CC_LVL_04_NAME CHARACTER VARYING(240) 240
45 SALES_BRANCH_CC_LVL_05_NAME CHARACTER VARYING(240) 240
46 SALES_BRANCH_CC_LVL_06_NAME CHARACTER VARYING(240) 240
47 APPLICATION_CHANNEL CHARACTER VARYING(100) 100
48 COST_CENTRE_CHANNEL CHARACTER VARYING(30) 30
49 GL_DEPARTMENT_CHANNEL CHARACTER VARYING(30) 30
50 CLMS_DIVISION_NAME CHARACTER VARYING(256) 256
51 BROKER_CODE CHARACTER VARYING(40) 40
52 ACCREDITED_BROKER_ID CHARACTER VARYING(20) 20
53 ACCREDITED_BROKER_SEGMENT CHARACTER VARYING(50) 50
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 TCE_AMOUNT NUMERIC(35,2) 19
64 SALES_OFFICER_USER_ID CHARACTER VARYING(254) 254
65 APPLICATION_CREATED_BY CHARACTER VARYING(254) 254
66 SUBMISSION_UNCDTL_APPROVAL_OFFICER CHARACTER VARYING(40) 40
67 APPLICATION_RISK_SCORE CHARACTER VARYING(20) 20
68 APPLICATION_RISK_GRADE CHARACTER VARYING(26) 26
69 FIRST_HOME_OWNER_GRANT_FLAG CHARACTER VARYING(1) 1
70 DECLINE_REASON_1_CODE CHARACTER VARYING(20) 20
71 DECLINE_REASON_1_DESCRIPTION CHARACTER VARYING(255) 255
72 CALC_TOT_DAYS_LODGMT_TO_SETTLMT BIGINT 8
73 CALC_TOT_DAYS_LODGMT_TO_UNCOND BIGINT 8
74 CALC_TOT_DAYS_UNCOND_TO_SETTLMT BIGINT 8
75 CALC_TOT_DAYS_LODGMT_TO_FIRST_COND BIGINT 8
76 CALC_TOT_DAYS_FIRST_COND_TO_UNCDTL BIGINT 8
77 ORIGINAL_REQUESTED_AMOUNT DOUBLE PRECISION 8
78 HAS_AMT_DECREASED CHARACTER(1) 1
79 HAS_TERM_INCREASED CHARACTER(1) 1
80 HAS_TERM_DECREASED CHARACTER(1) 1
81 IS_BE_ADDED CHARACTER(1) 1
82 IS_BE_DELINKED CHARACTER(1) 1
83 IS_COL_ADDED CHARACTER(1) 1
84 IS_COL_DELINKED CHARACTER(1) 1
85 NEW_FIRST_APPLICATION_LODGEMENT_DATE TIMESTAMP 8
86 LAST_APPLICATION_LODGEMENT_DATE TIMESTAMP 8
87 FIRST_STRUCTURE_SOLN_CONFIRMED_DATE TIMESTAMP 8
88 LAST_STRUCTURE_SOLN_CONFIRMED_DATE TIMESTAMP 8
89 FIRST_STRUCTURE_SOLN_CONFIRMED_UID CHARACTER VARYING(254) 254
90 LAST_STRUCTURE_SOLN_CONFIRMED_UID CHARACTER VARYING(254) 254
91 FIRST_CONDITIONAL_APPROVAL_DATE TIMESTAMP 8
92 LAST_CONDITIONAL_APPROVAL_DATE TIMESTAMP 8
93 FIRST_APPLICATION_UNCONDITIONAL_APPROVAL_DATE TIMESTAMP 8
94 LAST_APPLICATION_UNCONDITIONAL_APPROVAL_DATE TIMESTAMP 8
95 FIRST_OFFER_LETTER_DISPATCH_DATE TIMESTAMP 8
96 LAST_OFFER_LETTER_DISPATCH_DATE TIMESTAMP 8
97 FIRST_OFFER_LETTER_ACCEPTANCE_DATE TIMESTAMP 8
98 LAST_OFFER_LETTER_ACCEPTANCE_DATE TIMESTAMP 8
99 BROKER_NAME CHARACTER VARYING(250) 250
100 ACCREDITED_BROKER_FULL_NAME CHARACTER VARYING(401) 401
101 ACCREDITED_BROKER_STATE CHARACTER VARYING(3) 3
102 SHORT_NAME CHARACTER VARYING(250) 250
103 NO_APPS BIGINT 8
104 NO_GUARANTOR NUMERIC(38,0) 19
105 NO_ENTITY_APPS NUMERIC(38,0) 19
106 TOT_DEBT NUMERIC(38,5) 19
107 GROSS_INCOME NUMERIC(38,6) 19
108 DTI_RATIO NUMERIC(38,6) 19
109 SERVICING_AMOUNT NUMERIC(20,2) 19
110 TEAM_NAME CHARACTER VARYING(100) 100
111 SUBMISSION_DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
112 AGE_OF_APPLICATION_DAYS INTEGER 4
113 FIRST_APPLICATION_DECISION_DATE TIMESTAMP 8
114 LAST_APPLICATION_DECISION_DATE TIMESTAMP 8
115 LAST_APPLICATION_AUTO_DECISION_DATE TIMESTAMP 8
116 LAST_OFFER_LETTER_GENERATED_DATE TIMESTAMP 8
117 PRE_APPROVAL_FLAG CHARACTER VARYING(1) 1
118 PREAPP_TO_LODGEMENT_CONVERSION_DATE TIMESTAMP 8
119 CAMPAIGN_CODE CHARACTER VARYING(20) 20
120 CAMPAIGN_APPLICANT_NAME CHARACTER VARYING(250) 250