V_JNT_LBLTY_AMNT1

Validates if:

– [simple_tooltip content='OTSTNDNG_NMNL_AMNT; Principal amount outstanding at the end of the reporting reference date, including unpaid past due interest but excluding accrued interest. The outstanding nominal amount must be reported net of write-offs and write-downs as determined by the relevant accounting practices.']Outstanding nominal amount[/simple_tooltip] of each instrument (identified by [simple_tooltip content='INSTRMNT_UNQ_ID; An identifier applied by the reporting agent to uniquely identify each instrument.']Instrument unique identifier[/simple_tooltip])
is greater or equal to:
– [simple_tooltip content='JNT_LBLTY_AMNT; Outstanding nominal amount for which each debtor is liable in relation to a single instrument where there are two or more debtors.']Joint liability amount[/simple_tooltip] of each [simple_tooltip content='CNTRPRTY_ID; An identifier applied by the reporting agent to uniquely identify each counterparty. Each counterparty must have one counterparty identifier. This value will not change over time and cannot be used as the counterparty identifier for any other counterparty.']Counterparty identifier[/simple_tooltip] connected to the instrument in [simple_tooltip content='TRNSCTNS_CNTRPRTS; It contains the relationships between transactions and counterparties, for all transactions where the counterparty is relevant for reporting purposes.']Transactions-Counterparties[/simple_tooltip] cube

Scheme dependencies:

Transformation Scheme ID

V_JNT_LBLTY_AMNT1

Description

Consistency check of “Outstanding nominal amount” with respect to the “Joint liability amount”

Classification

Phase Type Subtype Related entity
Preparation Validation Consistency LN

Natural language

Validates if:

Outstanding nominal amount of each instrument (identified by Instrument unique identifier)
is greater or equal to:
Joint liability amount of each Counterparty identifier connected to the instrument in Transactions-Counterparties cube

Scheme dependencies:

VTL Syntax

0 TRNSCTNS_CNTRPRTS_FLTRD := TRNSCTNS_CNTRPRTS [filter (TYP_TRNSCTN = "1"), keep (TRNSCTN_ID, CNTRPRTY_ID, JNT_LBLTY_AMNT)];
1 INFO_SET := [inner TRNSCTNS_CNTRPRTS_FLTRD as "A", LN_AC as "B" on A.TRNSCTN_ID = B.INSTRMNT_UNQ_ID] {keep (B.OTSTNDNG_NMNL_AMNT, B.INSTRMNT_UNQ_ID, A.CNTRPRTY_ID, A.JNT_LBLTY_AMNT)};
2 INFO_SET := INFO_SET [calc OTSTNDNG_NMNL_AMNT >= JNT_LBLTY_AMNT as "RSLT"];
3 V_JNT_LBLTY_AMNT1 := INFO_SET [filter (V_JNT_LBLTY_AMNT1 = RSLT), keep (INSTRMNT_UNQ_ID, CNTRPRTY_ID)];
4 V_JNT_LBLTY_AMNT1 := V_JNT_LBLTY_AMNT1 [calc V_JNT_LBLTY_AMNT1 as "VLDTN_ID" role Measure];