FCT_BNK_DISBURSEMENT_RPT_H_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

MERGED extract used by the Cost centre Sales Summary to provide reporting for front line staff, contains weekly, MTD, QTD & FYTD details

Columns
# Name Data Type Length
1 PERIOD_DIM_ID INTEGER 4
2 ACCOUNT_DIM_ID BIGINT 8
3 SOURCE_PRODUCT_DIM_ID BIGINT 8
4 SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
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 INTEGER 4
22 SALES_OFFICER_ROLE_DIM_ID BIGINT 8
23 HOGAN_SALES_OFFICER_UID CHARACTER VARYING(254) 254
24 HOGAN_SALES_OFFICER_UID_8WK CHARACTER VARYING(254) 254
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 DOUBLE PRECISION 8
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 DOUBLE PRECISION 8
36 MARGIN_RATE_VALUE DOUBLE PRECISION 8
37 CARDED_RATE_VALUE DOUBLE PRECISION 8
38 LINE_OF_CREDIT_LIMIT_RULE_FLAG CHARACTER VARYING(5) 5
39 SDW_IGNITE_SOURCE CHARACTER VARYING(1) 1
40 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
41 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
42 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
43 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8