SDW_TSDMW_ACCOUNTS_MGRT_CLMS

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..ATOCRS_SDW_TSDMW_ACCOUNTS_MGRT_CLMS

SDSNZP02_BANK..BNKNIC_SDW_TSDMW_ACCOUNTS_MGRT_CLMS

SDSNZP02_BANK..EFS_SDW_TSDMW_ACCOUNTS_MGRT_CLMS

SDSNZP02_BANK..NROD_SDW_TSDMW_ACCOUNTS_MGRT_CLMS

SDSNZP02_BANK..QRMCGN_SDW_TSDMW_ACCOUNTS_MGRT_CLMS

SDSNZP02_BANK..UBAR_SDW_TSDMW_ACCOUNTS_MGRT_CLMS

SDSNZP05_BANK..CBP_SDW_TSDMW_ACCOUNTS_MGRT_CLMS

Columns
# Name Data Type Length
1 FROM_ACCOUNT_DIM_ID BIGINT 8
2 TO_ACCOUNT_DIM_ID BIGINT 8
3 FROM_ACCOUNT_NUMBER CHARACTER VARYING(20) 20
4 TO_ACCOUNT_NUMBER CHARACTER VARYING(20) 20
5 FROM_SOURCE_SYSTEM_CODE CHARACTER VARYING(12) 12
6 TO_SOURCE_SYSTEM_CODE CHARACTER VARYING(12) 12
7 FROM_PRODUCT_CODE CHARACTER VARYING(12) 12
8 TO_PRODUCT_CODE CHARACTER VARYING(12) 12
9 FROM_SUB_PRODUCT_CODE CHARACTER VARYING(12) 12
10 TO_SUB_PRODUCT_CODE CHARACTER VARYING(12) 12
11 LEAD_NUMBER BIGINT 8
12 FROM_COST_CENTRE_DIM_ID BIGINT 8
13 TO_COST_CENTRE_DIM_ID BIGINT 8
14 FROM_BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
15 TO_BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
16 FROM_SOURCE_PRODUCT_DIM_ID BIGINT 8
17 TO_SOURCE_PRODUCT_DIM_ID BIGINT 8
18 FROM_SOURCE_PRODUCT_LVL_DIM_ID BIGINT 8
19 TO_SOURCE_PRODUCT_LVL_DIM_ID BIGINT 8
20 FROM_COST_CENTRE_LVLS_DIM_ID BIGINT 8
21 TO_COST_CENTRE_LVLS_DIM_ID BIGINT 8
22 FROM_BDM_DIM_ID BIGINT 8
23 TO_BDM_DIM_ID BIGINT 8
24 FROM_PER_INV_USG_TP_SUM_DIM_ID BIGINT 8
25 TO_PER_INV_USG_TP_SUM_DIM_ID BIGINT 8
26 FROM_OWNER_OCCUPIED_INVESTMENT CHARACTER VARYING(24) 24
27 TO_OWNER_OCCUPIED_INVESTMENT CHARACTER VARYING(24) 24
28 MIGRATION_DATE DATE 4
29 HOGAN_DAY_FIRST DATE 4
30 START_OF_MIGRATION_MONTH DATE 4
31 LOAD_DATE DATE 4
32 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
33 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
34 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
35 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8