V_CNTRPRTY_RL1

Validates if:

– for every instance in “instrument cubes” (ones where “RELATED_ENTITY” of table “CUBE” equals “LN”)
there exists a related record in cube [simple_tooltip content='TRNSCTNS_CNTRPRTS; It contains the relationships between transactions and counterparties, for all transactions where the counterparty is relevant for reporting purposes.']Transactions-Counterparties[/simple_tooltip]
– where [simple_tooltip content='CNTRPRTY_RL; Role of the counterparty in a transaction.']Counterparty role in a transaction[/simple_tooltip] is Debtor (1)

Scheme dependencies:

Transformation Scheme ID

V_CNTRPRTY_RL1

Description

Validation whether every instrument has a debtor

Classification

Phase Type Subtype Related entity
Preparation Validation Completeness TRNSCTNS_CNTRPRTS

Natural language

Validates if:

– for every instance in “instrument cubes” (ones where “RELATED_ENTITY” of table “CUBE” equals “LN”)
there exists a related record in cube Transactions-Counterparties
– where Counterparty role in a transaction is Debtor (1)

Scheme dependencies:

VTL Syntax

0 TRNSCTNS_CNTRPRTS_FLTRD := TRNSCTNS_CNTRPRTS [filter (CNTRPRTY_RL = "1"), keep (TRNSCTN_ID)];
1 call PRCDR_RFRNTL_INTGRTY (LN, INSTRMNT_UNQ_ID, TRNSCTNS_CNTRPRTS_FLTRD, TRNSCTN_ID, V_CNTRPRTY_RL1);