FCT_BNK_IFRS_CP_SP

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 PORTFOLIO_DATE TIMESTAMP 8
2 ENTITY_CODE CHARACTER VARYING(8) 8
3 RETAIL_FLAG CHARACTER VARYING(10) 10
4 INTERNAL_PD_MODEL CHARACTER VARYING(50) 50
5 PORTBASED_CATEGORY CHARACTER VARYING(75) 75
6 SP_INDICATOR INTEGER 4
7 ECL_STAGE INTEGER 4
8 PAST_DUE_CATEGORY CHARACTER VARYING(50) 50
9 STAGE_1_ECL NUMERIC(35,2) 19
10 STAGE_2_ECL NUMERIC(35,2) 19
11 STAGE_3_ECL NUMERIC(35,2) 19
12 CP_INCL_OVERLAY NUMERIC(35,2) 19
13 INELIGIBLE_CP NUMERIC(35,2) 19
14 CP_EXCL_OVERLAY NUMERIC(35,2) 19
15 LIFETIME_EL NUMERIC(35,2) 19
16 CP_NON_RETAIL_MGT_OVERLAY NUMERIC(35,2) 19
17 CP_RETAIL_OVERLAY NUMERIC(35,2) 19
18 SP_AMOUNT_RAW NUMERIC(35,2) 19
19 SP_IFRS NUMERIC(35,2) 19
20 SP_IFRS_CAPINT NUMERIC(35,2) 19
21 SP_UNWIND NUMERIC(35,2) 19
22 ERCL_AMOUNT NUMERIC(35,2) 19
23 EXPOSURE NUMERIC(38,2) 19
24 PROVISION_AMOUNT_COLLECTIVE NUMERIC(35,2) 19