Hi, I downloaded the field "RCSCoveredBondGenealogy" and it is populated by codes, such as "A:3X\\A:

Sample instrument: DE000A1MLRP0

I downloaded the field "RCSCoveredBondGenealogy" and it is populated by codes, such as "A:3X\\A:NW". How do I interpret those field? Is there a glossary or a guide to decrypt them?

this is my query: response = search.Definition(view = search.Views.GOV_CORP_INSTRUMENTS,top = 10000,filter = "((DbType eq 'CORP') and RCSAssetCategory eq 'A:J' and ((IssueDate ge 2012-01-01 and IssueDate le 2012-02-01")))",navigators = "IssueDate(calc:sum_FaceIssuedUSD,calc:sum_FaceOutstandingUSD,calc:sum_FaceIssuedTotal,type:histogram,buckets:100)",select = "IssuerOrgid,RIC,EJVAssetID,DTSubjectName,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,FaceIssuedUSD,"\"FaceOutstandingUSD,IssueDate,CouponRate,MaturityDate,ISIN,RCSDomicileLeaf,RCSCountryOfIncorporationLeaf,DBSTicker,RCSDomicileGenealogy"\"IsESGBond,KPITypeDescription,IsGreenBond,MaturityStandardYield,InstrumentTypeDescription,IssuePrice,FaceIssuedTotal,CouponFrequencyDescription,RCSCurrencyLeaf"\"PBOCRatings,PBOCCodesRanks,RCSBondGradeLeaf,RCSCoveredBondGenealogy,IsCallable,IsPutable,RCSUseOfProceedsLeaf"

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @Amith.TUmesh

    Thank you for reaching out to us.

    I understand that their meanings are in the RCSCoveredBondName field. For example:

        {
    "DocumentTitle": "CaixaBank SA, Plain Vanilla Fixed Coupon Bond, CABKX 6.5 01-Feb-2017",
    "RCSCoveredBondName": "Covered Bond\\Cedula Territorial",
    "RCSCoveredBondGenealogy": "A:3X\\A:DW"
    },
    {
    "DocumentTitle": "CaixaBank SA, Plain Vanilla Fixed Coupon Bond, CABKX 6.75 25-Jan-2018",
    "RCSCoveredBondName": "Covered Bond\\Cedula Hipotecaria|Government Debt\\Argentina\\Cedula Hipotecaria",
    "RCSCoveredBondGenealogy": "A:3X\\A:DV|A:N\\A:12I\\A:DV"
    },
    {
    "DocumentTitle": "Banco Internacional SA, Plain Vanilla Fixed Coupon Bond, BINT 3.9 01-Jan-2022",
    "RCSCoveredBondName": "Covered Bond\\Letra Hipotecaria Chile",
    "RCSCoveredBondGenealogy": "A:3X\\A:NW"
    },
    {
    "DocumentTitle": "Santander Financial Services Plc, Plain Vanilla Fixed Coupon Bond, SANNUF 4.25 12-Apr-2021",
    "RCSCoveredBondName": "Covered Bond\\Other Covered Bond",
    "RCSCoveredBondGenealogy": "A:3X\\A:EF"
    },
    {
    "DocumentTitle": "CaixaBank SA, Plain Vanilla Fixed Coupon Bond, CABKX 7 25-Jan-2019",
    "RCSCoveredBondName": "Covered Bond\\Cedula Hipotecaria|Government Debt\\Argentina\\Cedula Hipotecaria",
    "RCSCoveredBondGenealogy": "A:3X\\A:DV|A:N\\A:12I\\A:DV"
    },