V_LN_INSTRMNT_PRTCTNS_ID

Validates whether:

– 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] in cube [simple_tooltip content='INSTRMNTS_PRTCTNS; It contains the relationships between instruments and protections, for all instruments connected to one or more protections.']Instruments-protections[/simple_tooltip]
there exists one related record in cube [simple_tooltip content='LN']Loan[/simple_tooltip]

Scheme dependencies:

Transformation Scheme ID

V_LN_INSTRMNT_PRTCTNS_ID

Description

Validates that loans are referred in the instruments-protections cube.

Classification

Phase Type Subtype Related entity
Preparation Validation Integrity INSTRMNTS_PRTCTNS

Natural language

Validates whether:

– for every Instrument unique identifier in cube Instruments-protections
there exists one related record in cube Loan

Scheme dependencies:

VTL Syntax

0 call PRCDR_RFRNTL_INTGRTY (INSTRMNTS_PRTCTNS, INSTRMNT_UNQ_ID, LN, INSTRMNT_UNQ_ID, V_LN_INSTRMNT_PRTCTNS_ID);