Multiple PSN_IDs for the same company?

[patrick195]

Hello,

during my analysis of company data, I realized that some companies in my sample have multiple
PSN_IDs e.g. IBM Deutschland can be associated with PSN_ID: 13138493, 13138495, 13138496 etc.
Is there any specific reason behind this? And is there a solution to identify connected PSN_IDs?

Thanks a lot,
Patrick

[EPO / PATSTAT Support]

Hello Patrick,
Your observation is not what I find in PATSTAT.
If you run the code below you will see that 'IBM Deutschland' on has 1 psn_id being 13775141. (in PATSTAT 2022a --> PSN_IDs are NOT fixed across PATSTAT version.

Code: Select all

SELECT TOP (1000) person_id
      ,person_name
      ,person_name_orig_lg
      ,person_address
      ,person_ctry_code
      ,nuts
      ,nuts_level
      ,reg_code
      ,doc_std_name_id
      ,doc_std_name
      ,psn_id
      ,psn_name
      ,psn_level
      ,psn_sector
      ,han_id
      ,han_name
      ,han_harmonized
  FROM tls206_person
 where psn_name = 'IBM Deutschland'

[patrick195]

Hey,

I use a different Patstat-Version so that's why the PSN_IDs are not the same. However, if I check person_id which is a stable identifier across versions and I run the query for a person_id that is connected to one of the PSN_IDs in my sample.

SELECT TOP (1000) person_id
,person_name
,person_name_orig_lg
,person_address
,person_ctry_code
,nuts
,nuts_level
,doc_std_name_id
,doc_std_name
,psn_id
,psn_name
,psn_level
,psn_sector
,han_id
,han_name
,han_harmonized
FROM tls206_person
where person_id = '23724479'

I receive 13558407 as PSN_ID for this company although it is also IBM Deutschland. There is a little difference in the spelling, however, it is still the same company. So the question is still if there is a way to find these connected PSN_IDs?

Thanks a lot,
Patrick