FCT_BNK_TERM_DEP_WEEKLY_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

OBP Insight for active Term Deposit Weekly data; Possible source for cognos TD mart for OBP data?

Synonyms

SDSNZP02_BANK..UBAR_FCT_BNK_TERM_DEP_WEEKLY_INSIGHT

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 WEEK_END_DATE TIMESTAMP 8
3 CURR_WEEK_INC INTEGER 4
4 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
5 DEPOSIT_NUMBER DOUBLE PRECISION 8
6 DEPOSIT_OPENING_DATE TIMESTAMP 8
7 DEPOSIT_CLOSURE_DATE TIMESTAMP 8
8 ACCOUNT_OPENING_DATE TIMESTAMP 8
9 ACCOUNT_CLOSURE_DATE TIMESTAMP 8
10 CURRENT_ISSUE_DATE TIMESTAMP 8
11 MATURITY_DATE TIMESTAMP 8
12 DEPOSIT_TERM_YEARS DOUBLE PRECISION 8
13 DEPOSIT_TERM_MNTHS DOUBLE PRECISION 8
14 DEPOSIT_TERM_DAYS DOUBLE PRECISION 8
15 TERM_MNTHS DOUBLE PRECISION 8
16 ANNUAL_INT_RATE DOUBLE PRECISION 8
17 BALANCE DOUBLE PRECISION 8
18 BASE_RATE DOUBLE PRECISION 8
19 UDM_RATE DOUBLE PRECISION 8
20 NET_RATES DOUBLE PRECISION 8
21 RATE_TYPE CHARACTER VARYING(8) 8
22 EXPECTED_TERM_DAYS INTEGER 4
23 WEIGHTED_CUSTOMER_RATE_AMOUNT DOUBLE PRECISION 8
24 CURRENT_EXPECTED_INT_PAYABLE DOUBLE PRECISION 8
25 PORTFOLIO_CNT INTEGER 4
26 NEW_DEPOSIT_BAL DOUBLE PRECISION 8
27 NEW_DEPOSIT_CNT INTEGER 4
28 REGULAR_DEPOSIT_BAL DOUBLE PRECISION 8
29 REGULAR_DEPOSIT_CNT INTEGER 4
30 PRODUCT_LEVEL_4 CHARACTER VARYING(100) 100
31 PRODUCT_LEVEL_5 CHARACTER VARYING(100) 100
32 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
33 PRODUCT_CODE CHARACTER VARYING(30) 30
34 PRODUCT_DESC CHARACTER VARYING(120) 120
35 SOURCE_PRODUCT_CODE CHARACTER VARYING(131) 131
36 BALANCE_SHEET_INDICATOR CHARACTER VARYING(9) 9
37 OFFER_CODE CHARACTER VARYING(30) 30
38 OFFER_DESC CHARACTER VARYING(120) 120
39 ACCOUNT_GROUP CHARACTER VARYING(256) 256
40 ACCOUNT_TYPE CHARACTER VARYING(256) 256
41 TERM_TIER CHARACTER VARYING(150) 150
42 TERM_TIER_SORT BIGINT 8
43 BALANCE_TIER CHARACTER VARYING(17) 17
44 BAL_TIER_SORT BIGINT 8
45 MATURITY_DATE_GROUP CHARACTER VARYING(21) 21
46 MATURITY_FINANCIAL_YEAR CHARACTER VARYING(203) 203
47 MATURITY_FINANCIAL_MONTH CHARACTER VARYING(200) 200
48 COST_CENTRE_CODE CHARACTER VARYING(150) 150
49 COST_CENTRE_NAME CHARACTER VARYING(240) 240
50 BRANCH_NAME CHARACTER VARYING(105) 105
51 REGION CHARACTER VARYING(240) 240
52 REGIONAL_AREA CHARACTER VARYING(240) 240
53 ACCOUNT_DIM_ID BIGINT 8
54 OF_COST_CENTRE_SID BIGINT 8
55 SOURCE_PRODUCT_DIM_ID BIGINT 8
56 MAT_PERIOD_TERM_DEP_DIM_ID NUMERIC(8,0) 19
57 SALES_OFFICER_DIM_ID INTEGER 4
58 SECONDARY_OFFICER_DIM_ID INTEGER 4
59 ACCOUNT_TYPE_DEP_DIM_ID BIGINT 8
60 DEP_BALANCE_TIER_DIM_ID BIGINT 8
61 TERM_TIER_TERM_DEP_DIM_ID BIGINT 8
62 LAST_RECORDED_PERIOD_DIM_ID BIGINT 8