Hi!
I am looking at ESG bonds issued by firms. I am trying to understand the RCSFIClassificationCodes variable, which for each ESG bond outputs one or more lists the following structures:{'Code': String, 'CodeDescription': String, 'CodePermID': String, 'IsESGStandard': Boolean, 'Type': String, 'TypeDescription': String, 'TypePermID': String, 'TypeX1XCodeX1XCodeDescription': String}
Questions:
1) What are these codes and types referring to? Can you provide a list of all available codes and types, along with their descriptions? I have not managed to find it yet.
2) When using the tool Advance Search with the app on my desktop and adding the filter ESG Bond type ="Sustainable Linked Bonds", the query output is the following:
rd.discovery.search(view = rd.discovery.Views.GOV_CORP_INSTRUMENTS,top = 10,filter = "(DbType eq 'CORP' and ((RCSFIClassificationCodes((Type eq 'SRIBND') and (Code in ('SCLB'))))))",select = "RIC,EJVAssetID,DTSubjectName,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,DBSTicker,CouponRate,MaturityDate,IssueDate,ISIN,RCSCurrencyLeaf,RCSCountryLeaf,DbTypeDescription,InstrumentTypeDescription,RCSCouponTypeGenealogy,FaceIssuedUSD,RCSBondGradeLeaf,RCSFIClassificationCodes")
However, in the answer to the ticket called "Sustainabilty-Linked bond deals via python API" at https://community.developers.lseg.com/discussion/comment/107576?tab=all#Comment_107576 , the reply was to use:rd.discovery.search( view = rd.discovery.Views.GOV_CORP_INSTRUMENTS, top = 10000, filter = "RCSFIClassificationCodes(CodeDescription eq 'Sustainability Linked Bond')", select = "RIC,RCSFIClassificationCodes", )
Focusing on the difference in the filter: Using the desktop app is equivalent to code==SCLB and Type=='SRIBND', however, the suggested in the developer community webpage only suggest code==SCLB. Can you clarify the differences and how they affect the outcomes of both searches?