V_RL_ESTT_PRTCTN_CLM_ID

Validates if:

– every [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]
from cube [simple_tooltip content='RL_ESTT_CLM; It contains all claims on real estate protection items.']Real estate claim[/simple_tooltip]
– is referred to by a [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]
from 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_CLM_ID

Description

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

Classification

Phase Type Subtype Related entity
Preparation Validation Integrity RL_ESTT_PRTCTN_CLM

Natural language

Validates if:

– every Protection identifier
from cube Real estate claim
– is referred to by a Protection identifier
from cube Real estate protection-Real estate claim

Scheme dependencies:

VTL Syntax

0 call PRCDR_RFRNTL_INTGRTY (RL_ESTT_CLM, PRTCTN_ID, RL_ESTT_PRTCTN_CLM, PRTCTN_ID, V_RL_ESTT_PRTCTN_CLM_ID);