FCT_BNK_TERM_DEP_SUMM_MONTHLY_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

OBP Insight for Term Deposits

Synonyms

SDSNZP02_BANK..UBAR_FCT_BNK_TERM_DEP_SUMM_MONTHLY_INSIGHT

Columns
# Name Data Type Length
1 PERIOD_DIM_ID NUMERIC(8,0) 19
2 MONTH_END_DATE DATE 4
3 CURR_MONTH_INC INTEGER 4
4 PRODUCT_LEVEL_4 CHARACTER VARYING(100) 100
5 PRODUCT_LEVEL_5 CHARACTER VARYING(100) 100
6 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
7 PRODUCT_CODE CHARACTER VARYING(30) 30
8 PRODUCT_DESC CHARACTER VARYING(120) 120
9 OFFER_CODE CHARACTER VARYING(30) 30
10 OFFER_DESC CHARACTER VARYING(120) 120
11 ACCOUNT_GROUP CHARACTER VARYING(256) 256
12 ACCOUNT_TYPE CHARACTER VARYING(256) 256
13 TERM_TIER CHARACTER VARYING(150) 150
14 TERM_TIER_SORT BIGINT 8
15 BALANCE_TIER CHARACTER VARYING(17) 17
16 BAL_TIER_SORT BIGINT 8
17 MATURITY_DATE_GROUP CHARACTER VARYING(21) 21
18 COST_CENTRE_CODE CHARACTER VARYING(150) 150
19 COST_CENTRE_NAME CHARACTER VARYING(240) 240
20 BRANCH_NAME CHARACTER VARYING(105) 105
21 REGION CHARACTER VARYING(240) 240
22 REGIONAL_AREA CHARACTER VARYING(240) 240
23 ACCOUNT_DIM_ID BIGINT 8
24 OF_COST_CENTRE_SID BIGINT 8
25 SOURCE_PRODUCT_DIM_ID BIGINT 8
26 MAT_PERIOD_TERM_DEP_DIM_ID NUMERIC(9,0) 19
27 SALES_OFFICER_DIM_ID INTEGER 4
28 SECONDARY_OFFICER_DIM_ID INTEGER 4
29 ACCOUNT_TYPE_DEP_DIM_ID BIGINT 8
30 DEP_BALANCE_TIER_DIM_ID BIGINT 8
31 TERM_TIER_TERM_DEP_DIM_ID BIGINT 8
32 PORTFOLIO_BAL DOUBLE PRECISION 8
33 PORTFOLIO_CNT NUMERIC(38,0) 19
34 WEIGHTED_CUSTOMER_RATE_AMOUNT DOUBLE PRECISION 8
35 CLOSED_ACCOUNT_BAL DOUBLE PRECISION 8
36 CLOSED_ACCOUNT_CNT NUMERIC(38,0) 19
37 INT_ADJUSTMENT DOUBLE PRECISION 8
38 EXPECTED_INT_PAYABLE DOUBLE PRECISION 8
39 EXPECTED_INT_ADJUSTMENT DOUBLE PRECISION 8
40 INT_MISSED_AMOUNT DOUBLE PRECISION 8
41 BROKEN_EARLY_NO_FEE_CNT NUMERIC(38,0) 19