FCT_BNK_HL_SETTLEMENT_ROE_WEEK_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 TYPE CHARACTER VARYING(11) 11
2 SETTLEMENT_DATE TIMESTAMP 8
3 WEEK_END_DATE DATE 4
4 MONTH_END_DATE DATE 4
5 REGION CHARACTER VARYING(240) 240
6 FACILITY_CODE CHARACTER VARYING(40) 40
7 BROKER_FLAG CHARACTER VARYING(14) 14
8 PRODUCT_CODE CHARACTER VARYING(105) 105
9 NBR_FACILITIES INTEGER 4
10 FACILITY_REPORTING_AMOUNT DOUBLE PRECISION 8
11 SCHED_FEE_AMT DOUBLE PRECISION 8
12 ACTUAL_FEE_AMT DOUBLE PRECISION 8
13 CRATE DOUBLE PRECISION 8
14 ACTUAL_INTEREST_RATE DOUBLE PRECISION 8
15 PACKAGE_COUNT CHARACTER VARYING(8) 8
16 LVR DOUBLE PRECISION 8
17 LVR_GROUP CHARACTER VARYING(9) 9
18 VALUE_TIER CHARACTER VARYING(10) 10
19 USAGE CHARACTER VARYING(10) 10
20 ADD_LOAN_FLAG CHARACTER VARYING(1) 1
21 INTEREST_ONLY_LOAN_TERM CHARACTER VARYING(1) 1
22 LOW_DOC_LOAN_FLAG CHARACTER VARYING(1) 1
23 FIRST_HOME_OWNER_GRANT_FLAG CHARACTER VARYING(1) 1
24 PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
25 ACCREDITED_BROKER_CODE CHARACTER VARYING(20) 20
26 ACCREDITED_BROKER_SEGMENT CHARACTER VARYING(50) 50
27 STAFF_FLAG CHARACTER VARYING(1) 1