FCT_BNK_TERM_DEP_EV_WEEKLY_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

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

Synonyms

SDSNZP02_BANK..UBAR_FCT_BNK_TERM_DEP_EV_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 BASE_RATE DOUBLE PRECISION 8
18 UDM_RATE DOUBLE PRECISION 8
19 NET_RATES DOUBLE PRECISION 8
20 RATE_TYPE CHARACTER VARYING(8) 8
21 AUTO_ROLL_TYPE CHARACTER VARYING(13) 13
22 EXPECTED_TERM_DAYS INTEGER 4
23 ACTUAL_TERM_DAYS INTEGER 4
24 EXPECTED_TO_ACTUAL_TERM_PCT NUMERIC(35,2) 19
25 BREAKAGE_RATIO NUMERIC(14,2) 19
26 TERM_VARIATION INTEGER 4
27 OPENING_DEPOSIT_AMOUNT DOUBLE PRECISION 8
28 INT_ADJUSTMENT DOUBLE PRECISION 8
29 EXPECTED_INT_PAYABLE DOUBLE PRECISION 8
30 EXPECTED_INT_ADJUSTMENT DOUBLE PRECISION 8
31 INT_MISSED_AMOUNT DOUBLE PRECISION 8
32 FEE_APPLIED_TYPE CHARACTER VARYING(22) 22
33 BROKEN_EARLY_NO_FEE_CNT BIGINT 8
34 CLOSED_ACCOUNT_CNT INTEGER 4
35 PRODUCT_LEVEL_4 CHARACTER VARYING(100) 100
36 PRODUCT_LEVEL_5 CHARACTER VARYING(100) 100
37 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
38 PRODUCT_CODE CHARACTER VARYING(30) 30
39 PRODUCT_DESC CHARACTER VARYING(120) 120
40 OFFER_CODE CHARACTER VARYING(30) 30
41 OFFER_DESC CHARACTER VARYING(120) 120
42 SOURCE_PRODUCT_CODE CHARACTER VARYING(131) 131
43 BALANCE_SHEET_INDICATOR CHARACTER VARYING(9) 9
44 ACCOUNT_GROUP CHARACTER VARYING(256) 256
45 ACCOUNT_TYPE CHARACTER VARYING(256) 256
46 TERM_TIER CHARACTER VARYING(150) 150
47 TERM_TIER_SORT BIGINT 8
48 BALANCE_TIER CHARACTER VARYING(17) 17
49 BAL_TIER_SORT BIGINT 8
50 COST_CENTRE_CODE CHARACTER VARYING(150) 150
51 COST_CENTRE_NAME CHARACTER VARYING(240) 240
52 BRANCH_NAME CHARACTER VARYING(105) 105
53 REGION CHARACTER VARYING(240) 240
54 REGIONAL_AREA CHARACTER VARYING(240) 240
55 ACCOUNT_DIM_ID BIGINT 8
56 OF_COST_CENTRE_SID BIGINT 8
57 SOURCE_PRODUCT_DIM_ID BIGINT 8
58 SALES_OFFICER_DIM_ID INTEGER 4
59 SECONDARY_OFFICER_DIM_ID INTEGER 4
60 ACCOUNT_TYPE_DEP_DIM_ID BIGINT 8
61 DEP_BALANCE_TIER_DIM_ID BIGINT 8
62 TERM_TIER_TERM_DEP_DIM_ID BIGINT 8
63 LAST_RECORDED_PERIOD_DIM_ID BIGINT 8