FCT_SDW_TSLNF_LOAN_ORIG

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 CHANGE_EVENT_PERIOD_DIM_ID BIGINT 8
2 ORIG_EVENT_PERIOD_DIM_ID BIGINT 8
3 ARRANGEMENT_DIM_ID BIGINT 8
4 ARRANGEMENT_ID CHARACTER VARYING(20) 20
5 FACILITY_DIM_ID BIGINT 8
6 FACILITY_ID CHARACTER VARYING(20) 20
7 BROKER_CODE CHARACTER VARYING(5) 5
8 ACCREDITED_BROKER_CODE CHARACTER VARYING(7) 7
9 PURPOSE_CODE CHARACTER VARYING(60) 60
10 SUB_PURPOSE_CODE CHARACTER VARYING(60) 60
11 SALES_OFFICER_ROLE_DIM_ID BIGINT 8
12 STAFF_USER_ID CHARACTER VARYING(100) 100
13 SOURCE_PRODUCT_CODE CHARACTER VARYING(24) 24
14 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
15 LOAN_ORIG_COST_CENTRE_CODE CHARACTER VARYING(5) 5
16 SALES_COST_CENTRE_CODE CHARACTER VARYING(24) 24
17 SALES_OFFICER_COST_CENTRE_CODE CHARACTER VARYING(24) 24
18 PRODUCT_CODE CHARACTER VARYING(4) 4
19 PRODUCT_TYPE CHARACTER VARYING(4) 4
20 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
21 SALES_MEASURE_CODE CHARACTER VARYING(50) 50
22 SOURCE_PRODUCT_LVLS_DIM_ID BIGINT 8
23 ADD_LOAN_FLAG CHARACTER VARYING(1) 1
24 LOAN_AMOUNT NUMERIC(14,2) 19
25 ADD_LOAN_AMOUNT NUMERIC(14,2) 19
26 TOTAL_FUNDING_AMOUNT NUMERIC(14,2) 19
27 LVR NUMERIC(8,3) 19
28 CAP_FEE_COUNT NUMERIC(38,0) 19
29 CAP_FEE_AMOUNT NUMERIC(14,2) 19
30 CAP_INS_PREMIUM_COUNT NUMERIC(38,0) 19
31 CAP_INS_PREMIUM_AMOUNT NUMERIC(14,2) 19
32 UNCAP_FEE_COUNT NUMERIC(38,0) 19
33 UNCAP_FEE_AMOUNT NUMERIC(14,2) 19
34 UNCAP_INS_PREMIUM_COUNT NUMERIC(38,0) 19
35 UNCAP_INS_PREMIUM_AMOUNT NUMERIC(14,2) 19
36 NEW_LENDING_AMOUNT NUMERIC(14,2) 19
37 BORROWER_CONTRIBUTION NUMERIC(14,2) 19
38 CURRENT_FLAG CHARACTER VARYING(1) 1
39 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
40 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
41 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
42 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8