FCT_OBP_UBAR_DEPOSIT_DAILY

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..FCT_OBP_UBAR_DEPOSIT_DAILY_V

Target Objects (CTAS)

INSNZP05_BANK..FCT_OBP_UBAR_DEPOSIT_DAILY_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 ACCOUNT_OPENING_DATE TIMESTAMP 8
6 ACCOUNT_CLOSURE_DATE TIMESTAMP 8
7 PERIOD_DIM_ID BIGINT 8
8 OPENING_SOURCE_PRODUCT_CODE CHARACTER VARYING(131) 131
9 OPENING_PRODUCT_LEVEL_1_DESCRIPTION CHARACTER VARYING(100) 100
10 OPENING_PRODUCT_LEVEL_2_DESCRIPTION CHARACTER VARYING(100) 100
11 OPENING_PRODUCT_LEVEL_3_DESCRIPTION CHARACTER VARYING(100) 100
12 OPENING_PRODUCT_LEVEL_4_DESCRIPTION CHARACTER VARYING(100) 100
13 OPENING_PRODUCT_LEVEL_5_DESCRIPTION CHARACTER VARYING(100) 100
14 CLOSING_SOURCE_PRODUCT_CODE CHARACTER VARYING(131) 131
15 CLOSING_PRODUCT_LEVEL_1_DESCRIPTION CHARACTER VARYING(100) 100
16 CLOSING_PRODUCT_LEVEL_2_DESCRIPTION CHARACTER VARYING(100) 100
17 CLOSING_PRODUCT_LEVEL_3_DESCRIPTION CHARACTER VARYING(100) 100
18 CLOSING_PRODUCT_LEVEL_4_DESCRIPTION CHARACTER VARYING(100) 100
19 CLOSING_PRODUCT_LEVEL_5_DESCRIPTION CHARACTER VARYING(100) 100
20 OF_COST_CENTRE_SID BIGINT 8
21 COST_CENTRE_NAME CHARACTER VARYING(240) 240
22 ORACLE_COST_CENTRE_CODE CHARACTER VARYING(150) 150
23 COST_CENTRE_LEVEL_01_NAME CHARACTER VARYING(240) 240
24 COST_CENTRE_LEVEL_02_NAME CHARACTER VARYING(240) 240
25 COST_CENTRE_LEVEL_03_NAME CHARACTER VARYING(240) 240
26 COST_CENTRE_LEVEL_04_NAME CHARACTER VARYING(240) 240
27 COST_CENTRE_LEVEL_05_NAME CHARACTER VARYING(240) 240
28 COST_CENTRE_LEVEL_06_NAME CHARACTER VARYING(240) 240
29 BANK_CHANNELS_LEVEL_02_NAME CHARACTER VARYING(240) 240
30 BANK_CHANNELS_LEVEL_03_NAME CHARACTER VARYING(240) 240
31 OPEN_ACCOUNT_COUNT INTEGER 4
32 CLOSED_ACCOUNT_COUNT INTEGER 4
33 OPEN_ACCOUNT_CLOSING_BALANCE DOUBLE PRECISION 8
34 CLOSED_ACCOUNT_CLOSING_BALANCE DOUBLE PRECISION 8
35 SOURCE CHARACTER VARYING(3) 3
36 BALANCE_TIER CHARACTER VARYING(150) 150
37 BALANCE_TIER_SORT BIGINT 8
38 ACCOUNT_TYPE_DESCRIPTION CHARACTER VARYING(15) 15
39 ACCOUNT_GROUP CHARACTER VARYING(9) 9
40 PRODUCT_SHIFT_DESCRIPTION CHARACTER VARYING(7) 7