FCT_BNK_DEPOSIT_SUMM_WEEKLY_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

OBP Monthly extract with select Deposit details summarised with weekly data

Columns
# Name Data Type Length
1 WEEK_END_PD_DIM_ID BIGINT 8
2 PERIOD_DIM_ID BIGINT 8
3 WEEK_END_DATE TIMESTAMP 8
4 PREV_WEEK_END_DATE TIMESTAMP 8
5 CURR_WEEK_INC INTEGER 4
6 PRODUCT_LEVEL_2 CHARACTER VARYING(100) 100
7 PRODUCT_LEVEL_3 CHARACTER VARYING(100) 100
8 PRODUCT_LEVEL_4 CHARACTER VARYING(100) 100
9 PRODUCT_LEVEL_5 CHARACTER VARYING(100) 100
10 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
11 PRODUCT_CODE CHARACTER VARYING(30) 30
12 PRODUCT_DESC CHARACTER VARYING(120) 120
13 OFFER_CODE CHARACTER VARYING(40) 40
14 OFFER_DESC CHARACTER VARYING(120) 120
15 SOURCE_PRODUCT_CODE CHARACTER VARYING(131) 131
16 BALANCE_SHEET_INDICATOR CHARACTER VARYING(9) 9
17 ACCOUNT_GROUP CHARACTER VARYING(256) 256
18 ACCOUNT_TYPE CHARACTER VARYING(256) 256
19 BALANCE_TIER CHARACTER VARYING(150) 150
20 BAL_TIER_SORT BIGINT 8
21 PRODUCT_SHIFT_DESCRIPTION CHARACTER VARYING(256) 256
22 PRODUCT_SHIFT_SORT CHARACTER VARYING(256) 256
23 COST_CENTRE_CODE CHARACTER VARYING(150) 150
24 COST_CENTRE_NAME CHARACTER VARYING(240) 240
25 BRANCH_NAME CHARACTER VARYING(105) 105
26 REGION CHARACTER VARYING(240) 240
27 REGIONAL_AREA CHARACTER VARYING(240) 240
28 ACCOUNT_STATUS_CODE CHARACTER VARYING(40) 40
29 ACCOUNT_DIM_ID BIGINT 8
30 OF_COST_CENTRE_SID BIGINT 8
31 CLOSING_SOURCE_PRODUCT_DIM_ID BIGINT 8
32 OPENING_SOURCE_PRODUCT_DIM_ID BIGINT 8
33 OPEN_ACCOUNT_TYPE_DIM_ID BIGINT 8
34 DEP_BALANCE_TIER_DIM_ID BIGINT 8
35 ACCOUNT_STATUS_DIM_ID BIGINT 8
36 PRODUCT_SHIFT_DEP_DIM_ID BIGINT 8
37 OPEN_ACCOUNT_CLOSING_BALANCE DOUBLE PRECISION 8
38 CLOSED_ACCOUNT_CLOSING_BALANCE DOUBLE PRECISION 8
39 OPEN_ACCOUNT_COUNT NUMERIC(38,0) 19
40 CLOSED_ACCOUNT_COUNT NUMERIC(38,0) 19