FCT_WEM_EFS_PROPOSED_FACILITY_EOD

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..FCT_WEM_EFS_PROPOSED_FACILITY_EOD_V

Columns
# Name Data Type Length
1 APPLICATION_FACILITY_EFS_DIM_ID CHARACTER VARYING(61) 61
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(8) 8
6 FACILITY_STATUS_CODE CHARACTER VARYING(100) 100
7 PRODUCT_CLASS CHARACTER VARYING(2) 2
8 PRODUCT_GROUP_CODE CHARACTER VARYING(255) 255
9 PREDOMINANT_PRODUCT_CODE CHARACTER VARYING(50) 50
10 PREDOMINANT_PRODUCT_SUB_CODE CHARACTER VARYING(50) 50
11 PREDOMINANT_PURPOSE_CODE CHARACTER VARYING(250) 250
12 PREDOMINANT_SUB_PURPOSE_CODE CHARACTER VARYING(250) 250
13 PREDOMINANT_INTEREST_RATE_TYPE CHARACTER VARYING(1) 1
14 PREDOMINANT_REPAYMENT_TYPE CHARACTER VARYING(22) 22
15 BORROWER_ACCEPTANCE_DATE TIMESTAMP 8
16 APPLICATION_RECEIVED_DATE TIMESTAMP 8
17 SETTLEMENT_DATE TIMESTAMP 8
18 APPLICATION_WITHDRAWN_DATE DATE 4
19 ADD_LOAN_FLAG CHARACTER VARYING(1) 1
20 REVOLVING_FACILITY_FLAG CHARACTER VARYING(1) 1
21 REQUESTED_AMOUNT NUMERIC(25,2) 19
22 COMMITMENT_AMOUNT INTEGER 4
23 FIXED_PORTION_CREDIT_LIMIT NUMERIC(26,2) 19
24 VARIABLE_PORTION_CREDIT_LIMIT NUMERIC(26,2) 19
25 IO_PORTION_CREDIT_LIMIT NUMERIC(26,2) 19
26 AMORTISING_PORTION_CREDIT_LIMIT NUMERIC(26,2) 19
27 TOTAL_FACILITY_CREDIT_LIMIT NUMERIC(26,2) 19
28 CURRENCY CHARACTER VARYING(3) 3
29 ORIGINATION_LVR CHARACTER VARYING(1) 1
30 FACILITY_MATURITY_DATE TIMESTAMP 8
31 LOAN_TERM INTEGER 4
32 FACILITY_SECURED_FLAG CHARACTER VARYING(1) 1
33 SECURED_BY_RESIDENTIAL_PROPERTY_FLAG CHARACTER VARYING(1) 1
34 FACILITY_COLLATERALISATION CHARACTER VARYING(17) 17
35 LOCATION_OF_PROPERTY CHARACTER VARYING(40) 40
36 COST_CENTRE CHARACTER VARYING(240) 240
37 EFFECTIVE_START_DATE TIMESTAMP 8
38 EFFECTIVE_END_DATE TIMESTAMP 8
39 IS_CURRENT CHARACTER VARYING(1) 1