V_SCRTS_PRTCTN_ID

Validates if:

– for every [simple_tooltip content='SCRTY_ID; An identifier to uniquely identify each security.']Security identifier[/simple_tooltip]
in cube [simple_tooltip content='SCRTS_PRTCTN; It contains the variables concerning the protection received data for securities.']Securities protection[/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_SCRTS_PRTCTN_ID

Description

Validates referential integrity of securities protection to protections received.

Classification

Phase Type Subtype Related entity
Preparation Validation Integrity PRTCTN_RCVD

Natural language

Validates if:

– for every Security identifier
in cube Securities protection
– there is a corresponding Protection identifier
in cube Protection received

Scheme dependencies:

VTL Syntax

0 call PRCDR_RFRNTL_INTGRTY (SCRTS_PRTCTN, SCRTY_ID, PRTCTN_RCVD, PRTCTN_ID, V_SCRTS_PRTCTN_ID);