SDW_TSDMF_WAS_DISBURSEMENT

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 SOURCE_PRODUCT_DIM_ID BIGINT 8
4 SOURCE_PRODUCT_CODE CHARACTER VARYING(24) 24
5 BALANCE_SHEET_INDICAT CHARACTER VARYING(20) 20
6 COST_CENTRE_DIM_ID_8WK BIGINT 8
7 COST_CENTRE_DIM_ID BIGINT 8
8 BDM_DIM_ID_8WK BIGINT 8
9 BDM_DIM_ID BIGINT 8
10 TRANSACTION_DIM_ID BIGINT 8
11 TRANSACTION_DIM_ID_TYP2 BIGINT 8
12 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
13 LOW_DOC_DIM_ID BIGINT 8
14 MARGIN_PERCENT_BAND_DIM_ID BIGINT 8
15 MARGIN_CODE_MATRIX_DIM_ID BIGINT 8
16 DISBURSEMENT_AMOUNT NUMERIC(14,2) 19
17 CUSTOMER_RATE NUMERIC(8,5) 19
18 MARGIN_RATE NUMERIC(8,5) 19
19 CARDED_RATE NUMERIC(8,5) 19
20 CUSTOMER_RATE_VALUE NUMERIC(14,2) 19
21 MARGIN_RATE_VALUE NUMERIC(14,2) 19
22 CARDED_RATE_VALUE NUMERIC(14,2) 19
23 DISBURSEMENT_STATUS_DIM_ID BIGINT 8
24 HOGAN_SALES_OFFICER_DIM_ID BIGINT 8
25 HOGAN_SALES_OFFICER_DIM_ID_8WK BIGINT 8
26 EFFECTIVE_PERIOD_DIM_ID BIGINT 8
27 SALES_OFFICER_CODE CHARACTER VARYING(24) 24
28 SALES_OFFICER_ROLE_CODE CHARACTER VARYING(30) 30
29 SALES_OFFICER_COST_CENTRE_CODE CHARACTER VARYING(24) 24
30 SOURCE_START_DATE TIMESTAMP 8
31 SOURCE_END_DATE TIMESTAMP 8
32 SALES_OFFICER_NAME CHARACTER VARYING(256) 256
33 WEALTH_CLIENT_ID CHARACTER VARYING(12) 12
34 HOGAN_SALES_OFFICER_ID CHARACTER VARYING(12) 12
35 HOGAN_SALES_OFFICER_UID CHARACTER VARYING(12) 12
36 COST_CENTRE_CHANGE_FLAG CHARACTER VARYING(1) 1
37 SALES_OFFICER_CHANGE_FLAG CHARACTER VARYING(1) 1
38 ORIGINAL_INDICATOR NUMERIC(38,0) 19
39 UPDATE_INDICATOR NUMERIC(38,0) 19
40 CURRENT_RECORD_FLAG CHARACTER VARYING(1) 1
41 LINE_OF_CREDIT_LIMIT_RULE_FLAG CHARACTER VARYING(5) 5
42 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
43 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
44 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
45 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8