G_CRDT_FCLTS_INSTRMNTS_CRDT_FCLTS

In many cases we encounter the situation that we need to transfer information from a credit facility to a related instrument. In case such an instrument is connected to more than one credit facility we need to take into account the credit facility with the lowest value in the variable [simple_tooltip content='DT_INCPTN; The date on which the current contractual relationship originated, i.e. the date on which the contract agreement became binding for all parties.']Inception date[/simple_tooltip]. The following transformation scheme provide a dataset having the variables of the cubes [simple_tooltip content='CRDT_FCLTS_INSTRMNTS; It contains the relationships between credit facilities and instruments.']Credit facilities-Instruments[/simple_tooltip] and [simple_tooltip content='CRDT_FCLTS; The commitment (revocable or irrevocable) made by a financial institution to make an amount of money available to the customer (or a plurality of customers), or to assume for it an obligation to a third party. The commitment is based on an agreement between the financial institution and the customer, which originates from a request of the customer or an acceptance by the customer of a proposal from the financial institution.']Credit facilities[/simple_tooltip] but containing only those instances, where the credit facility represents the one with the lowest value in the variable [simple_tooltip content='DT_INCPTN; The date on which the current contractual relationship originated, i.e. the date on which the contract agreement became binding for all parties.']Inception date[/simple_tooltip] (for each [simple_tooltip content='INSTRMNT_UNQ_ID; An identifier applied by the reporting agent to uniquely identify each instrument.']Instrument unique identifier[/simple_tooltip]).

Scheme dependencies:

Transformation Scheme ID

G_CRDT_FCLTS_INSTRMNTS_CRDT_FCLTS

Description

Generation of unique credit facilities for each instrument.

Classification

Phase Type Subtype Related entity
Generation Generation AnaCredit

Natural language

In many cases we encounter the situation that we need to transfer information from a credit facility to a related instrument. In case such an instrument is connected to more than one credit facility we need to take into account the credit facility with the lowest value in the variable Inception date. The following transformation scheme provide a dataset having the variables of the cubes Credit facilities-Instruments and Credit facilities but containing only those instances, where the credit facility represents the one with the lowest value in the variable Inception date (for each Instrument unique identifier).

Scheme dependencies:

VTL Syntax

0 CRDT_FCLTS_INSTRMNTS_CRDT_FCLTS := [inner CRDT_FCLTS_INSTRMNTS_E as "A", CRDT_FCLTS_E as "B" on A.CRDT_FCLTY_UNQ_ID = B.CRDT_FCLTY_UNQ_ID] {};
1 CRDT_FCLTS_INSTRMNTS_CRDT_FCLTS_SUB := min (CRDT_FCLTS_INSTRMNTS_CRDT_FCLTS.DT_INCPTN) group by (INSTRMNT_UNQ_ID);
2 UNQ_CRDT_FCLTS_INSTRMNTS := [inner CRDT_FCLTS_INSTRMNTS_CRDT_FCLTS as "A", CRDT_FCLTS_INSTRMNTS_CRDT_FCLTS_SUB as "B" on A.INSTRMNT_UNQ_ID = B.INSTRMNT_UNQ_ID and A.DT_INCPTN = B.DT_INCPTN] {};