V_RL_ESTT_PRTCTN_ID2

Validates if:

– for every [simple_tooltip content='PRTCTN_ITM_ID; An identifier applied by the reporting agent to uniquely identify each real estate. Each real estate must have one Protection item identifier. This value will not change over time and cannot be used as the Protection item identifier for any other protection.']Protection item identifier[/simple_tooltip]
in cube [simple_tooltip content='RL_ESTT_PRTCTN_CLM; It contains information about the relation between real estate protections and claims on such real estate protections.']Real estate protection-Real estate claim[/simple_tooltip]
– there is a corresponding [simple_tooltip content='PRTCTN_ITM_ID; An identifier applied by the reporting agent to uniquely identify each real estate. Each real estate must have one Protection item identifier. This value will not change over time and cannot be used as the Protection item identifier for any other protection.']Protection item identifier[/simple_tooltip]
in cube [simple_tooltip content='RL_ESTT_PRTCTN; It contains the variables concerning the protection received data for real estate.']Real estate protection[/simple_tooltip]

Scheme dependencies:

Transformation Scheme ID

V_RL_ESTT_PRTCTN_ID2

Description

Validates referential integrity of real estate protection claim to real estate protection cube.

Classification

Phase Type Subtype Related entity
Preparation Validation Integrity RL_ESTT_PRTCTN_CLM

Natural language

Validates if:

– for every Protection item identifier
in cube Real estate protection-Real estate claim
– there is a corresponding Protection item identifier
in cube Real estate protection

Scheme dependencies:

VTL Syntax

0 call PRCDR_RFRNTL_INTGRTY (RL_ESTT_PRTCTN_CLM, PRTCTN_ITM_ID, RL_ESTT_PRTCTN, PRTCTN_ITM_ID, V_RL_ESTT_PRTCTN_ID2);