FCT_BNK_COEX_RETAIL_LENDING_DAILY_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 FINANCIAL_YEAR_END_ID NUMERIC(38,0) 19
3 ACCOUNT_NUMBER BIGINT 8
4 ACCOUNT_STATUS CHARACTER VARYING(24) 24
5 ACCOUNT_STATUS_NAME CHARACTER VARYING(256) 256
6 DATE_OPENED TIMESTAMP 8
7 DATE_CLOSED TIMESTAMP 8
8 BROKER_CODE CHARACTER VARYING(20) 20
9 ACCREDITED_BROKER_CODE CHARACTER VARYING(20) 20
10 BROKER_ORIGINATED_FLAG CHARACTER VARYING(5) 5
11 LOWDOC_FLAG CHARACTER VARYING(5) 5
12 FIRST_HOME_BUYER_FLAG CHARACTER VARYING(5) 5
13 OWNER_OCCUPIED_INVESTMENT_IND CHARACTER VARYING(100) 100
14 MORTGAGE_INSURANCE_FLAG CHARACTER VARYING(5) 5
15 SECURED_FLAG CHARACTER VARYING(5) 5
16 LOAN_PURPOSE_CODE CHARACTER VARYING(40) 40
17 LOAN_PURPOSE_DESC CHARACTER VARYING(400) 400
18 SUB_PURPOSE_CODE CHARACTER VARYING(10) 10
19 SUB_PURPOSE_DESC CHARACTER VARYING(255) 255
20 CUSTOMER_RATE DOUBLE PRECISION 8
21 CARDED_RATE DOUBLE PRECISION 8
22 MARGIN_RATE DOUBLE PRECISION 8
23 OPENING_BALANCE NUMERIC(38,2) 19
24 CLOSING_BALANCE NUMERIC(38,2) 19
25 RTL_LND_BALANCE_TIER CHARACTER VARYING(150) 150
26 OPENING_BAL_SHEET_INDICATOR CHARACTER VARYING(20) 20
27 CLOSING_BAL_SHEET_INDICATOR CHARACTER VARYING(20) 20
28 DISBURSEMENT DOUBLE PRECISION 8
29 INTEREST DOUBLE PRECISION 8
30 CASHBACK DOUBLE PRECISION 8
31 PAYOUT DOUBLE PRECISION 8
32 REPAYMENT DOUBLE PRECISION 8
33 INSURANCE DOUBLE PRECISION 8
34 FEE DOUBLE PRECISION 8
35 CHANNEL_SOURCE CHARACTER VARYING(30) 30
36 CHANNEL_DESCRIPTION CHARACTER VARYING(400) 400
37 OF_COST_CENTRE_SID BIGINT 8
38 COST_CENTRE_NAME CHARACTER VARYING(240) 240
39 COST_CENTRE_CODE CHARACTER VARYING(150) 150
40 BANK_STATES_LEVEL_02_NAME CHARACTER VARYING(240) 240
41 SUNCORP_BANKING_LEVEL_02_NAME CHARACTER VARYING(240) 240
42 SUNCORP_BANKING_LEVEL_03_NAME CHARACTER VARYING(240) 240
43 SUNCORP_BANKING_LEVEL_04_NAME CHARACTER VARYING(240) 240
44 SUNCORP_BANKING_LEVEL_05_NAME CHARACTER VARYING(240) 240
45 OPENING_SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
46 CLOSING_SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
47 PRODUCT_LEVEL_1_DESCRIPTION CHARACTER VARYING(100) 100
48 PRODUCT_LEVEL_2_DESCRIPTION CHARACTER VARYING(100) 100
49 PRODUCT_LEVEL_3_DESCRIPTION CHARACTER VARYING(100) 100
50 PRODUCT_LEVEL_4_DESCRIPTION CHARACTER VARYING(100) 100
51 PRODUCT_LEVEL_5_DESCRIPTION CHARACTER VARYING(100) 100
52 SALES_OFFICER CHARACTER VARYING(254) 254
53 SECONDARY_OFFICER CHARACTER VARYING(40) 40
54 SOURCE CHARACTER VARYING(18) 18
55 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
56 MIGRATED_DATE DATE 4
57 OBP_CUSTOMER_NUMBER CHARACTER VARYING(40) 40
58 PRINCIPLE_LIMIT DOUBLE PRECISION 8
59 INTEREST_RATE_TYPE CHARACTER VARYING(30) 30
60 AMORTISATION_TYPE_CODE CHARACTER VARYING(9) 9
61 CALC_ADVANCE_AMT DOUBLE PRECISION 8
62 AVL_CASHBACK DOUBLE PRECISION 8
63 CALC_AVAIL_BAL DOUBLE PRECISION 8
64 BALANCE_MOVEMENT NUMERIC(38,2) 19
65 PAYOUT_DATE TIMESTAMP 8
66 30DAYS_PAYOUT DOUBLE PRECISION 8
67 30DAYS_REPAYMENT DOUBLE PRECISION 8
68 30DAYS_PRIOR_BALANCE NUMERIC(38,2) 19
69 PAYOUT_CLASSIFICATION CHARACTER VARYING(18) 18