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