V_TRNSCTN_ID3

Validates if:

– every [simple_tooltip content='CRDT_FCLTY_UNQ_ID; An identifier applied by the reporting agent to uniquely identify each credit facility.']Credit facility unique identifier[/simple_tooltip]
from cube [simple_tooltip content='CRDT_FCLTS; The commitment (revocable or irrevocable) made by a financial institution to make an amount of money available to the customer (or a plurality of customers), or to assume for it an obligation to a third party. The commitment is based on an agreement between the financial institution and the customer, which originates from a request of the customer or an acceptance by the customer of a proposal from the financial institution.']Credit facilities[/simple_tooltip]
– is referred to by a [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 Credit facility (2)
from 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]

Scheme dependencies:

Transformation Scheme ID

V_TRNSCTN_ID3

Description

Validates whether credit facilities are referred in the “Transactions-counterparties” cube

Classification

Phase Type Subtype Related entity
Preparation Validation Integrity TRNSCTNS_CNTRPRTS

Natural language

Validates if:

– every Credit facility unique identifier
from cube Credit facilities
– is referred to by a Transaction identifier for which Type of transaction is Credit facility (2)
from cube Transactions-Counterparties

Scheme dependencies:

VTL Syntax

0 TRNSCTNS_CNTRPRTS_FLTRD := TRNSCTNS_CNTRPRTS [filter (TYP_TRNSCTN = "2"), keep (TRNSCTN_ID)];
1 call PRCDR_RFRNTL_INTGRTY (CRDT_FCLTS, CRDT_FCLTY_UNQ_ID, TRNSCTNS_CNTRPRTS_FLTRD, TRNSCTN_ID, V_TRNSCTN_ID3);