V_GRP_INTRNL_ID1

Validates if:

– for every [simple_tooltip content='GRP_INTRNL_ID; Identifier of the group whose consolidated data are used in the calculation of the enterprise size.']Group internal identifier[/simple_tooltip]
in cube [simple_tooltip content='GRP_CNTRPRTY_RLTNSHP; It connects all groups whose consolidated data are present in the cube "Group data" to the counterparties for which these data are used in the calculation of the enterprise size.']Group counterparty relationship[/simple_tooltip]
– there is a corresponding [simple_tooltip content='GRP_INTRNL_ID; Identifier of the group whose consolidated data are used in the calculation of the enterprise size.']Group internal identifier[/simple_tooltip]
in cube [simple_tooltip content='GRP_DT; It includes, where they exist, data originating from the consolidated accounts of the counterparty or from the consolidated accounts in which the counterparty is included through consolidation. It also includes, if they exist, data originating from the consolidated accounts of linked enterprises, unless their accounts data are already included through consolidation. Where in the consolidated accounts no staff data appear for a given enterprise, staff figures (to be included in this cube) are calculated by aggregating proportionally the data from its partner enterprises and by adding the data from the enterprises to which the enterprise in question is linked.']Group data[/simple_tooltip]

Scheme dependencies:

Transformation Scheme ID

V_GRP_INTRNL_ID1

Description

Referencial integrity check for “Group internal identifier”

Classification

Phase Type Subtype Related entity
Preparation Validation Integrity GRP_DT

Natural language

Validates if:

– for every Group internal identifier
in cube Group counterparty relationship
– there is a corresponding Group internal identifier
in cube Group data

Scheme dependencies:

VTL Syntax

0 call PRCDR_RFRNTL_INTGRTY (GRP_CNTRPRTY_RLTNSHP, GRP_INTRNL_ID, GRP_DT, GRP_INTRNL_ID, V_GRP_INTRNL_ID1);
1 call PRCDR_RFRNTL_INTGRTY (GRP_DT, GRP_INTRNL_ID, GRP_CNTRPRTY_RLTNSHP, GRP_INTRNL_ID, V_GRP_INTRNL_ID1);