FCT_OBP_DEPOSIT_WEEKLY_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..FCT_OBP_DEPOSIT_WEEKLY

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 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
7 DEPOSIT_NUMBER DOUBLE PRECISION 8
8 DATE_CLOSED TIMESTAMP 8
9 DATE_OPEN TIMESTAMP 8
10 DATE_RENEW TIMESTAMP 8
11 OPEN_ACCOUNT_CLOSING_BALANCE DOUBLE PRECISION 8
12 CLOSED_ACCOUNT_CLOSING_BALANCE DOUBLE PRECISION 8
13 OPEN_ACCOUNT_COUNT INTEGER 4
14 CLOSED_ACCOUNT_COUNT INTEGER 4
15 SOURCE_SYSTEM_CODE CHARACTER VARYING(6) 6
16 PRODUCT_LEVEL_2 CHARACTER VARYING(100) 100
17 PRODUCT_LEVEL_3 CHARACTER VARYING(100) 100
18 PRODUCT_LEVEL_4 CHARACTER VARYING(100) 100
19 PRODUCT_LEVEL_5 CHARACTER VARYING(100) 100
20 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
21 PRODUCT_CODE CHARACTER VARYING(30) 30
22 PRODUCT_DESC CHARACTER VARYING(120) 120
23 OFFER_CODE CHARACTER VARYING(40) 40
24 OFFER_DESC CHARACTER VARYING(120) 120
25 SOURCE_PRODUCT_CODE CHARACTER VARYING(131) 131
26 BALANCE_SHEET_INDICATOR CHARACTER VARYING(9) 9
27 ACCOUNT_GROUP CHARACTER VARYING(256) 256
28 ACCOUNT_TYPE CHARACTER VARYING(256) 256
29 BALANCE_TIER CHARACTER VARYING(150) 150
30 BAL_TIER_SORT BIGINT 8
31 PRODUCT_SHIFT_DESCRIPTION CHARACTER VARYING(256) 256
32 PRODUCT_SHIFT_SORT CHARACTER VARYING(256) 256
33 PREV_OFFER_CODE CHARACTER VARYING(100) 100
34 PREV_OFFER_DESC CHARACTER VARYING(100) 100
35 COST_CENTRE_CODE CHARACTER VARYING(150) 150
36 COST_CENTRE_NAME CHARACTER VARYING(240) 240
37 BRANCH_NAME CHARACTER VARYING(105) 105
38 REGION CHARACTER VARYING(240) 240
39 REGIONAL_AREA CHARACTER VARYING(240) 240
40 ACCOUNT_STATUS_CODE CHARACTER VARYING(40) 40
41 ACCOUNT_DIM_ID BIGINT 8
42 OF_COST_CENTRE_SID BIGINT 8
43 CLOSING_SOURCE_PRODUCT_DIM_ID BIGINT 8
44 OPENING_SOURCE_PRODUCT_DIM_ID BIGINT 8
45 OPEN_ACCOUNT_TYPE_DIM_ID BIGINT 8
46 DEP_BALANCE_TIER_DIM_ID BIGINT 8
47 ACCOUNT_STATUS_DIM_ID BIGINT 8
48 PRODUCT_SHIFT_DEP_DIM_ID BIGINT 8
49 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
50 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
51 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
52 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8