V_PRTCTN_RCVD_INSTRMNTS_PRTCTNS_ID2

Validates if:

– for every [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] 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='INSTRMNTS_PRTCTNS; It contains the relationships between instruments and protections, for all instruments connected to one or more protections.']Instruments-protections[/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_PRTCTN_RCVD_INSTRMNTS_PRTCTNS_ID2

Description

Validates referential integrity of instruments-protections to loans.

Classification

Phase Type Subtype Related entity
Preparation Validation Integrity INSTRMNTS_PRTCTNS

Natural language

Validates if:

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

Scheme dependencies:

VTL Syntax

0 INSTRMNTS_PRTCTNS_FLTRD := INSTRMNTS_PRTCTNS [filter (TYP_TRNSCTN = "3"), keep (PRTCTN_ID)];
1 call PRCDR_RFRNTL_INTGRTY (INSTRMNTS_PRTCTNS_FLTRD, PRTCTN_ID, PRTCTN_RCVD, PRTCTN_ID, V_PRTCTN_RCVD_INSTRMNTS_PRTCTNS_ID2);