FCT_OBP_EFS_APPLICATION_FACILITY_EOD

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..FCT_OBP_EFS_APPLICATION_FACILITY_EOD_V

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 APPLICATION_EFS_DIM_ID CHARACTER VARYING(53) 53
6 FACILITY_TYPE CHARACTER VARYING(8) 8
7 FACILITY_STATUS_CODE CHARACTER VARYING(50) 50
8 FACILITY_CREATION_DATE TIMESTAMP 8
9 APPLICATION_CREATION_DATE TIMESTAMP 8
10 PRODUCT_CLASS CHARACTER VARYING(2) 2
11 PRODUCT_GROUP_CODE CHARACTER VARYING(16) 16
12 PRODUCT_CODE CHARACTER VARYING(50) 50
13 PRODUCT_SUB_CODE CHARACTER VARYING(40) 40
14 SOURCE_PRODUCT_CODE CHARACTER VARYING(105) 105
15 PURPOSE_CODE CHARACTER VARYING(40) 40
16 SUB_PURPOSE_CODE CHARACTER VARYING(255) 255
17 LOAN_TERM_MTHS INTEGER 4
18 FIXED_OR_VARIABLE CHARACTER VARYING(1) 1
19 FIXED_RATE_TERM_MONTHS INTEGER 4
20 REPAYMENT_TYPE CHARACTER VARYING(34) 34
21 INT_ONLY_TERM_MONTHS INTEGER 4
22 INTEREST_RATE NUMERIC(15,2) 19
23 BASE_RATE NUMERIC(15,2) 19
24 MARGIN_RATE NUMERIC(15,2) 19
25 LOAN_USE CHARACTER VARYING(14) 14
26 OWNER_OCCUPIED CHARACTER VARYING(1) 1
27 FIRST_HOME_BUYER CHARACTER VARYING(1) 1
28 APPLICATION_STATUS CHARACTER VARYING(50) 50
29 FIRST_APPLICATION_LODGEMENT_DATE DATE 4
30 LAST_APPLICATION_LODGEMENT_DATE DATE 4
31 FIRST_STRUCTURE_SOLN_CONFIRMED_DATE DATE 4
32 LAST_STRUCTURE_SOLN_CONFIRMED_DATE DATE 4
33 FIRST_CONDITIONAL_APPROVAL_DATE DATE 4
34 LAST_CONDITIONAL_APPROVAL_DATE DATE 4
35 FIRST_APPLICATION_UNCONDITIONAL_APPROVAL_DATE DATE 4
36 LAST_APPLICATION_UNCONDITIONAL_APPROVAL_DATE DATE 4
37 FIRST_OFFER_LETTER_DISPATCH_DATE DATE 4
38 LAST_OFFER_LETTER_DISPATCH_DATE DATE 4
39 FIRST_OFFER_LETTER_ACCEPTANCE_DATE DATE 4
40 LAST_OFFER_LETTER_ACCEPTANCE_DATE DATE 4
41 SETTLEMENT_DATE TIMESTAMP 8
42 APPLICATION_WITHDRAWN_DATE TIMESTAMP 8
43 ADD_LOAN_FLAG CHARACTER VARYING(1) 1
44 AMEND_TYPE CHARACTER VARYING(9) 9
45 AMEND_DATE TIMESTAMP 8
46 REVOLVING_FACILITY_FLAG CHARACTER VARYING(1) 1
47 REDRAW_CAPABLE_PRODUCT CHARACTER VARYING(1) 1
48 FACILITY_REPORTING_AMOUNT NUMERIC(25,2) 19
49 CREDIT_LIMIT NUMERIC(25,2) 19
50 CREDIT_LIMIT_WITHOUT_FEES NUMERIC(25,2) 19
51 CREDIT_ESTABLISHMENT_FEES NUMERIC(25,2) 19
52 FACILITY_ADD_LOAN_AMOUNT NUMERIC(25,2) 19
53 CURRENCY CHARACTER VARYING(3) 3
54 FACILITY_LVR NUMERIC(25,2) 19
55 BORROWER_CONTRIBUTION_AMOUNT NUMERIC(25,2) 19
56 FACILITY_MATURITY_DATE DATE 4
57 ACCREDITED_BROKER_ID CHARACTER VARYING(20) 20
58 BROKER_CODE CHARACTER VARYING(40) 40
59 COST_CENTRE CHARACTER VARYING(240) 240
60 PREAPPROVAL_FLAG CHARACTER VARYING(1) 1
61 PREAPPROVAL_CONVERSION_DATE DATE 4
62 LOAD_DATE DATE 4
63 EFFECTIVE_START_DATE TIMESTAMP 8
64 EFFECTIVE_END_DATE TIMESTAMP 8
65 IS_CURRENT CHARACTER VARYING(1) 1