FCT_BNK_ARF_HOUSING_FINANCE_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

ARF Extract for Home Loans grouped into Buckets of the type of dwelling and loan purposes

Source Object (CTAS)

SDSNZP05_BANK..FCT_BNK_ARF_HOUSING_FINANCE

Columns
# Name Data Type Length
1 STATE CHARACTER VARYING(3) 3
2 AUSTRALIAN_BUSINESS_NUMBER CHARACTER VARYING(1) 1
3 INSTITUTION_NAME CHARACTER VARYING(1) 1
4 OPENING_REPORTING_PERIOD DATE 4
5 CLOSING_REPORTING_PERIOD DATE 4
6 SCALE_FACTOR CHARACTER VARYING(31) 31
7 REPORTING_CONSOLIDATION CHARACTER VARYING(12) 12
8 SURNAME_OF_CONTACT CHARACTER VARYING(1) 1
9 GIVEN_NAME_OF_CONTACT CHARACTER VARYING(1) 1
10 PHONE_NUMBER_OF_CONTACT CHARACTER VARYING(1) 1
11 COMMITMENTS_NOT_DRAWN_AT_START_OF_MONTH DOUBLE PRECISION 8
12 COMMITMENTS_DURING_THE_MONTH DOUBLE PRECISION 8
13 ADVANCES_DURING_THE_MONTH DOUBLE PRECISION 8
14 CANCELLATIONS_DURING_THE_MONTH DOUBLE PRECISION 8
15 COMMITMENTS_NOT_DRAWN_AT_END_OF_MONTH DOUBLE PRECISION 8
16 NO_OF_CONSTRUCTION_DWELLINGS BIGINT 8
17 CONSTRUCTION_DWELLINGS_AMT DOUBLE PRECISION 8
18 NO_OF_NEWLY_ERECTED_DWELLINGS BIGINT 8
19 NEWLY_ERECTED_DWELLINGS_AMT DOUBLE PRECISION 8
20 NO_OF_ESTABLISHED_DWELLINGS BIGINT 8
21 ESTABLISHED_DWELLINGS_AMT DOUBLE PRECISION 8
22 NO_OF_REFINANCE_EXISTING_DWELLINGS BIGINT 8
23 REFINANCE_EXISTING_DWELLINGS_AMT DOUBLE PRECISION 8
24 NO_OF_NEW_HOUSING_COMMITMENT BIGINT 8
25 TOTAL_NEW_HOUSING_COMMITMENT_AMT DOUBLE PRECISION 8
26 NO_OF_ALTERATION_DWELLINGS BIGINT 8
27 ALTERATION_DWELLINGS_AMT DOUBLE PRECISION 8
28 TOTAL_NEW_LENDING_COMMITMENT_AMT DOUBLE PRECISION 8
29 NO_OF_FIXED_RATE_FHB_DWELLINGS INTEGER 4
30 FIXED_RATE_FHB_DWELLINGS_AMT INTEGER 4
31 NO_OF_FIXED_RATE_OTHER_DWELLINGS INTEGER 4
32 FIXED_RATE_OTHER_DWELLINGS_AMT INTEGER 4
33 NO_OF_CREDIT_LOAN_FHB_DWELLINGS INTEGER 4
34 CREDIT_LOAN_FHB_DWELLINGS_AMT INTEGER 4
35 NO_OF_CREDIT_LOAN_OTHER_DWELLINGS INTEGER 4
36 CREDIT_LOAN_OTHER_DWELLINGS_AMT INTEGER 4
37 NO_OF_VAR_FHB_DWELLINGS BIGINT 8
38 VAR_FHB_DWELLINGS_AMT DOUBLE PRECISION 8
39 NO_OF_VAR_OTHER_DWELLINGS BIGINT 8
40 VAR_OTHER_DWELLINGS_AMT DOUBLE PRECISION 8
41 NO_OF_HOME_LOANS BIGINT 8
42 TOTAL_HOME_LOANS_AMT DOUBLE PRECISION 8
43 COMMENTS CHARACTER VARYING(1) 1