FCT_ASIC516_SWITCHED_LOAN_DASHBOARD_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 REPORTING_MONTH TIMESTAMP 8
2 ID_NUMBER CHARACTER VARYING(50) 50
3 PORTFOLIO_DATE TIMESTAMP 8
4 ACCOUNT_NUMBER NUMERIC(28,0) 19
5 BROKER_ORIGINATED_FLAG CHARACTER VARYING(1) 1
6 QRM_ACCOUNT CHARACTER VARYING(75) 75
7 I_CODE CHARACTER VARYING(9) 9
8 AGGREGATOR_NAME NATIONAL CHARACTER VARYING(250) 250
9 A_CODE CHARACTER VARYING(19) 19
10 BROKER_NAME CHARACTER VARYING(511) 511
11 BROKER_GIVEN_NAMES CHARACTER VARYING(255) 255
12 BROKER_SURNAME CHARACTER VARYING(255) 255
13 UNIQUE_IDENTIFIER CHARACTER VARYING(255) 255
14 BROKER_BUSINESS_NAME CHARACTER VARYING(100) 100
15 BROKER_STATE CHARACTER VARYING(240) 240
16 SOURCE_LENDER CHARACTER VARYING(40) 40
17 OWNER_OCCUPIER CHARACTER VARYING(2) 2
18 INTEREST_ONLY CHARACTER VARYING(2) 2
19 REVOLVING_CREDIT_FLAG CHARACTER VARYING(1) 1
20 COUNTERPARTY_GCIS_CUSTOMER_NO NUMERIC(16,0) 19
21 PAYMENT_FREQUENCY CHARACTER VARYING(30) 30
22 PAST_DUE_AMOUNT NUMERIC(15,2) 19
23 CURRENT_PAYMENT NUMERIC(15,2) 19
24 PAST_DUE_AMT_GTE_90_DAYS_PMT CHARACTER VARYING(1) 1
25 DAYS_IN_ARREARS_GTE_90 CHARACTER VARYING(1) 1
26 NEXT_PAYMENT_DATE TIMESTAMP 8
27 IMPAIRED_FLAG CHARACTER VARYING(1) 1
28 SETTLEMENT_DATE TIMESTAMP 8
29 DAYS_IN_ARREARS CHARACTER VARYING(20) 20
30 ORIGINATION_INTEREST NUMERIC(19,4) 19
31 ORIGINATION_AMOUNT NUMERIC(19,4) 19
32 ORIGINATION_INTEREST_AMOUNT NUMERIC(19,4) 19
33 FACE_AMT NUMERIC(19,4) 19
34 LVR_ORIGINATION NUMERIC(9,2) 19
35 COLLATERAL_PRIMARY_STATE CHARACTER VARYING(13) 13
36 LICENSE_TYPE NATIONAL CHARACTER VARYING(15) 15
37 SEGMENT CHARACTER VARYING(100) 100
38 PAYOUT_DATE TIMESTAMP 8
39 ADJUSTED_PAYOUT_BALANCE DOUBLE PRECISION 8
40 WEEK_END_DATE TIMESTAMP 8
41 ADJUSTED_PAYOUT_WEEKLY DOUBLE PRECISION 8
42 ADJUSTED_REPAYMENT_WEEKLY DOUBLE PRECISION 8
43 MONTH_END_DATE TIMESTAMP 8
44 ADJUSTED_PAYOUT_MONTHLY DOUBLE PRECISION 8
45 ADJUSTED_REPAYMENT_MONTHLY DOUBLE PRECISION 8
46 SOURCE_CODE CHARACTER VARYING(3) 3
47 BANK_STATES_LEVEL_02_NAME CHARACTER VARYING(240) 240
48 SUNCORP_BANKING_LEVEL_04_NAME CHARACTER VARYING(240) 240
49 SUNCORP_BANKING_LEVEL_05_NAME CHARACTER VARYING(240) 240
50 COST_CENTRE CHARACTER VARYING(150) 150
51 COST_CENTRE_NAME CHARACTER VARYING(240) 240
52 SOURCE_PRODUCT_DESCRIPTION CHARACTER VARYING(100) 100
53 PRODUCT_LEVEL_3_DESCRIPTION CHARACTER VARYING(100) 100
54 PRODUCT_LEVEL_4_DESCRIPTION CHARACTER VARYING(100) 100
55 PRODUCT_LEVEL_5_DESCRIPTION CHARACTER VARYING(100) 100
56 LOAN_PURPOSE_DESC CHARACTER VARYING(400) 400
57 SUB_PURPOSE_DESC CHARACTER VARYING(256) 256
58 CUSTOMER_RATE DOUBLE PRECISION 8
59 DATE_OPEN TIMESTAMP 8
60 DATE_CLOSED TIMESTAMP 8
61 AGE_DAYS INTEGER 4
62 PAYOUT_CLASSIFICATION CHARACTER VARYING(18) 18
63 REFINANCING_PARTY CHARACTER VARYING(200) 200
64 SWITCHED_AMOUNT DOUBLE PRECISION 8
65 CIF_TOTAL_PORTFOLIO_AGG DOUBLE PRECISION 8
66 CIF_TOTAL_PORTFOLIO_BROKER DOUBLE PRECISION 8
67 DATA_REFRESH_TIMESTAMP TIMESTAMP 8