FCT_BNK_ARF_223_DETAIL_EXISTING_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP02_BANK..FCT_BNK_ARF_223_DETAIL_EXISTING

Columns
# Name Data Type Length
1 ID BIGINT 8
2 MONTH_KEY CHARACTER VARYING(30) 30
3 REPORTING_PERIOD CHARACTER VARYING(200) 200
4 ACCOUNT_NO CHARACTER VARYING(50) 50
5 QTR_KEY CHARACTER VARYING(10) 10
6 SOURCE_SYSTEM CHARACTER VARYING(20) 20
7 APRA_CLASS CHARACTER VARYING(20) 20
8 APRA_CATEGORY CHARACTER VARYING(20) 20
9 APRA_SUB_CATEGORY CHARACTER VARYING(20) 20
10 APRA_ASSET_CLASS_IRB CHARACTER VARYING(100) 100
11 COUNTERPARTY_TYPE CHARACTER VARYING(100) 100
12 QRM_ACCOUNT CHARACTER VARYING(100) 100
13 PRODUCT_CODE_1 CHARACTER VARYING(50) 50
14 PRODUCT_CODE_2 CHARACTER VARYING(50) 50
15 LIMIT_CALCULATED NUMERIC(15,2) 19
16 BALANCE NUMERIC(15,2) 19
17 OO_INV_FLAG CHARACTER VARYING(20) 20
18 REVOLVING_CREDIT_FLAG CHARACTER VARYING(1) 1
19 NON_HOUSING_PURPOSE_FLAG CHARACTER VARYING(1) 1
20 IO_FLAG CHARACTER VARYING(1) 1
21 THIRD_PARTY_ORIGINATED CHARACTER VARYING(1) 1
22 LMI_FLAG CHARACTER VARYING(1) 1
23 SETTLE_DATE DATE 4
24 DEPOSIT_OFFSET_ACCOUNT NUMERIC(25,0) 19
25 DEPOSIT_OFFSET_BALANCE NUMERIC(15,2) 19
26 LOW_DOC_FLAG CHARACTER VARYING(1) 1
27 IMPDPASTDUE_FLAG CHARACTER VARYING(1) 1
28 PAST_DUE_DAYS INTEGER 4
29 UNIT_APARTMENT_FLAG CHARACTER VARYING(1) 1
30 REPO_FLAG CHARACTER VARYING(1) 1
31 SMSFS_FLAG CHARACTER VARYING(1) 1
32 LVR_ERM NUMERIC(18,6) 19
33 NON_RESIDENT_FLAG CHARACTER VARYING(1) 1
34 EXPOSURE NUMERIC(15,2) 19
35 PAST3M_IMPDPASTDUE_FLAG CHARACTER VARYING(1) 1
36 NEW_IMPDPASTDUE_QTR_FLAG CHARACTER VARYING(1) 1
37 HARDSHIP_FLAG CHARACTER VARYING(1) 1
38 EAD_ON_BAL NUMERIC(15,2) 19
39 UNINCORPORATED_BUS_FLAG CHARACTER VARYING(1) 1
40 DATA_DATE TIMESTAMP 8