FCT_SDW_TSDMF_DISBURSEMENT_RPT_H

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

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_INDICATOR CHARACTER VARYING(20) 20
6 COST_CENTRE_DIM_ID_8WK BIGINT 8
7 COST_CENTRE_DIM_ID BIGINT 8
8 SALES_OFFICER_COST_CNTR_DIM_ID BIGINT 8
9 DISBURSEMENT_COST_CNTR_DIM_ID BIGINT 8
10 BDM_DIM_ID_8WK BIGINT 8
11 BDM_DIM_ID BIGINT 8
12 TRANSACTION_DIM_ID BIGINT 8
13 TRANSACTION_TYP2_DIM_ID BIGINT 8
14 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
15 LOW_DOC_DIM_ID BIGINT 8
16 MARGIN_PERCENT_BAND_DIM_ID BIGINT 8
17 MARGIN_CODE_MATRIX_DIM_ID BIGINT 8
18 DISBURSEMENT_STATUS_DIM_ID BIGINT 8
19 HOGAN_SALES_OFFICER_DIM_ID BIGINT 8
20 HOGAN_SALES_OFFICER_DIM_ID_8WK BIGINT 8
21 EFFECTIVE_PERIOD_DIM_ID BIGINT 8
22 SALES_OFFICER_ROLE_DIM_ID BIGINT 8
23 HOGAN_SALES_OFFICER_UID CHARACTER VARYING(12) 12
24 HOGAN_SALES_OFFICER_UID_8WK CHARACTER VARYING(12) 12
25 DISBURSEMENT_PERIOD_DIM_ID BIGINT 8
26 COST_CENTRE_CHANGE_FLAG CHARACTER VARYING(1) 1
27 SALES_OFFICER_CHANGE_FLAG CHARACTER VARYING(1) 1
28 ORIGINAL_INDICATOR NUMERIC(38,0) 19
29 UPDATE_INDICATOR NUMERIC(38,0) 19
30 CURRENT_FLAG CHARACTER VARYING(1) 1
31 DISBURSEMENT_AMOUNT NUMERIC(14,2) 19
32 CUSTOMER_RATE NUMERIC(8,5) 19
33 MARGIN_RATE NUMERIC(8,5) 19
34 CARDED_RATE NUMERIC(8,5) 19
35 CUSTOMER_RATE_VALUE NUMERIC(14,2) 19
36 MARGIN_RATE_VALUE NUMERIC(14,2) 19
37 CARDED_RATE_VALUE NUMERIC(14,2) 19
38 LINE_OF_CREDIT_LIMIT_RULE_FLAG CHARACTER VARYING(5) 5
39 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
40 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
41 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
42 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8