I am so confused abount the difference among @OrgID, TR.OrganizationID, and TR.UltimateParentID. Could anyone explain it? Thanks in advance!
@shuteoh
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.
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.
Hello @shuteoh
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:
I hope this information helps.
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.
@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()?
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!!
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.
