FCT_BNK_EFS_AGG_PROVISION_MR_EOM_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ENTITY NATIONAL CHARACTER VARYING(12) 12
2 RESIDENCY CHARACTER VARYING(12) 12
3 REPORT_LINE CHARACTER VARYING(29) 29
4 SESCA NATIONAL CHARACTER VARYING(30) 30
5 SESCA_LEVEL3 NATIONAL CHARACTER VARYING(100) 100
6 RATE_VARIABILITY NATIONAL CHARACTER VARYING(40) 40
7 SECURED_FLAG NATIONAL CHARACTER VARYING(40) 40
8 SECURED_RESI_FLAG NATIONAL CHARACTER VARYING(40) 40
9 PROPERTY_LOCATION NATIONAL CHARACTER VARYING(40) 40
10 RV_COA NATIONAL CHARACTER VARYING(255) 255
11 IMPAIRED_INDICATOR CHARACTER VARYING(1) 1
12 DAYS_PAST_DUE INTEGER 4
13 SECURITISATION_TYPE CHARACTER VARYING(12) 12
14 REVOLVING_CREDIT_FLAG CHARACTER VARYING(1) 1
15 INELIGIBLE_CP NUMERIC(38,4) 19
16 ELIGIBLE_CP NUMERIC(38,4) 19
17 ERCL NUMERIC(38,2) 19
18 INDIVIDUAL_PROVISION NUMERIC(38,4) 19
19 COLL_PROV NUMERIC(38,4) 19
20 OSX_COLL_PROV NUMERIC(38,8) 19
21 COLL_PROV_ORIG NUMERIC(38,4) 19