T_CNTRPRTS_E

This transformation rule creates the counterparties for the enriched input layer.

Scheme dependencies:

    [simple_tooltip content='This transformation rule creates the counterparties for the enriched input layer. ']T_CNTRPRTS_E[/simple_tooltip]
    [simple_tooltip content='Create datasets, respectively containing:

    - counterparties that are either Not an enterprise (1) or an Autonomous enterprise (2)
    and for which enterprise size is calculated
    - calculated values for the previous period
    where missing values are assigned as null
    - counterparties for which size is already provided in a structure comparable to the calculations

    Aggregation of values:

    - for Partner enterprises relevant figures have to multiplied by the percentage of interest in the capital of voting rights
    - for Group enterprises relevant figures are taken from group data
    - relevant figures for all counterparties are aggregated until there is one single value for each counterparty

    The preliminary setting is:
    - the pure calculation of enterprise size before considering previous period results
    where Enterprise size (preliminary) is spread out in brackets determing by thresholds of the aggregated values of Number of employees and Balance sheet total

    The final setting takes into account:
    - if the enterprise is Not an enterprise (1)
    - if the enterprise is controlled by public bodies
    - if there was no input data (Enterprise size (preliminary) is Large enterprise because of absence of input data (7))
    - there was no information for previous periods
    - mergers and acquisitions exception applies
    - in any other case: the interaction between the result of the calculation for current period plus results for previous period applies

    Calculated enterprise size is thus a union of:
    - the final setting
    - data for counterparties for which size was already provided']D_ENTRPRS_SZ_CLCLTD1[/simple_tooltip]
    [simple_tooltip content='Get Partner enterprises data']T_GT_PRTNR_ENTRPRSS[/simple_tooltip]
    [simple_tooltip content='Get Enterprise size (previous period) data']T_GT_ENTRPRS_SZ_PRVS_PRD[/simple_tooltip]
    [simple_tooltip content='Get Group counterparty relationship data']T_GT_GRP_CNTRPRTY_RLTNSHP[/simple_tooltip]
    [simple_tooltip content='Get Linked enterprises data']T_GT_LNKD_ENTRPRSS[/simple_tooltip]
    [simple_tooltip content='Get Group data data']T_GT_GRP_DT[/simple_tooltip]
    [simple_tooltip content='Get External credit assessments data']T_GT_EXTRNL_CRDT_ASSSSMNT[/simple_tooltip]
    [simple_tooltip content='Get Counterparties data']T_GT_CNTRPRTS[/simple_tooltip]

Transformation Scheme ID

T_CNTRPRTS_E

Description

Counterparties enriched input layer.

Classification

Phase Type Subtype Related entity
Enrichment Technical Other CNTRPRTS_E

Natural language

This transformation rule creates the counterparties for the enriched input layer.

Scheme dependencies:

VTL Syntax

0 CNTRPRTS_E := [inner CNTRPRTS as "A", D_ENTRPRS_SZ_CLCLTD1 as "B" on A.CNTRPRTY_ID = B.CNTRPRTY_ID] {keep (A.ALL_VARIABLES, B.ENTRPRS_SZ, B.IS_DRVD_ENTRPRS_SZ)};
1 CNTRPRTS_E := [inner CNTRPRTS_E as "A", EXTRNL_CRDT_ASSSSMNT as "B" on A.EXTRNL_CRDT_ASSSSMNT = B.EXTRNL_CRDT_ASSSSMNT] {keep (A.ALL_VARIABLES, B.CRDT_QLTY_STP, B.ECAI_ECA, B.IS_SHRT_TRM_CRDT_ASSSSMNT)};
2 CNTRPRTS_E := CNTRPRTS_E [keep (CNTRPRTY_ID, ANNL_TRNVR, APPRCH_PRDNTL_PRPSS, BLNC_SHT_TTL, CNTRL_PBLC_BDS, CNTRY, CRDT_QLTY_STP, CRDT_QLTY_STTS, CTY, DT_DFLT_STTS, DT_ENTRPRS_SZ, DT_INTTN_LGL_PRCDNGS, DT_PRFRMNG_STTS, ECAI_ECA, ECNMC_ACTVTY, ENTRPRS_SZ, ENTRPRS_SZ_CHC, HD_OFFC_UNDRT_ID, IMMDT_PRNT_UNDRT_ID, INSTTTNL_SCTR, INSTTTNL_SCTR_CNTRL, INTRNTNL_ORGNSTN, IS_PLLNG_EFFCT, IS_SHRT_TRM_CRDT_ASSSSMNT, LEI, LGL_FRM, LGL_PRCDNG_STTS, NM_ENTTY, NMBR_EMPLYS, NTNL_ID, PSTL_CD, STRT, TRRTRL_UNT, TYP_ENTRPRS, ULTMT_PRNT_UNDRT_ID, IS_DRVD_ENTRPRS_SZ)];