Filetype Excel XLSX | Posted on 09 Aug 2022 | 3 years ago
Authentication
digital resources
167x Filetype XLSX File size 2.10 MB Source: eba.europa.eu
Structure of the data dictionary
This document is an Annex to the "Handbook on valuation for purposes of resolution".
It contains data fields and further information requests that might be considered relevant for the valuation in resolution. The
structure of the data dictionary is as shown below.
Loans Other assets Liabilities Derivatives & off- Other data
Derivatives & off- balance sheet items
Loans Other assets Liabilities balance sheet items Other data
Counterparty modules Loan module Collateral modules Other financial assets Deposits Derivatives Portfolio level info
Other financial assets Deposits Derivatives Corporates and SMEs Loan tape Residential Real Estate Cash & deposits & similar Debt securities issued Derivatives -other data Covers different splits of the loan
Counterparty modules Loan module Collateral modules Portfolio level info Households Land plots Debt securities Provisions Off-balance sheet items portfolios to help the valuer get an
Cash & deposits & Debt securities issued Off-balance sheet items Covers different splits of Central banks, public sector and credit institutions Office buildings Listed equity investments Pension and similar provisions overview of the loan book
Corporates and SMEs Loan tape Residential Real Estate
similar positions the loan portfolios to help Hotels / entertainment Unlisted equity investments Other liabilities
Households Provisions the valuer get an Counterparty Group Retail (e.g. malls) Other non-finacial assets Historic performance
Land plots overview of the loan
Debt securities Pension and similar Infrastructure projects DTAs Information on the historic
Central banks, public Office buildings provisions book Factories/Warehouses Intangible other than goodwill performance of the facilities /
sector and credit Listed equity debtors split by portfolios and risk
institutions Hotels / entertainment investments Other liabilities Historic performance Equipment/machinery Goodwill
Automotive Other assets differentiators
Counterparty Group Retail (e.g. malls) Unlisted equity Information on the Aircrafts (Financial) Due diligence
investments historic performance of Shipping (Financial) Due Diligence
Infrastructure projects Other non-finacial the facilities / debtors split Financial guarantees information/data request
assets by portfolios and risk
Factories/Warehouses differentiators Financial instruments
DTAs Cash collateral received
Equipment/machinery (Financial) Due
Intangible other than Diligence
Automotive goodwill
Aircrafts (Financial) Due Diligence
Goodwill information / data request
Shipping Other assets
Financial guarantees
Financial instruments
Cash collateral
received
Please note: Foreclosed assets should presumably be reported using the respective collateral modules.
Completing the facility and/or counterparty module would as such not be required for foreclosed assets.
Approach to link the counterparty, loan, collateral and other modules
Considering the unique identifiers:
The below approach can be used to link the different modules in this data dictionary. Such links would presumable be made in separate "linking tables", like in the examples below.
I.e. the links between e.g. loans and collaterals would not be made in neither the loan nor collateral table, but in separate tables, using identifiers of the different parts to be linked.
Unique identifier Description
Counterparty Identifier (ID) Institution's unique internal identifier for the counterparty, as reported in the applicable counterparty table.
A counterparty can be the counterparty of a loan, but also e.g. the tenant of a real estate asset, the provider of a guarantee or similar.
Counterparty Group Identifier (ID) Institution's unique internal identifier for the Counterparty Group, as reported in the Counterparty Group table.
Contract Identifier (ID) Institutions internal identifier for e.g. a loan (loan table) or for e.g. deposits held with third parties (table "Cash & deposits & similar").
The Contract ID is similarly applicable to commitments or financial guarantees provided (off balance sheet positions).
Collateral Identifier (ID) Institutions internal identifier for the collateral, as reported in the applicable collateral table
A guarantee received from a third party would similarly have a Collateral ID.
Unique internal identifier (ID) for a liability A deposit held with the institution would be identified through its internal identifier for respective liability.
Table 1: linking the Counterparty, Counterparty Group and loan (the latter identified through a Contract ID)
Relationship definitions:
- A contract (i.e. a loan, loan commitment provided, financial guarantee provided, deposit held with a third party) can have one or more counterparty/ies,
- one counterparty can have many loan or similar contracts (loans, deposit held with third parties, loan commitments or finanial guarantees provided),
- a counterparty can be, but does not have to be, part of a counterparty group.
Example: Counterparties A and B are part of the same counterparty group and have each two loans.
Counterparty ID Counterparty Group Contract ID
Counterparty_A CG_4156 C_0011, C_3201
Counterparty_B CG_4156 C_2204, C_4002
Counterparty_C n/a C_5010
Example: The links between these identifiers could be reported in the following way in the linking table:
Counterparty ID Counterparty Group Contract ID
Counterparty_A CG_4156 C_0011
Counterparty_A CG_4156 C_3201
Counterparty_B CG_4156 C_2204
Counterparty_B CG_4156 C_4002
Counterparty_C n/a C_5010
Table 2: linking e.g. loans (i.e. Contract IDs) and collaterals (i.e. Collateral IDs), and at the same time considering an institution's lien position
Relationship definitions:
- A loan, loan commitment provided, financial guarantee provided or deposit held with a third party can have multiple collaterals,
- a collateral (e.g. a real estate asset) might be used as collateral for several contracts,
- how much of the collateral's value can "effectively" be used also depends on an institution's position in the waterfall in case it does not have a first lien position.
Example: Several loans are collaterallised by different collaterals. The institution does not have the first lien for all of these collaterals.
Contract ID Collateral ID
C_0011 Col_VVAA: first lien (100% of the collateral can be used by the bank), collateral used in full for this one loan
C_3201 Col_DDBB: second lien, 50% of the collateral's value (according to the waterfall) effectively collateralise 20% of the loan.
C_2204, C_4002 Col_KKQQ: first lien (100% of the collateral can be used by the bank); 100% of loan C_2204 and 20% of loan C_4002 are collateralised
C_5010 Col_PPRRR: first lien (100% of it can be used by the bank), collateral used in full for this loan (only 50% of the loan are collateralised)
C_5010 Col_TTTUU: second lien, 20% of the collateral's value (according to the waterfall) effectively collateralise the remaining 50% of the loan.
Example: The links between these identifiers could be reported in the following way in the linking table:
Facility ID Collateral ID Lien: waterfall position % of total loan are collateralised
C_0011 Col_VVAA 100% 100%
C_3201 Col_DDBB 50% 20%
C_2204 Col_KKQQ 100% 100%
C_4002 Col_KKQQ 100% 20%
C_5010 Col_PPRRR 100% 50%
C_5010 Col_TTTUU 20% 50%
Table 3: linking a guarantee received (i.e. Collateral ID) with the guarantor (i.e. the guarantor being a counterparty with a Counterparty ID)
Relationship definitions:
- A contract (here: a guarantee received) can only have one counterparty,
- one counterparty can have provided several guarantees,
- the assumptions regarding counterparty groups apply similarly to Table 1.
Example: Counterparties A and B are providers of guarantees.
Counterparty ID Collateral ID (here: guarantees received)
Counterparty_A G_5041, G_5045
Counterparty_B G_7011
Example: The links between these identifiers could be reported in the following way in the linking table:
Counterparty ID Collateral ID
Counterparty_A G_5041
Counterparty_A G_5045
Counterparty_B G_7011
Table 4: linking real estate assets (here: flats rented to third parties) with their tenants (i.e. the tenants as counterparties)
Relationship definitions:
- A flat (here: a guarantee received) can have one tenant as counterparty,
- one counterparty can rent several flats (and then sub-rent them or doing other business there),
- the assumptions regarding counterparty groups apply similarly to Table 1.
Example: Counterparties A and B are tenants of flats, which are collaterals received by the institution.
Counterparty ID Collateral ID (here: flat used as collateral)
Counterparty_A FL_1001
Counterparty_B FL_2001, FL_3001
Example: The links between these identifiers could be reported in the following way in the linking table:
Counterparty ID Collateral ID
Counterparty_A FL_1001
Counterparty_B FL_2001
Counterparty_B FL_3001
Table 5: linking loans (i.e. Contract IDs) with deposits (identified through the "unique internal identifier for the liability") in case of a netting agreement or similar
This example assumes that a client's deposit at the institution is considered as a guarantee for the loan provided to this (or another) client.
Institution's unique internal identifier for the liability
Relationship definitions:
- For instance a loan can be collateralised (or e.g. similarly considered as "netted") with one or several deposits at the institution,
- one deposit (i.e. Contract ID) might be used as collateral for several loans,
- the respective loans and deposits would not need to have the same counterparties (on linking loans and counterparties see Table 1),
Example: Loan contrats and deposit contracts, which could e.g. be netted (the deposit as such be a guarantee like instrument for respective loan).
Contract ID Unique internal identifier (ID) for the liability
C_00110 L_1001, L_2001
C_32010 L_3001
C_22040, C_40020 L_4001
Example: The links between these identifiers could be reported in the following way in the linking table:
Contract ID ID for the liability
C_00110 L_1001
C_00110 L_2001
C_32010 L_3001
C_22040 L_4001
C_40020 L_4001
no reviews yet
Please Login to review.
