SDW_TSDMF_WEALTH_SALES_RPT_H

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 SALES_EVENT_BTCH_PERIOD_DIM_ID BIGINT 8
3 SALES_EVENT_BTCH_DATE TIMESTAMP 8
4 SOURCE_PRODUCT_DIM_ID BIGINT 8
5 SOURCE_PRODUCT_CODE CHARACTER VARYING(24) 24
6 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
7 WEALTH_REG_DIV_CHAN_DIM_ID BIGINT 8
8 WEALTH_TRANSACTION_DIM_ID BIGINT 8
9 WEALTH_SALES_OFFICER_DIM_ID BIGINT 8
10 WEALTH_SALES_OFFICER_CODE CHARACTER VARYING(10) 10
11 POLICY_NUMBER CHARACTER VARYING(9) 9
12 CLIENT_NAME CHARACTER VARYING(20) 20
13 SALES_OFFICER_DIM_ID BIGINT 8
14 SALES_OFFICER_ROLE_DIM_ID BIGINT 8
15 COST_CENTRE_DIM_ID BIGINT 8
16 PREMIUMS CHARACTER VARYING(20) 20
17 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
18 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
19 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
20 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8