FCT_OBP_EFS_PORTFOLIO_FACILITY_EOD_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..FCT_OBP_EFS_PORTFOLIO_FACILITY_EOD

Columns
# Name Data Type Length
1 APPLICATION_FACILITY_EFS_DIM_ID CHARACTER VARYING(93) 93
2 SOURCE_SYSTEM_GROUP CHARACTER VARYING(3) 3
3 APPLICATION_ID CHARACTER VARYING(50) 50
4 FACILITY_NUMBER CHARACTER VARYING(40) 40
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_SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
12 PREDOMINANT_PURPOSE_CODE CHARACTER VARYING(40) 40
13 PREDOMINANT_SUB_PURPOSE_CODE CHARACTER VARYING(10) 10
14 PROPERTY_PURPOSE CHARACTER VARYING(14) 14
15 PREDOMINANT_INTEREST_RATE_TYPE CHARACTER VARYING(30) 30
16 PREDOMINANT_REPAYMENT_TYPE CHARACTER VARYING(34) 34
17 FIRST_HOME_BUYER_FLAG CHARACTER VARYING(1) 1
18 LATEST_BORROWER_ACCEPTANCE_DATE TIMESTAMP 8
19 LASTEST_APPLICATION_RECEIVED_DATE TIMESTAMP 8
20 LATEST_SETTLEMENT_DATE TIMESTAMP 8
21 APPLICATION_WITHDRAWN_DATE DATE 4
22 ADD_LOAN_FLAG CHARACTER VARYING(1) 1
23 REVOLVING_FACILITY_FLAG CHARACTER VARYING(1) 1
24 REDRAW_CAPABLE_PRODUCT CHARACTER VARYING(2) 2
25 REQUESTED_AMOUNT NUMERIC(25,2) 19
26 COMMITMENT_AMOUNT NUMERIC(25,2) 19
27 CURRENCY CHARACTER VARYING(3) 3
28 ORIGINATION_LVR NUMERIC(17,2) 19
29 DYNAMIC_LVR NUMERIC(17,2) 19
30 FACILITY_MATURITY_DATE TIMESTAMP 8
31 ACTIVE_OFFSET_FLAG CHARACTER VARYING(1) 1
32 INBA_FLAG CHARACTER VARYING(1) 1
33 STATUS CHARACTER VARYING(50) 50
34 COST_CENTRE CHARACTER VARYING(150) 150
35 FACILITY_CLOSURE_DATE TIMESTAMP 8
36 EFFECTIVE_START_DATE TIMESTAMP 8
37 EFFECTIVE_END_DATE TIMESTAMP 8
38 IS_CURRENT CHARACTER VARYING(1) 1