This transformation scheme sets up a dataset that will be used for the generation of the cube [simple_tooltip content='ANCRDT_JNT_LBLTS_C; The level of granularity for the joint liabilities data is the ‘counterparty-instrument’ combination. Each record is uniquely identified by the combination of the data attributes: (a) reporting agent identifier; (b) observed agent identifier; (c) counterparty identifier; (d) contract identifier; and (e) instrument identifier.
These data register the joint liability amount of the instrument that corresponds to each debtor that is jointly liable in relation to a single instrument.
In the case of natural persons being affiliated with instruments reported to AnaCredit, no record for the natural persons must be reported.
The records must be reported on a monthly basis.']Joint liabilities data – ECB Collection[/simple_tooltip] using the [simple_tooltip content='APPRCH_JNT_LBLTS; It identifies the approach followed by the reporting institution for joint liabilities.']Approach for joint liabilities[/simple_tooltip] A joint liability is not registered as a distinct counterparty (2).
[simple_tooltip content='This transformation scheme creates a dataset (LN_AC) that contains loans and Positive current accounts. Additionally the variables Observed agent identifier
and Reference date
are added to this dataset.']G_PRP_LNS
[simple_tooltip content='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
[simple_tooltip content='This transformation rule creates the credit facilities for the enriched input layer. ']T_CRDT_FCLTS_E
[simple_tooltip content='This transformation rule creates the credit facilities instruments for the enriched input layer. ']T_CRDT_FCLTS_INSTRMNTS_E
[simple_tooltip content='This transformation rule creates the positive current account for the enriched input layer. ']T_PSTV_CRRNT_ACCNT_E
[simple_tooltip content='This transformation rule creates the loans for the enriched input layer. ']T_LN_E
[simple_tooltip content='Creates a single dataset comprising all cubes within the "Loans" entity']T_UNN_LN
[simple_tooltip content='Where, for Transferable deposits
:- Connected factoring operation identifier
is by default null- Is credit line other than revolving credit
is by default Not applicable (0)- End date of the interest-only period
is by default null- Project finance loan
is by default Non-project finance loan (2)- if Is debt financing
is TRUE (T), then Purpose
is Debt financing (5)else Purposes other than real estate purchase, margin lending, debt financing, imports, exports, construction investment, working capital facility (11)- Repayment rights
is by default On demand or short notice (1)- Is revolving loan
is by default Not applicable (0)- Subordinated debt
is by default Non-subordinated debt (2)- Syndicated contract identifier
is by default null- Type of amortisation
is by default Amortisation types other than French, German, Fixed amortisation schedule or bullet (5)- Type of instrument
isTransferable deposits (1025)']D_IMPLCT_TRNSFRBL_DPSTS
[simple_tooltip content='This transformation rule creates the transaction counterpartiesfor the enriched input layer. ']T_TRNSCTNS_CNTRPRTS_E