G_TRNSCTNS_CNTRPRTS

Transformation scheme to “transpose” (row to column) the content of the cube [simple_tooltip content='TRNSCTNS_CNTRPRTS_E']Transactions-Counterparties – Enriched[/simple_tooltip] in the sense that all [simple_tooltip content='CNTRPRTY_ID; An identifier applied by the reporting agent to uniquely identify each counterparty. Each counterparty must have one counterparty identifier. This value will not change over time and cannot be used as the counterparty identifier for any other counterparty.']Counterparty identifier[/simple_tooltip] for different roles (i.e. members of the domain Counterparty role in a transaction (CNTRPRTY_RL)) for the same [simple_tooltip content='INSTRMNT_UNQ_ID; An identifier applied by the reporting agent to uniquely identify each instrument.']Instrument unique identifier[/simple_tooltip] are represented as individual variables (i.e. Debtor identifier (DBTR_ID), Servicer identifier (SRVCR_ID) and Beneficiary identifier (BNFCRY_ID)) resulting in the following structure: [simple_tooltip content='INSTRMNT_UNQ_ID; An identifier applied by the reporting agent to uniquely identify each instrument.']Instrument unique identifier[/simple_tooltip], Debtor identifier, Servicer identifier, Beneficiary identifier, Servicer of a securitisation identifier, Originator of a securitisation identifier.

Scheme dependencies:

Transformation Scheme ID

G_TRNSCTNS_CNTRPRTS

Description

Preparation of a dataset containing explicit information about counterparties of transactions

Classification

Phase Type Subtype Related entity
Generation Generation AnaCredit

Natural language

Transformation scheme to “transpose” (row to column) the content of the cube Transactions-Counterparties – Enriched in the sense that all Counterparty identifier for different roles (i.e. members of the domain Counterparty role in a transaction (CNTRPRTY_RL)) for the same Instrument unique identifier are represented as individual variables (i.e. Debtor identifier (DBTR_ID), Servicer identifier (SRVCR_ID) and Beneficiary identifier (BNFCRY_ID)) resulting in the following structure: Instrument unique identifier, Debtor identifier, Servicer identifier, Beneficiary identifier, Servicer of a securitisation identifier, Originator of a securitisation identifier.

Scheme dependencies:

VTL Syntax

0 TRNSCTNS_CNTRPRTS_DBTR := TRNSCTNS_CNTRPRTS_E [filter (TYP_TRNSCTN = "1" and CNTRPRTY_RL = "1"), keep (TRNSCTN_ID as "INSTRMNT_UNQ_ID")];
1 TRNSCTNS_CNTRPRTS_SRVCR := TRNSCTNS_CNTRPRTS_E [filter (TYP_TRNSCTN = "1" and CNTRPRTY_RL = "3"), keep (TRNSCTN_ID as "INSTRMNT_UNQ_ID")];
2 TRNSCTNS_CNTRPRTS_BNFCRY := TRNSCTNS_CNTRPRTS_E [filter (TYP_TRNSCTN = "1" and CNTRPRTY_RL = "6"), keep (TRNSCTN_ID as "INSTRMNT_UNQ_ID")];
3 TRNSCTNS_CNTRPRTS_SRVCR_SCRTSTN := TRNSCTNS_CNTRPRTS_E [filter (TYP_TRNSCTN = "4" and CNTRPRTY_RL = "3"), keep (TRNSCTN_ID as "SCRTSTN_TRNSFR_ID")];
4 TRNSCTNS_CNTRPRTS_ORGNTR_SCRTSTN := TRNSCTNS_CNTRPRTS_E [filter (TYP_TRNSCTN = "4" and CNTRPRTY_RL = "4"), keep (TRNSCTN_ID as "SCRTSTN_TRNSFR_ID")];
5 TRNSCTNS_CNTRPRTS_INSTRMNT_RLS := LN_AC [keep (INSTRMNT_UNQ_ID, SCRTSTN_TRNSFR_ID)];
6 TRNSCTNS_CNTRPRTS_INSTRMNT_RLS := [left TRNSCTNS_CNTRPRTS_INSTRMNT_RLS as "A", TRNSCTNS_CNTRPRTS_DBTR as "B" on A.INSTRMNT_UNQ_ID = B.INSTRMNT_UNQ_ID] {keep (A.INSTRMNT_UNQ_ID, B.DBTR_ID)};
7 TRNSCTNS_CNTRPRTS_INSTRMNT_RLS := [left TRNSCTNS_CNTRPRTS_INSTRMNT_RLS as "A", TRNSCTNS_CNTRPRTS_SRVCR as "B" on A.INSTRMNT_UNQ_ID = B.INSTRMNT_UNQ_ID] {keep (A.INSTRMNT_UNQ_ID, A.DBTR_ID, B.SRVCR_ID)};
8 TRNSCTNS_CNTRPRTS_INSTRMNT_RLS := [left TRNSCTNS_CNTRPRTS_INSTRMNT_RLS as "A", TRNSCTNS_CNTRPRTS_BNFCRY as "B" on A.INSTRMNT_UNQ_ID = B.INSTRMNT_UNQ_ID] {keep (A.INSTRMNT_UNQ_ID, A.DBTR_ID, A.SRVCR_ID, B.BNFCRY_ID)};
9 TRNSCTNS_CNTRPRTS_INSTRMNT_RLS := [left TRNSCTNS_CNTRPRTS_INSTRMNT_RLS as "A", TRNSCTNS_CNTRPRTS_SRVCR_SCRTSTN as "B" on A.SCRTSTN_TRNSFR_ID = B.SCRTSTN_TRNSFR_ID] {keep (A.INSTRMNT_UNQ_ID, A.DBTR_ID, A.SRVCR_ID, A.BNFCRY_ID, B.SRVCR_SCRTSTN_ID)};
10 TRNSCTNS_CNTRPRTS_INSTRMNT_RLS := [left TRNSCTNS_CNTRPRTS_INSTRMNT_RLS as "A", TRNSCTNS_CNTRPRTS_SRVCR_SCRTSTN as "B" on A.SCRTSTN_TRNSFR_ID = B.SCRTSTN_TRNSFR_ID] {keep (A.INSTRMNT_UNQ_ID, A.DBTR_ID, A.SRVCR_ID, A.BNFCRY_ID, A.SRVCR_SCRTSTN_ID, B.ORGNTR_SCRTSTN_ID)};