G_SHSG4_ENTITY

This transformation scheme generates the cube [simple_tooltip content='SHSG4_ENTITY']SHS Group data reporting – Entity 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 than 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] on the output domain and create the variable [simple_tooltip content='ENTITY_AREA; Country of legal incorporation or domicile of the entity (ISO 3166) ']Country of residency of the entity[/simple_tooltip].
Finally we reduce the structure of the dataset to match the variables of the cube [simple_tooltip content='SHSG4_ENTITY']SHS Group data reporting – Entity data[/simple_tooltip].

Scheme dependencies:

Transformation Scheme ID

G_SHSG4_ENTITY

Description

Setup of the dataset Entity information

Classification

Phase Type Subtype Related entity
Generation Generation SHS

Natural language

This transformation scheme generates the cube SHS Group data reporting – Entity data.
Starting from the enriched input layer Counterparties – Enriched we add additional information from the cube Group. We than map the members of the variables Institutional sector on the output domain and create the variable Country of residency of the entity.
Finally we reduce the structure of the dataset to match the variables of the cube SHS Group data reporting – Entity data.

Scheme dependencies:

VTL Syntax

0 CNTRPRTS_SUB := CNTRPRTS_E [keep (CNTRPRTY_ID, INSTTTNL_SCTR, LEI, NM_ENTTY, ACCNTNG_FRMWK_SL, INTRNTNL_ORGNSTN, CNTRY, IMMDT_PRNT_UNDRT_ID)];
1 SHSG4_ENTITY := [inner GRP as "A", CNTRPRTS_SUB as "B" on A.LGL_ENTTY_ID = B.CNTRPRTY_ID] {keep (A.GRP_ID role Identifier, A.LGL_ENTTY_ID role Identifier, B.LEI role Measure, B.NM_ENTTY role Measure, B.INSTTTNL_SCTR role Measure, B.ACCNTNG_FRMWK_SL role Measure, B.INTRNTNL_ORGNSTN role Measure, B.CNTRY role Measure, B.IMMDT_PRNT_UNDRT_ID role Measure)};
2 SHSG4_ENTITY := SHSG4_ENTITY [calc (M_ENTITY_SECTOR (INSTTTNL_SCTR)) as "ENTITY_SECTOR"];
3 SHSG4_ENTITY := SHSG4_ENTITY [calc (G_ENTITY_AREA1 (CNTRY, INTRNTNL_ORGNSTN)) as "ENTITY_AREA"];
4 SHSG4_ENTITY := SHSG4_ENTITY [keep (GRP_ID as "GROUP_ID" role Identifier, LGL_ENTTY_ID as "ENTITY_ID" role Identifier, LEI as "ENTITY_LEI" role Measure, NM_ENTTY as "ENTITY_NAME" role Measure, ENTITY_SECTOR role Measure, ACCNTNG_FRMWK_SL as "ENTITY_ACC_STANDARD" role Measure, ENTITY_AREA role Measure, IMMDT_PRNT_UNDRT_ID as "IMMEDIATE_PARENT_ID" role Measure)];