FCT_BNK_SPECIAL_INTEREST_INFLIGHT_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
2 PRODUCT_GROUP_ID CHARACTER VARYING(50) 50
3 PRODUCT_GROUP CHARACTER VARYING(105) 105
4 APPLICATION_ID CHARACTER VARYING(50) 50
5 SUBMISSION_ID CHARACTER VARYING(50) 50
6 SUBMISSION_DATE TIMESTAMP 8
7 CHANNEL CHARACTER VARYING(10) 10
8 OFFER CHARACTER VARYING(40) 40
9 PRODUCT_CODE CHARACTER VARYING(50) 50
10 FACILITY_ID CHARACTER VARYING(40) 40
11 ARRANGEMENT_ID CHARACTER VARYING(40) 40
12 BRANCH CHARACTER VARYING(105) 105
13 REGION CHARACTER VARYING(35) 35
14 UDM_REASON_CODE CHARACTER VARYING(200) 200
15 UDM_REASON_DESCRIPTION CHARACTER VARYING(120) 120
16 UDM_FIXED DOUBLE PRECISION 8
17 UDM_VARIABLE DOUBLE PRECISION 8
18 VALIDITY_START_DATE TIMESTAMP 8
19 VALIDITY_END_DATE TIMESTAMP 8
20 APPROVAL_USER_ID CHARACTER VARYING(254) 254
21 APPROVAL_USER_NAME CHARACTER VARYING(100) 100
22 MARGIN_REASON_CODE CHARACTER VARYING(50) 50
23 MARGIN_REASON_DESCRIPTION CHARACTER VARYING(300) 300
24 MAR_FIXED_MARGIN_AMT DOUBLE PRECISION 8
25 MAR_VAR_MARGIN_AMT DOUBLE PRECISION 8
26 LENDER_USER_ID CHARACTER VARYING(50) 50
27 LENDER_USER_NAME CHARACTER VARYING(100) 100
28 LOAN_TO_VALUE_RATIO_MV DOUBLE PRECISION 8
29 ACCOUNT_OPENING_DATE TIMESTAMP 8
30 LOAN_AMOUNT DOUBLE PRECISION 8
31 RATE_TYPE CHARACTER VARYING(13) 13
32 FIXED_INTEREST_RATE_AMT DOUBLE PRECISION 8
33 VAR_INTEREST_RATE_AMT DOUBLE PRECISION 8
34 STANDARDRATE DOUBLE PRECISION 8
35 MARGINVARIANCE DOUBLE PRECISION 8
36 UDMVARIANCE DOUBLE PRECISION 8
37 FIXED_NET_RATE DOUBLE PRECISION 8
38 VAR_NET_RATE DOUBLE PRECISION 8
39 ADJUSTED_RATE DOUBLE PRECISION 8
40 BORROWING_ENTITY CHARACTER VARYING(255) 255
41 DURATION_START_DATE DATE 4
42 DURATION_END_DATE DATE 4
43 DURATION_UDM CHARACTER VARYING(1) 1
44 DURATION_UDM_CHANGE_INDICATOR CHARACTER VARYING(1) 1
45 LOAN_PURPOSE CHARACTER VARYING(14) 14
46 LOAN_REPAYMENT_TYPE CHARACTER VARYING(120) 120
47 SOURCE_PRODUCT_CODE CHARACTER VARYING(95) 95
48 FIRST_HOME_OWNER_GRANT_FLAG CHARACTER VARYING(1) 1
49 TCE_AMOUNT NUMERIC(35,2) 19
50 RDDM_OFFER_STAGE_CODE_CODE NATIONAL CHARACTER VARYING(250) 250
51 RDDM_FIRST_HOME_OWNER_GRANT_FLAG_CODE NATIONAL CHARACTER VARYING(250) 250
52 RDDM_PROPERTY_RIGHTS_CODE NATIONAL CHARACTER VARYING(250) 250
53 RDDM_RATE_TYPE_CODE NATIONAL CHARACTER VARYING(250) 250
54 RDDM_LVR_MIN NUMERIC(31,2) 19
55 RDDM_LVR_MAX NUMERIC(31,2) 19
56 RDDM_MIN_LOAN_AMT NUMERIC(31,2) 19
57 RDDM_MAX_LOAN_AMT NUMERIC(31,2) 19
58 RDDM_SOURCE_PRODUCT_CODE NATIONAL CHARACTER VARYING(15) 15
59 METRIC_REPAY_TYPE CHARACTER VARYING(10) 10
60 METRIC_FHOGF CHARACTER VARYING(10) 10
61 METRIC_LP CHARACTER VARYING(10) 10
62 METRIC_RATE_TYPE CHARACTER VARYING(10) 10
63 METRIC_LVR CHARACTER VARYING(10) 10
64 METRIC_LOANRANGE CHARACTER VARYING(10) 10
65 METRIC_PROD_CODE CHARACTER VARYING(10) 10
66 METRIC_PASSED_COUNT INTEGER 4
67 METRIC_NA_COUNT INTEGER 4
68 VALID_TESTS CHARACTER VARYING(10) 10