SDW_TSDSA_DEPOSIT_MONTHLY

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 ACCOUNT_DIM_ID BIGINT 8
3 CUSTOMER_DIM_ID BIGINT 8
4 OPENING_SOURCE_PRODUCT_DIM_ID BIGINT 8
5 CLOSING_SOURCE_PRODUCT_DIM_ID BIGINT 8
6 OF_COST_CENTRE_SID BIGINT 8
7 ACCOUNT_STATUS_DIM_ID BIGINT 8
8 DEP_BALANCE_TIER_DIM_ID BIGINT 8
9 OPEN_ACCOUNT_TYPE_DIM_ID BIGINT 8
10 OPEN_ACCOUNT_CLOSING_BALANCE NUMERIC(14,2) 19
11 CLOSED_ACCOUNT_CLOSING_BALANCE NUMERIC(14,2) 19
12 OPEN_ACCOUNT_COUNT BIGINT 8
13 CLOSED_ACCOUNT_COUNT BIGINT 8
14 PRODUCT_SHIFT_DEP_DIM_ID BIGINT 8
15 SOURCE_SYSTEM_CODE CHARACTER VARYING(12) 12
16 ACCOUNT_NUMBER CHARACTER VARYING(20) 20
17 DATE_CLOSED TIMESTAMP 8
18 DATE_OPEN TIMESTAMP 8
19 DATE_RENEW TIMESTAMP 8
20 DATE_CLOSED_FINAL TIMESTAMP 8
21 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
22 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
23 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
24 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8