Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
3 0 0 2

Difference among @OrgID, TR.OrganizationID, and TR.UltimateParentID for bond issuer rating?

I am so confused abount the difference among @OrgID, TR.OrganizationID, and TR.UltimateParentID. Could anyone explain it? Thanks in advance!

eikon#contentpython api
icon clock
10 |1500

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

Upvote
Accepted
78.6k 248 52 74

@shu168

Thank you for reaching out to us.

ORG ID (TR.OrgidCode) is a unique Refinitiv system-generated code that uniquely identifies the market organization, such as 117134618 (Refinitiv US Holdings Inc).

Organization PermID (TR.OrganizationID) is an organization-level permanent identifier, such as 5064690523 (Refinitiv US Holdings Inc). https://permid.org/1-5064690523

Ultimate Parent ID (TR.UltimateParentID) is the organization PermID of the ultimate parent organization that resides at the top of a hierarchy tree of this organization. For example, the PermID of the London Stock Exchange Group PLC is 4298007752 (https://permid.org/1-4298007752).

The following code may be able to explain what those IDs look like.

1688542989643.png

TR.OrganizationID and TR.UltimateParentId are PermIDs while TR.OrgidCode is not.

For more information, you can contact the Content support team directly via MyRefinitiv.


1688542989643.png (27.8 KiB)
icon clock
10 |1500

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

@Jirapongse I have couple of further quesions as below:


1. Do every ORG ID has an one and only Organization PermID ?

2. Why do some ORG ID equivalent to themselves without '@OrgID' (ex. 150797@orgid is equivalent to 150797 ) but others do not (ex. 100327@orgid is not equivalent to 100327)?

3. Could I automatically add '@OrgID' to the value returned by field TR.OrgidCode as an equivalent ORG ID?

4. Does Eikon Desktop have an user interface for finding ORG ID, Organization PermID, and TR.CommonName by only keying in the ORG ID or company name?

5. Could I tell whether an ID (ex. 150797) is an ORG ID or Organization PermID by its digit number. For example, all 10 digit numbers are Organization PermID and numbers with less than 9 digits are ORG ID.

6. As returned value row 9 and row 10 in the below picture, if the instrument given to the function get_data() is 100317@OrgID, the returned instrument will be 100317 and if the instrument given is 100317, the returned instrument will be 107574. How should I map the returned data to the instrument I give to the function get_data()?

id-compare.png

7. Which ID is better to use as the instrument for function get_data() to get the data? ORG ID or Organization PermID?


Thanks for your patience!!

@shuteoh

As this forum is more for programming-type queries, rather than content queries - I would recommend you raise a 'I need help understanding content within the product' ticket with our helpdesk via MyRefintiv. That way a Content specialist can work closely with you and provide the answers.

Got it! Thank you so much!
Upvote
24.6k 54 17 14

Hello @shu168

Thank you for contacting us. There is the Eikon App named "Data Item Browser" (DIB) where you can input your interested RIC and then it shows the definition of each field as follows:

dib-2.png

dib-1.png


I hope this information helps.



dib-2.png (112.6 KiB)
dib-1.png (76.9 KiB)
icon clock
10 |1500

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

Upvotes
24.6k 54 17 14

Hello @shu168

If you need more information about the Eikon content, I highly recommend you contact the Content support team directly to help you with those fields' information. You can contact the Content team via https://my.refinitiv.com/content/mytr/en/productsupport.html website.

contact-eikon-content.png


icon clock
10 |1500

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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