FCT_OBP_TERM_DEP_EV_MTH

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..FCT_OBP_TERM_DEP_EV_MTH_V

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 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 WEIGHTED_CUSTOMER_RATE_AMOUNT DOUBLE PRECISION 8
29 INT_ADJUSTMENT DOUBLE PRECISION 8
30 EXPECTED_INT_PAYABLE DOUBLE PRECISION 8
31 EXPECTED_INT_ADJUSTMENT DOUBLE PRECISION 8
32 INT_MISSED_AMOUNT DOUBLE PRECISION 8
33 FEE_APPLIED_TYPE CHARACTER VARYING(22) 22
34 BROKEN_EARLY_NO_FEE_CNT BIGINT 8
35 CLOSED_ACCOUNT_CNT INTEGER 4
36 PRODUCT_LEVEL_4 CHARACTER VARYING(100) 100
37 PRODUCT_LEVEL_5 CHARACTER VARYING(100) 100
38 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
39 PRODUCT_CODE CHARACTER VARYING(30) 30
40 PRODUCT_DESC CHARACTER VARYING(120) 120
41 OFFER_CODE CHARACTER VARYING(30) 30
42 OFFER_DESC CHARACTER VARYING(120) 120
43 SOURCE_PRODUCT_CODE CHARACTER VARYING(131) 131
44 BALANCE_SHEET_INDICATOR CHARACTER VARYING(9) 9
45 ACCOUNT_GROUP CHARACTER VARYING(256) 256
46 ACCOUNT_TYPE CHARACTER VARYING(256) 256
47 TERM_TIER CHARACTER VARYING(150) 150
48 TERM_TIER_SORT BIGINT 8
49 BALANCE_TIER CHARACTER VARYING(17) 17
50 BAL_TIER_SORT BIGINT 8
51 COST_CENTRE_CODE CHARACTER VARYING(150) 150
52 COST_CENTRE_NAME CHARACTER VARYING(240) 240
53 BRANCH_NAME CHARACTER VARYING(105) 105
54 REGION CHARACTER VARYING(240) 240
55 REGIONAL_AREA CHARACTER VARYING(240) 240
56 ACCOUNT_DIM_ID BIGINT 8
57 OF_COST_CENTRE_SID BIGINT 8
58 SOURCE_PRODUCT_DIM_ID BIGINT 8
59 SALES_OFFICER_DIM_ID INTEGER 4
60 SECONDARY_OFFICER_DIM_ID INTEGER 4
61 ACCOUNT_TYPE_DEP_DIM_ID BIGINT 8
62 DEP_BALANCE_TIER_DIM_ID BIGINT 8
63 TERM_TIER_TERM_DEP_DIM_ID BIGINT 8
64 LAST_RECORDED_PERIOD_DIM_ID BIGINT 8