FCT_HLG_EFS_PORTFOLIO_FACILITY_EOM_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 APPLICATION_FACILITY_EFS_DIM_ID CHARACTER VARYING(29) 29
2 SOURCE_SYSTEM_GROUP CHARACTER VARYING(3) 3
3 APPLICATION_ID CHARACTER VARYING(26) 26
4 FACILITY_NUMBER CHARACTER VARYING(24) 24
5 FACILITY_TYPE CHARACTER VARYING(9) 9
6 PRODUCT_CLASS CHARACTER VARYING(2) 2
7 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
8 PREDOMINANT_ACCOUNT_ID_NUMBER CHARACTER VARYING(24) 24
9 PREDOMINANT_PRODUCT_CODE CHARACTER VARYING(30) 30
10 PREDOMINANT_PRODUCT_SUB_CODE CHARACTER VARYING(30) 30
11 PREDOMINANT_PURPOSE_CODE CHARACTER VARYING(100) 100
12 PREDOMINANT_SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
13 PREDOMINANT_SUB_PURPOSE_CODE CHARACTER VARYING(100) 100
14 PROPERTY_PURPOSE CHARACTER VARYING(14) 14
15 PREDOMINANT_INTEREST_RATE_TYPE CHARACTER VARYING(5) 5
16 PREDOMINANT_REPAYMENT_TYPE CHARACTER VARYING(22) 22
17 FIRST_HOME_BUYER_FLAG CHARACTER VARYING(1) 1
18 LATEST_BORROWER_ACCEPTANCE_DATE TIMESTAMP 8
19 LASTEST_APPLICATION_RECEIVED_DATE TIMESTAMP 8
20 REVOLVING_FACILITY_FLAG CHARACTER VARYING(1) 1
21 REDRAW_CAPABLE_PRODUCT CHARACTER VARYING(1) 1
22 REQUESTED_AMOUNT NUMERIC(15,2) 19
23 COMMITMENT_AMOUNT NUMERIC(15,2) 19
24 FIXED_PORTION_CREDIT_LIMIT NUMERIC(15,2) 19
25 VARIABLE_PORTION_CREDIT_LIMIT NUMERIC(15,2) 19
26 IO_PORTION_CREDIT_LIMIT NUMERIC(15,2) 19
27 AMORTISING_PORTION_CREDIT_LIMIT NUMERIC(15,2) 19
28 TOTAL_FACILITY_CREDIT_LIMIT NUMERIC(15,2) 19
29 CURRENCY CHARACTER VARYING(3) 3
30 DYNAMIC_LVR NUMERIC(17,2) 19
31 FACILITY_MATURITY_DATE TIMESTAMP 8
32 MORTGAGE_INSURANCE_FLAG CHARACTER VARYING(1) 1
33 OFFSET_FLAG CHARACTER VARYING(1) 1
34 COST_CENTRE CHARACTER VARYING(150) 150
35 FACILITY_CLOSURE_DATE TIMESTAMP 8
36 STATUS CHARACTER VARYING(50) 50
37 ORIGINAL_SETTLEMENT_DATE TIMESTAMP 8
38 LATEST_SETTLEMENT_DATE TIMESTAMP 8
39 ORIGINATION_LVR NUMERIC(9,2) 19
40 EFFECTIVE_START_DATE TIMESTAMP 8
41 EFFECTIVE_END_DATE TIMESTAMP 8
42 IS_CURRENT CHARACTER VARYING(1) 1