V_PSTV_CRRNT_ACCNT_CRDT_FCLTS_INSTRMNT_ID2

Validates if:

– for every [simple_tooltip content='INSTRMNT_UNQ_ID; An identifier applied by the reporting agent to uniquely identify each instrument.']Instrument unique identifier[/simple_tooltip]
in cube [simple_tooltip content='CRDT_FCLTS_INSTRMNTS; It contains the relationships between credit facilities and instruments.']Credit facilities-Instruments[/simple_tooltip]
– there is a corresponding [simple_tooltip content='INSTRMNT_UNQ_ID; An identifier applied by the reporting agent to uniquely identify each instrument.']Instrument unique identifier[/simple_tooltip]
in cube [simple_tooltip content='PSTV_CRRNT_ACCNT; Credit balances on current accounts.']Positive current accounts[/simple_tooltip]

Scheme dependencies:

Transformation Scheme ID

V_PSTV_CRRNT_ACCNT_CRDT_FCLTS_INSTRMNT_ID2

Description

Validates referential integrity of credit facilities instruments to positive current accounts.

Classification

Phase Type Subtype Related entity
Preparation Validation Integrity PSTV_CRRNT_ACCNT

Natural language

Validates if:

– for every Instrument unique identifier
in cube Credit facilities-Instruments
– there is a corresponding Instrument unique identifier
in cube Positive current accounts

Scheme dependencies:

VTL Syntax

0 call PRCDR_RFRNTL_INTGRTY (CRDT_FCLTS_INSTRMNTS, INSTRMNT_UNQ_ID, PSTV_CRRNT_ACCNT, INSTRMNT_UNQ_ID, V_PSTV_CRRNT_ACCNT_CRDT_FCLTS_INSTRMNT_ID2);