T_RGSTRY_TBL_SCRTS_E

This transformation scheme adds information (from the cube [simple_tooltip content='EXTRNL_CRDT_ASSSSMNT; All external credit assessments used in input cubes must be registered in this cube.']External credit assessments[/simple_tooltip]) to the cube [simple_tooltip content='RGSTRY_TBL_SCRTS; It contains the registry data of securities']Registry table of securities[/simple_tooltip].

Scheme dependencies:

Transformation Scheme ID

T_RGSTRY_TBL_SCRTS_E

Description

Registry table of securities enriched input layer

Classification

Phase Type Subtype Related entity
Enrichment Technical Other

Natural language

This transformation scheme adds information (from the cube External credit assessments) to the cube Registry table of securities.

Scheme dependencies:

VTL Syntax

0 RGSTRY_TBL_SCRTS_E := [inner RGSTRY_TBL_SCRTS 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)};
1 RGSTRY_TBL_SCRTS_E := RGSTRY_TBL_SCRTS_E [keep (SCRTY_ID, CLLTRL_LCTN, CRDT_QLTY_STP, CRRNCY_DNMNTN, DT_ISS, DT_MTRTY, DT_SCRTY_STTS, ECAI_ECA, EXTRNL_CRDT_ASSSSMNT, GRNTR_ID, IS_CVRD_BND, IS_LSTD, IS_PRTCLR_HGH_RSK, IS_SHRT_TRM_CRDT_ASSSSMNT, ISIN, ISSR_ID, PRMRY_ASST_CLSSFCTN, SCRTY_GRNT_LVL, SCRTY_LVL, SCRTY_RNK_LVL, SCRTY_STTS, TYP_ASST_SCRTSTN, TYP_INSTRMNT, UNT_MSR_NV)];