DIM_OBP_SLN_FACILITY_UPL_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..DIM_OBP_SLN_FACILITY_UPL

Columns
# Name Data Type Length
1 FACILITY_ID CHARACTER VARYING(40) 40
2 APPLICATION_ID CHARACTER VARYING(50) 50
3 BANKING_TYPE CHARACTER VARYING(6) 6
4 LOAN_TYPE CHARACTER VARYING(13) 13
5 LOAN_USE CHARACTER VARYING(8) 8
6 LOAN_ACCOUNT CHARACTER VARYING(40) 40
7 LOAN_TERM_MONTHS BIGINT 8
8 INTEREST_ONLY_LOAN_TERM_MONTHS INTEGER 4
9 ADD_LOAN_FLAG CHARACTER VARYING(1) 1
10 LVR DOUBLE PRECISION 8
11 ACTUAL_INTEREST_RATE DOUBLE PRECISION 8
12 PRODUCT_INTEREST_RATE DOUBLE PRECISION 8
13 SUNCORP_STAFF_FLAG CHARACTER VARYING(1) 1
14 OWNED_EQUITY_TYPE CHARACTER VARYING(1) 1
15 BORROWED_EQUITY_TYPE CHARACTER VARYING(1) 1
16 PAYMENT_TYPE CHARACTER VARYING(400) 400
17 INTEREST_CAPATILISATION_FLAG CHARACTER VARYING(1) 1
18 PROGRESSIVE_DRAW_FLAG CHARACTER VARYING(1) 1
19 BROKER_TARGET_BUSINESS_FLAG CHARACTER VARYING(1) 1
20 CC_APPLICATION_SOURCE_ID CHARACTER VARYING(1) 1
21 CC_CREATE_APPLICATION_TYPE CHARACTER VARYING(1) 1
22 CC_CRD_APPLICATION_ID CHARACTER VARYING(1) 1
23 CC_REWARD_LEVEL CHARACTER VARYING(1) 1
24 CC_CCI_LEVEL CHARACTER VARYING(1) 1
25 CC_SCO_OFFER_DESCRIPTION CHARACTER VARYING(1) 1
26 CC_SEC_SENT_LEVEL CHARACTER VARYING(1) 1
27 CC_PACKAGE_CODE CHARACTER VARYING(1) 1
28 CC_CURR_CRD_APPLICATION_STATE CHARACTER VARYING(1) 1
29 CC_APPLICATION_DECLINED_REASON CHARACTER VARYING(1) 1
30 CC_CAMPAIGN_CODE CHARACTER VARYING(1) 1
31 CREATION_DATE TIMESTAMP 8
32 SETTLEMENT_DATE TIMESTAMP 8
33 FINANCE_DATE TIMESTAMP 8
34 CC_CURENT_STATE_RESPONSE_DATE TIMESTAMP 8
35 LOW_DOC_FLAG CHARACTER VARYING(1) 1
36 CAMPAIGN_CODE CHARACTER VARYING(1) 1
37 BSN_LOAD_DT TIMESTAMP 8
38 IS_SPLIT CHARACTER VARYING(1) 1
39 RELATED_SPLITS CHARACTER VARYING(1) 1
40 FIRST_HOME_OWNER_GRANT_FL CHARACTER VARYING(1) 1
41 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
42 CDC_RECORD_TYPE CHARACTER VARYING(6) 6
43 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
44 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8