FCT_BNK_ROFT_FLOW_OF_FUNDS_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

OBP table grouping transactions into flow of funds or primary buckets for both weekly & monthly data at accout grain

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 OPENING_PERIOD_DIM_ID INTEGER 4
3 CLOSING_PERIOD_DIM_ID INTEGER 4
4 ACCOUNT_NUMBER CHARACTER VARYING(128) 128
5 ACCOUNT_DIM_ID BIGINT 8
6 CATEGORY CHARACTER VARYING(256) 256
7 SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
8 BUSINESS_LENDING_SEGMENT_L2 CHARACTER VARYING(240) 240
9 BUSINESS_LENDING_SEGMENT_L3 CHARACTER VARYING(240) 240
10 ACCOUNT_TITLE CHARACTER VARYING(300) 300
11 PRIMARY_OBP_PARTY_ID CHARACTER VARYING(40) 40
12 ACCOUNT_STATUS_CODE CHARACTER VARYING(50) 50
13 APPROVED_AMOUNT DOUBLE PRECISION 8
14 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
15 PRODUCT_ID CHARACTER VARYING(30) 30
16 OFFER_ID CHARACTER VARYING(30) 30
17 SOURCE_PRODUCT_DESCRIPTION CHARACTER VARYING(358) 358
18 PRODUCT_DESCRIPTION CHARACTER VARYING(120) 120
19 OFFER_DESCRIPTION CHARACTER VARYING(120) 120
20 PURPOSE CHARACTER VARYING(200) 200
21 SUB_PURPOSE CHARACTER VARYING(200) 200
22 OWNER_OCCUPIED CHARACTER VARYING(14) 14
23 BROKER_ID CHARACTER VARYING(20) 20
24 INTRODUCER_ID CHARACTER VARYING(20) 20
25 APPLICATION_CREATED_BY CHARACTER VARYING(254) 254
26 APPLICATION_CHANNEL CHARACTER VARYING(10) 10
27 APPLICATION_CHANNEL_SOURCE CHARACTER VARYING(8) 8
28 APPLICATION_CHANNEL_DESCRIPTION CHARACTER VARYING(400) 400
29 REQUESTED_AMOUNT DOUBLE PRECISION 8
30 APPLICATION_ID CHARACTER VARYING(50) 50
31 FACILITY_ID CHARACTER VARYING(40) 40
32 BORROWING_ENTITY_ID CHARACTER VARYING(16) 16
33 DISBURSEMENT_COUNT BIGINT 8
34 FIRST_DISBURSEMENT_DATE TIMESTAMP 8
35 TERM_MONTHS BIGINT 8
36 MATURITY_DATE TIMESTAMP 8
37 HAS_HARDSHIP_RELIEF CHARACTER(1) 1
38 CREDIT_RISK_RATING_CODE CHARACTER VARYING(40) 40
39 INTEREST_RATE_TYPE CHARACTER VARYING(30) 30
40 FIXED_TERM_MONTHS DOUBLE PRECISION 8
41 FIXED_PERIOD_END_DATE TIMESTAMP 8
42 CURRENT_INTEREST_RATE DOUBLE PRECISION 8
43 LOAN_REPAYMENT_TYPE CHARACTER VARYING(128) 128
44 BASE_RATE NUMERIC(8,5) 19
45 CUSTOMER_RATE DOUBLE PRECISION 8
46 BILL_FREQUENCY CHARACTER VARYING(30) 30
47 PAYOUT_REASON_CODE CHARACTER VARYING(401) 401
48 PRIMARY_REASON_FOR_CLOSURE CHARACTER VARYING(200) 200
49 SECONDARY_REASON_FOR_CLOSURE CHARACTER VARYING(200) 200
50 ADD_LOAN_FLAG CHARACTER VARYING(1) 1
51 LOAN_TO_VALUE_RATIO DOUBLE PRECISION 8
52 GROUP_LVR_MV DOUBLE PRECISION 8
53 MARGIN_RATE NUMERIC(8,5) 19
54 BRANCH_NAME CHARACTER VARYING(105) 105
55 OF_COST_CENTRE_SID BIGINT 8
56 COST_CENTRE_CODE CHARACTER VARYING(150) 150
57 COST_CENTRE_NAME CHARACTER VARYING(240) 240
58 REGION CHARACTER VARYING(240) 240
59 NEXT_DUE_AMT DOUBLE PRECISION 8
60 STATE CHARACTER VARYING(3) 3
61 LOAN_VALUE_TIER CHARACTER VARYING(10) 10
62 DISBURSEMENT_STATUS CHARACTER VARYING(1) 1
63 LVR_GROUP CHARACTER VARYING(9) 9
64 CLOSING_BALANCE DOUBLE PRECISION 8
65 PREV_CLOSING_BALANCE DOUBLE PRECISION 8
66 GROWTH NUMERIC(35,2) 19
67 PORTFOLIO DOUBLE PRECISION 8
68 DISBURSEMENT DOUBLE PRECISION 8
69 INTEREST DOUBLE PRECISION 8
70 PAYOUTS DOUBLE PRECISION 8
71 INFLOW DOUBLE PRECISION 8
72 OUTFLOW DOUBLE PRECISION 8
73 REPAYMENT_EXCESSES DOUBLE PRECISION 8
74 REPAYMENT_SHORTFALL DOUBLE PRECISION 8
75 REPAYMENTS DOUBLE PRECISION 8
76 NET_OTHER DOUBLE PRECISION 8
77 RUN_OFF DOUBLE PRECISION 8
78 CASH_BACK DOUBLE PRECISION 8
79 FEES DOUBLE PRECISION 8
80 INSURANCE DOUBLE PRECISION 8
81 NET_TRANSFER DOUBLE PRECISION 8
82 UNCLASSIFED DOUBLE PRECISION 8
83 WRITE_OFF DOUBLE PRECISION 8
84 EXTERNAL_REFINANCE DOUBLE PRECISION 8
85 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
86 MARGIN_PCT CHARACTER VARYING(1) 1
87 TOTAL_DISCOUNT CHARACTER VARYING(1) 1
88 INT_DIS_MARGIN_RATE DOUBLE PRECISION 8
89 INT_DIS_LOAN_AMT DOUBLE PRECISION 8
90 INT_PAYO_MARGIN_RATE DOUBLE PRECISION 8
91 INT_PAYO_LOANT_AMT DOUBLE PRECISION 8
92 INT_REPAY_MARGIN_RATE DOUBLE PRECISION 8
93 INT_REPAY_LOANT_AMT DOUBLE PRECISION 8
94 INT_INTER_MARGIN_RATE DOUBLE PRECISION 8
95 INT_INTER_LOANT_AMT DOUBLE PRECISION 8
96 INT_CASHB_MARGIN_RATE DOUBLE PRECISION 8
97 INT_CASHB_LOANT_AMT DOUBLE PRECISION 8
98 INT_PORTFOLIO_MARGIN_RATE DOUBLE PRECISION 8
99 INT_PORTFOLIO_LOANT_AMT DOUBLE PRECISION 8
100 INT_LOAN_AMT DOUBLE PRECISION 8
101 INT_LOAN_AMT_MARGIN DOUBLE PRECISION 8
102 REPAYMENT_FREQUENCY_MONTHLY_COUNT BIGINT 8