FCT_BNK_COEX_TD_WEEKLY

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

INSNZP02_BANK..FCT_BNK_COEX_TD_WEEKLY_INSIGHT

Columns
# Name Data Type Length
1 ACCOUNT_DIM_ID BIGINT 8
2 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
3 BANK_STATES_LEVEL_02_NAME CHARACTER VARYING(240) 240
4 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
5 SOURCE_PRODUCT_CODE CHARACTER VARYING(131) 131
6 ACCOUNT_OPENING_DATE TIMESTAMP 8
7 ACCOUNT_CLOSURE_DATE TIMESTAMP 8
8 DEPOSIT_OPENING_DATE TIMESTAMP 8
9 DEPOSIT_CLOSURE_DATE TIMESTAMP 8
10 CURRENT_ISSUE_DATE TIMESTAMP 8
11 MATURITY_DATE TIMESTAMP 8
12 PERIOD_DIM_ID BIGINT 8
13 PRODUCT_LEVEL_1_DESCRIPTION CHARACTER VARYING(100) 100
14 PRODUCT_LEVEL_2_DESCRIPTION CHARACTER VARYING(100) 100
15 PRODUCT_LEVEL_3_DESCRIPTION CHARACTER VARYING(100) 100
16 PRODUCT_LEVEL_4_DESCRIPTION CHARACTER VARYING(100) 100
17 PRODUCT_LEVEL_5_DESCRIPTION CHARACTER VARYING(100) 100
18 OF_COST_CENTRE_SID BIGINT 8
19 COST_CENTRE_NAME CHARACTER VARYING(240) 240
20 COST_CENTRE_CODE CHARACTER VARYING(150) 150
21 COST_CENTRE_LEVEL_01_NAME CHARACTER VARYING(240) 240
22 COST_CENTRE_LEVEL_02_NAME CHARACTER VARYING(240) 240
23 COST_CENTRE_LEVEL_03_NAME CHARACTER VARYING(240) 240
24 COST_CENTRE_LEVEL_04_NAME CHARACTER VARYING(240) 240
25 COST_CENTRE_LEVEL_05_NAME CHARACTER VARYING(240) 240
26 COST_CENTRE_LEVEL_06_NAME CHARACTER VARYING(240) 240
27 SOURCE CHARACTER VARYING(3) 3
28 OPEN_ACCOUNT_COUNT INTEGER 4
29 CLOSED_ACCOUNT_COUNT INTEGER 4
30 OPEN_ACCOUNT_CLOSING_BALANCE DOUBLE PRECISION 8
31 CLOSED_ACCOUNT_CLOSING_BALANCE DOUBLE PRECISION 8
32 WEIGHTED_CUSTOMER_RATE_AMOUNT DOUBLE PRECISION 8
33 EXPECTED_INT_PAYABLE DOUBLE PRECISION 8
34 ANNUAL_INT_RATE DOUBLE PRECISION 8
35 EXPECTED_TERM_DAYS BIGINT 8
36 TERM_TIER CHARACTER VARYING(150) 150
37 TERM_TIER_SORT BIGINT 8
38 BALANCE_TIER CHARACTER VARYING(17) 17
39 BAL_TIER_SORT BIGINT 8
40 EXPECTED_INT_ADJUSTMENT DOUBLE PRECISION 8
41 INT_ADJUSTMENT DOUBLE PRECISION 8
42 INT_MISSED_AMOUNT DOUBLE PRECISION 8
43 SALES_OFFICER CHARACTER VARYING(50) 50
44 SECONDARY_OFFICER CHARACTER VARYING(20) 20
45 TERM_MNTHS DOUBLE PRECISION 8
46 ACCOUNT_TYPE CHARACTER VARYING(256) 256
47 ACCOUNT_GROUP CHARACTER VARYING(256) 256
48 MATURITY_DATE_GROUP CHARACTER VARYING(21) 21
49 MATURITY_FINANCIAL_YEAR CHARACTER VARYING(7) 7
50 MATURITY_FINANCIAL_MONTH CHARACTER VARYING(6) 6
51 NEW_ACCOUNT_CATEGORY CHARACTER VARYING(18) 18