question

Upvotes
Accepted
16 0 1 4

Hierarchy attributes in RDP API

Hi @ Alex Putkov,

what do HierarchyOAPermIDs and IssuerOAPermID stand for? Is there a lexicon for all these attributes?

Thanks

IssuerShortNameParentIssuerIDParentIssuerNameParentOAPermIDIssuerCommonNameIssuerOrgidHierarchyOAPermIDsParentIndustrySectorIssuerOAPermIDIssuerLegalNameIssuerOrganizationCredit Suisse US0x0000fa000448c87eCredit Suisse Gp4295890672Credit Suisse (USA) Inc60762['4295912110', '5000005697', '4295890672']BANKS4295912110CREDIT SUISSE (USA), INC.60762


rdp-apirefinitiv-data-platform
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
39.2k 75 11 27

I'm afraid there's no lexicon for the properties in RDP Search service beyond what's available through Metadata service, which I appreciate does not provide detailed description for the properties. This means the only way to infer the meaning of any property is from its name and from the samples of data it returns.
In this example I happen to know that "OA" refers to Organization Authority, which is a system where Refinitiv manages the hierarchy and the relationships for organizations. IssuerOAPermID returns PermID for the issuer organization. HierarchyOAPermIDs returns the list of organization PermIDs for the organization and its immediate and ultimate parents.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
16 0 1 4

Hi @Alex Putkov. Many thanks for your reply and help.

I was actually reverse-engineering all this but then stumbled on matching, e.g. '5000005697' to anything (see snapshot). How can I find the match for that Id in rdp (python)? I tried a rdp.search with

filterStr = " IssuerOAPermID eq '5000005697'"
data1 = rdp.search(view=rdp.SearchViews.GovCorpInstruments, filter=filterStr, top=GroupSize, select=srchfields)

Also tried with:

filterStr = " ParentImmedOrgID eq '5000005697'"

Also, how can I get the ParentOAPermID for a Bank given a fuzzy name for a Bank in a neat way with rdp api (python)?

Many thanks


1619434506504.png (10.5 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
131 1 0 0

@grigorios.mamalis

You're not getting any hits with

filter = "IssuerOAPermID eq '5000005697'"

because this organization (Credit Suisse Holdings (USA) Inc") does not directly issue any bonds. It does issue bonds through its immediate subsidiary (Credit Suisse (USA) Inc).
Your second filter returned no hits because you used incorrect property. OrgID and OAPermID are different identifiers. Try

filter = "ParentImmedOAPermID eq '5000005697'"

With this filter I get 493 hits.

To answer your last question, RDP Search service doesn't do fuzzy name matching. However, simple string matching in RDP Search ignores case, word order, extra words and most punctuation. E.g. with

view=rdp.SearchViews.Organisations
filter = "CommonName eq 'Credit Suisse' and RCSOrganisationType eq 'OT:1'"

I get 59 hits including "Credit Suisse Group AG", "Credit Suisse AG (New York Branch)" and so on. But it also includes "Credit Agricole next bank Suisse SA", which is not related to Credit Suisse. Once you have these results you could employ a library like Fuzzywuzzy, which provides fuzzy name search capability.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea