V_RGSTRY_TBL_SCRTS_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='OWND_SCRTY; It contains the information on securities that are hold by the observed agent']Owned securities[/simple_tooltip]
– there is a corresponding [simple_tooltip content='SCRTY_ID; An identifier to uniquely identify each security.']Security identifier[/simple_tooltip]
in cube [simple_tooltip content='RGSTRY_TBL_SCRTS; It contains the registry data of securities']Registry table of securities[/simple_tooltip]

Scheme dependencies:

Transformation Scheme ID

V_RGSTRY_TBL_SCRTS_ID

Description

Validates referential integrity of owned security to registry table securities.

Classification

Phase Type Subtype Related entity
Preparation Validation Integrity RGSTRY_TBL_SCRTS

Natural language

Validates if:

– for every Security identifier
in cube Owned securities
– there is a corresponding Security identifier
in cube Registry table of securities

Scheme dependencies:

VTL Syntax

0 call PRCDR_RFRNTL_INTGRTY (OWND_SCRTY, SCRTY_ID, RGSTRY_TBL_SCRTS, SCRTY_ID, V_RGSTRY_TBL_SCRTS_ID);