FCT_BNK_SPECIAL_INTEREST_INFLIGHT_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

OBP Interest rates and Margin details for loans and facilities in the process of being originated with branch creators lenders and approvers

Source Object (CTAS)

SDSNZP05_BANK..FCT_BNK_SPECIAL_INTEREST_INFLIGHT

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