V_PRTCTN_RCVD_INSTRMNTS_PRTCTNS_ID1

Validates if:

– 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]
in cube [simple_tooltip content='PRTCTN_RCVD']Protection received[/simple_tooltip]
– is referred to by a [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]

Scheme dependencies:

Transformation Scheme ID

V_PRTCTN_RCVD_INSTRMNTS_PRTCTNS_ID1

Description

Validates that protection received is referred in the instruments-protections cube.

Classification

Phase Type Subtype Related entity
Preparation Validation Integrity PRTCTN_RCVD

Natural language

Validates if:

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

Scheme dependencies:

VTL Syntax

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