V_INSTRMNTS_PRTCTNS_ID1

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

Scheme dependencies:

Transformation Scheme ID

V_INSTRMNTS_PRTCTNS_ID1

Description

Validates that instruments protections are referred to real estate claim.

Classification

Phase Type Subtype Related entity
Preparation Validation Integrity RL_ESTT_CLM

Natural language

Validates if:

– for every Protection identifier for which Type of transaction is Real estate protection (6)
in cube Instruments-protections
– there is a corresponding Protection identifier
in cube Real estate claim

Scheme dependencies:

VTL Syntax

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