V_RGSTRY_TBL_SCRTS_CNTRPRTS_ID

Validates if:

– for every [simple_tooltip content='ISSR_ID; The counterparty identifier of the issuer of the security.']Issuer identifier[/simple_tooltip]
in cube [simple_tooltip content='RGSTRY_TBL_SCRTS; It contains the registry data of securities']Registry table of securities[/simple_tooltip]
– there is a corresponding [simple_tooltip content='CNTRPRTY_ID; An identifier applied by the reporting agent to uniquely identify each counterparty. Each counterparty must have one counterparty identifier. This value will not change over time and cannot be used as the counterparty identifier for any other counterparty.']Counterparty identifier[/simple_tooltip]
in cube [simple_tooltip content='CNTRPRTS; It contains all counterparties that are relevant for reporting purposes. It includes the institution that processes the data and the components (head office, foreign branches) of the legal entity to which it belongs. The institution shall ensure that in the input layer each counterparty is uniquely identified by its counterparty identifier (variable “CNTRPRTY_ID”).']Counterparties[/simple_tooltip]

Scheme dependencies:

Transformation Scheme ID

V_RGSTRY_TBL_SCRTS_CNTRPRTS_ID

Description

Validates referential integrity of registry table securities to counterparties.

Classification

Phase Type Subtype Related entity
Preparation Validation Integrity CNTRPRTSS

Natural language

Validates if:

– for every Issuer identifier
in cube Registry table of securities
– there is a corresponding Counterparty identifier
in cube Counterparties

Scheme dependencies:

VTL Syntax

0 call PRCDR_RFRNTL_INTGRTY (RGSTRY_TBL_SCRTS, ISSR_ID, CNTRPRTS, CNTRPRTY_ID, V_RGSTRY_TBL_SCRTS_CNTRPRTS_ID);