V_TRNSCTN_ID6

Validates if:

– for every [simple_tooltip content='TRNSCTN_ID; An identifier applied by the reporting agent to uniquely identify each transaction (loan/deposit, credit facility, guarantee, securitisation).']Transaction identifier[/simple_tooltip] for which [simple_tooltip content='TYP_TRNSCTN; It defines the type of transaction to which the transaction identifier refers.']Type of transaction[/simple_tooltip] is Protection received other than real estate (3)
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]
– there is a corresponding [simple_tooltip content='PRTCTN_ID; An identifier applied by the reporting agent to uniquely identify each protection (except for real estate protection) used to secure the instrument. Each protection must have one protection identifier. This value will not change over time and cannot be used as the protection identifier for any other protection.']Protection identifier[/simple_tooltip]
in cube [simple_tooltip content='PRTCTN_RCVD']Protection received[/simple_tooltip]

Scheme dependencies:

Transformation Scheme ID

V_TRNSCTN_ID6

Description

Validates referential integrity of transactions-counterparties referring to protections.

Classification

Phase Type Subtype Related entity
Preparation Validation Integrity PRTCTNS

Natural language

Validates if:

– for every Transaction identifier for which Type of transaction is Protection received other than real estate (3)
in cube Transactions-Counterparties
– there is a corresponding Protection identifier
in cube Protection received

Scheme dependencies:

VTL Syntax

0 TRNSCTNS_CNTRPRTS_FLTRD := TRNSCTNS_CNTRPRTS [filter (TYP_TRNSCTN = "3"), keep (TRNSCTN_ID)];
1 call PRCDR_RFRNTL_INTGRTY (TRNSCTNS_CNTRPRTS_FLTRD, TRNSCTN_ID, PRTCTN_RCVD, PRTCTN_ID, V_TRNSCTN_ID6);