V_RL_ESTT_PRTCTN_ID

Validates if:

– 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; It contains the variables concerning the protection received data for real estate.']Real estate protection[/simple_tooltip]
– is reffered to by a [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]

Scheme dependencies:

Transformation Scheme ID

V_RL_ESTT_PRTCTN_ID

Description

Validates that real estate protection is referred in the real estate protection claim item cube.

Classification

Phase Type Subtype Related entity
Preparation Validation Integrity RL_ESTT_PRTCTN

Natural language

Validates if:

– every Protection item identifier
in cube Real estate protection
– is reffered to by a Protection item identifier
in cube Real estate protection-Real estate claim

Scheme dependencies:

VTL Syntax

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