G_SHSG4_GROUP

This transformation scheme generates the cube [simple_tooltip content='SHSG4_GROUP']SHS Group data reporting – Group data[/simple_tooltip].
Starting from the enriched input layer [simple_tooltip content='CNTRPRTS_E']Counterparties – Enriched[/simple_tooltip] we add additional information from the cube [simple_tooltip content='GRP; It includes the components of the group which the reporting institution belongs to.']Group[/simple_tooltip]. We then add the variable [simple_tooltip content='ACCNTNG_FRMWK_GRP; Specifies the accounting standard used for consolidated accounts']Accounting framework for group reporting[/simple_tooltip] and map the members of the variables [simple_tooltip content='INSTTTNL_SCTR; Institutional sectors in accordance with Regulation (EU) No 549/2013, Regulation (EU) No 575/2013 and Regulation (EU) No 1075/2013 of the European Central Bank (ECB/2013/40)(1).']Institutional sector[/simple_tooltip] and [simple_tooltip content='GRP_TYP; tyepe of group (insurance, bank, etc.)']Type of group[/simple_tooltip] onto the output domain.
Finally we reduce the structure of the dataset to match the cube [simple_tooltip content='SHSG4_GROUP']SHS Group data reporting – Group data[/simple_tooltip].

Scheme dependencies:

Transformation Scheme ID

G_SHSG4_GROUP

Description

Generation of the cube SHSG4_GROUP

Classification

Phase Type Subtype Related entity
Generation Generation SHS

Natural language

This transformation scheme generates the cube SHS Group data reporting – Group data.
Starting from the enriched input layer Counterparties – Enriched we add additional information from the cube Group. We then add the variable Accounting framework for group reporting and map the members of the variables Institutional sector and Type of group onto the output domain.
Finally we reduce the structure of the dataset to match the cube SHS Group data reporting – Group data.

Scheme dependencies:

VTL Syntax

0 CNTRPRTS_SUB := CNTRPRTS_E [keep (CNTRPRTY_ID, INSTTTNL_SCTR, LEI, NM_ENTTY)];
1 SHSG4_GROUP := [inner GRP as "A", CNTRPRTS_SUB as "B" on A.GRP_ID = B.CNTRPRTY_ID] {keep (A.GRP_ID role Identifier, A.GRP_TYP role Measure, B.LEI role Measure, B.NM_ENTTY role Measure, B.INSTTTNL_SCTR role Measure)};
2 SHSG4_GROUP := SHSG4_GROUP [calc CNSTNT_ACCNTNG_FRMWK_GRP as "ACCNTNG_FRMWK_GRP"];
3 SHSG4_GROUP := SHSG4_GROUP [calc (M_ENTITY_SECTOR (INSTTTNL_SCTR)) as "GROUP_SECTOR"];
4 SHSG4_GROUP := SHSG4_GROUP [calc (M_GROUP_TYPE (GRP_TYP)) as "GROUP_TYPE"];
5 SHSG4_GROUP := SHSG4_GROUP [rename (GRP_ID as "GROUP_ID" role Identifier, LEI as "GROUP_LEI", GROUP_TYPE, GROUP_SECTOR, NM_ENTTY as "GROUP_NAME", ACCNTNG_FRMWK_GRP as "GROUP_ACC_STANDARD")];