V_INSTRMNTS_PRTCTNS_ID2

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]
from cube [simple_tooltip content='RL_ESTT_CLM; It contains all claims on real estate protection items.']Real estate claim[/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 Real estate protection (6)
from 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_INSTRMNTS_PRTCTNS_ID2

Description

Validates referential integrity of real estate claim to instruments protections.

Classification

Phase Type Subtype Related entity
Preparation Validation Integrity INSTRMNTS_PRTCTNS

Natural language

Validates if:

– every Protection identifier
from cube Real estate claim
– is referred to by a Protection identifier for which Type of transaction is Real estate protection (6)
from cube Instruments-protections

Scheme dependencies:

VTL Syntax

0 INSTRMNTS_PRTCTNS_FLTRD := INSTRMNTS_PRTCTNS [filter (TYP_TRNSCTN = "6"), keep (PRTCTN_ID)];
1 call PRCDR_RFRNTL_INTGRTY (RL_ESTT_CLM, PRTCTN_ID, INSTRMNTS_PRTCTNS_FLTRD, PRTCTN_ID, V_INSTRMNTS_PRTCTNS_ID2);