FCT_BNK_COEX_RETAIL_LENDING_MONTHLY_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP02_BANK..FCT_BNK_COEX_RETAIL_LENDING_MONTHLY

Columns
# Name Data Type Length
1 ACCOUNT_DIM_ID BIGINT 8
2 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
3 BANK_STATES_LEVEL_02_NAME CHARACTER VARYING(240) 240
4 BROKER_ORIGINATED_FLAG CHARACTER VARYING(5) 5
5 CARDED_RATE DOUBLE PRECISION 8
6 CHANNEL CHARACTER VARYING(30) 30
7 CLOSING_BAL_SHEET_INDICATOR CHARACTER VARYING(20) 20
8 CLOSING_SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
9 COST_CENTRE_NAME CHARACTER VARYING(240) 240
10 OF_COST_CENTRE_CODE CHARACTER VARYING(150) 150
11 CUSTOMER_RATE DOUBLE PRECISION 8
12 DATE_CLOSED TIMESTAMP 8
13 DATE_CLOSED_FINAL TIMESTAMP 8
14 DATE_OPEN TIMESTAMP 8
15 MONTH_ON_BOOK_OPEN NUMERIC(17,9) 19
16 MOB_HEIR_OPEN CHARACTER VARYING(11) 11
17 MONTH_ON_BOOK_CLOSED NUMERIC(17,9) 19
18 MOB_HIER_CLOSED CHARACTER VARYING(11) 11
19 FINANCIAL_YEAR_END_ID NUMERIC(38,0) 19
20 FIRST_HOME_BUYER_FLAG CHARACTER VARYING(5) 5
21 FIRST_HOME_BUYER_FLAG_OLD CHARACTER VARYING(5) 5
22 LOWDOC_FLAG CHARACTER VARYING(5) 5
23 MARGIN_RATE DOUBLE PRECISION 8
24 MORTGAGE_INSURANCE_FLAG CHARACTER VARYING(5) 5
25 OF_COST_CENTRE_SID BIGINT 8
26 OPENING_BAL_SHEET_INDICATOR CHARACTER VARYING(20) 20
27 OPENING_SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
28 OWNER_OCCUPIED_INVESTMENT_IND CHARACTER VARYING(100) 100
29 PERIOD_DIM_ID NUMERIC(38,0) 19
30 PRODUCT_LEVEL_1_DESCRIPTION CHARACTER VARYING(100) 100
31 PRODUCT_LEVEL_2_DESCRIPTION CHARACTER VARYING(100) 100
32 PRODUCT_LEVEL_3_DESCRIPTION CHARACTER VARYING(100) 100
33 PRODUCT_LEVEL_4_DESCRIPTION CHARACTER VARYING(100) 100
34 PRODUCT_LEVEL_5_DESCRIPTION CHARACTER VARYING(100) 100
35 SOURCE_SYSTEM_CODE CHARACTER VARYING(12) 12
36 SUNCORP_BANKING_LEVEL_02_NAME CHARACTER VARYING(240) 240
37 SUNCORP_BANKING_LEVEL_03_NAME CHARACTER VARYING(240) 240
38 SUNCORP_BANKING_LEVEL_04_NAME CHARACTER VARYING(240) 240
39 SUNCORP_BANKING_LEVEL_05_NAME CHARACTER VARYING(240) 240
40 SOURCE CHARACTER VARYING(3) 3
41 OPENING_BALANCE NUMERIC(38,2) 19
42 CLOSING_BALANCE NUMERIC(38,2) 19
43 DISBURSEMENT DOUBLE PRECISION 8
44 INTEREST DOUBLE PRECISION 8
45 CASHBACK DOUBLE PRECISION 8
46 FEE DOUBLE PRECISION 8
47 INSURANCE DOUBLE PRECISION 8
48 PAYOUT DOUBLE PRECISION 8
49 REPAYMENT DOUBLE PRECISION 8
50 LOAN_PURPOSE CHARACTER VARYING(400) 400
51 LOAN_SUB_PURPOSE CHARACTER VARYING(256) 256
52 SOURCE_CUSTOMER_NUMBER CHARACTER VARYING(40) 40
53 RTL_LND_BALANCE_TIER CHARACTER VARYING(150) 150
54 SALES_OFFICER CHARACTER VARYING(254) 254
55 SECONDARY_OFFICER CHARACTER VARYING(40) 40
56 SECURED_FLAG CHARACTER VARYING(5) 5
57 PRINCIPLE_LIMIT DOUBLE PRECISION 8
58 MIGRATED_DATE DATE 4
59 INTEREST_RATE_TYPE CHARACTER VARYING(30) 30
60 PAYOUT_DATE TIMESTAMP 8
61 30DAYS_PAYOUT DOUBLE PRECISION 8
62 30DAYS_REPAYMENT DOUBLE PRECISION 8
63 30DAYS_PRIOR_BALANCE NUMERIC(38,2) 19
64 PAYOUT_CLASSIFICATION CHARACTER VARYING(18) 18