FCT_BNK_COEX_TD_DAILY_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..FCT_BNK_COEX_TD_DAILY

Synonyms

INSNZP01_BANK..SYN_FCT_BNK_COEX_TD_DAILY_INSIGHT

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