FCT_SDW_TSLNF_LOAN_ORIG_RPT_H

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

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