V_LN_CRDT_FCLTS_INSTRMNT

Validates if:

– for every [simple_tooltip content='INSTRMNT_UNQ_ID; An identifier applied by the reporting agent to uniquely identify each instrument.']Instrument unique 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 Loan/Deposit (1)
in cube [simple_tooltip content='CRDT_FCLTS_INSTRMNTS; It contains the relationships between credit facilities and instruments.']Credit facilities-Instruments[/simple_tooltip]
– there is a corresponding [simple_tooltip content='INSTRMNT_UNQ_ID; An identifier applied by the reporting agent to uniquely identify each instrument.']Instrument unique identifier[/simple_tooltip]
in cube [simple_tooltip content='LN']Loan[/simple_tooltip]

Scheme dependencies:

Transformation Scheme ID

V_LN_CRDT_FCLTS_INSTRMNT

Description

Validates referential integrity of credit facilities-instruments to loans

Classification

Phase Type Subtype Related entity
Preparation Validation Integrity LN

Natural language

Validates if:

– for every Instrument unique identifier for which Type of transaction is Loan/Deposit (1)
in cube Credit facilities-Instruments
– there is a corresponding Instrument unique identifier
in cube Loan

Scheme dependencies:

VTL Syntax

0 CRDT_FCLTS_INSTRMNTS_FLTRD := CRDT_FCLTS_INSTRMNTS [filter (TYP_TRNSCTN = "1"), keep (INSTRMNT_UNQ_ID)];
1 call PRCDR_RFRNTL_INTGRTY (CRDT_FCLTS_INSTRMNTS_FLTRD, INSTRMNT_UNQ_ID, LN, INSTRMNT_UNQ_ID, V_LN_CRDT_FCLTS_INSTRMNT);