FCT_BNK_BF_TM1_LN_PRICING_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 PORTFOLIO_DATE TIMESTAMP 8
2 LAST_REPRICE_DATE DATE 4
3 NEXT_REPRICE_DATE DATE 4
4 ORIGINATION_DATE DATE 4
5 ORACLE_GL_PRODUCT CHARACTER VARYING(10) 10
6 QRM_ACCOUNT CHARACTER VARYING(75) 75
7 FORECASTING_PRODUCT_GROUP CHARACTER VARYING(25) 25
8 PL_SECURED_FLAG CHARACTER VARYING(14) 14
9 REPAYMENT_TYPE CHARACTER VARYING(20) 20
10 HL_PROPERTY_RIGHTS CHARACTER VARYING(25) 25
11 BROKER_ORIGINATED_FLAG CHARACTER VARYING(1) 1
12 ORACLE_GL_COST_CENTRE_CHANNEL CHARACTER VARYING(40) 40
13 AVERAGE_MONTHLY_BALANCE NUMERIC(38,2) 19
14 FACE_AMT NUMERIC(38,4) 19
15 DEPOSIT_OFFSET_BALANCE NUMERIC(38,2) 19
16 DEPOSIT_OFFSET_AVG_BALANCE NUMERIC(38,2) 19
17 CURBAL_X_TP_ADDON_RT NUMERIC(38,8) 19
18 CURBAL_X_FC_ALLOC_RT NUMERIC(38,8) 19
19 CURBAL_X_BASIS_RT NUMERIC(38,8) 19
20 CURBAL_X_CUST_RT NUMERIC(38,8) 19
21 CURBAL_X_ADJ_CUST_RT NUMERIC(38,15) 19
22 CURBAL_X_BASE_RT NUMERIC(38,8) 19
23 AVGBAL_X_CUST_RT NUMERIC(38,6) 19
24 AVGBAL_X_TP_ADDON_RT NUMERIC(38,6) 19
25 AVGBAL_X_TP_BASE_RT NUMERIC(38,6) 19
26 AVGBAL_X_FC_ALLOC_RT NUMERIC(38,6) 19
27 AVGBAL_X_ADJ_AVGNET_RT NUMERIC(38,13) 19
28 AVGBALOFFSET_X_ADJ_CUST_RT NUMERIC(38,7) 19
29 AVGBAL_X_BASIS_RT NUMERIC(38,6) 19