International application ID as link to earlier PCT filing

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

EPO / PATSTAT Support
Posts: 227
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

International application ID as link to earlier PCT filing

Post by EPO / PATSTAT Support » Mon Feb 04, 2019 4:50 pm

Users have to be careful when using the internat_appln_id attribute as sole indicator for an earlier PCT application.
For most patent authorities this works fine but for some countries the internat_appln_id is not available or data is incomplete.
An example is Columbia, PATSTAT (2018b) contains 12.691 publications with the kind code "A2" (Application derived from a PCT application), however 11.364 do not have a link via the internat_appln_id to a PCT application. Most of those applications do however have a PCT member in the docdb family which reasonably spoken can be considered as the PCT filing from which the CO applications originate.

Code: Select all

select tls211_pat_publn.publn_auth+publn_nr+publn_kind as publication, publn_date ,tls201_appln.internat_appln_id,
(case when tls201_appln.internat_appln_id = 0 then  pct.appln_nr_epodoc end) PCT
from tls211_pat_publn join tls201_appln on tls211_pat_publn.appln_id = tls201_appln.appln_id
left join tls201_appln family on tls201_appln.docdb_family_id = family.docdb_family_id
left join tls201_appln pct on family.internat_appln_id = pct.appln_id and pct.appln_id < 900000000
where publn_auth = 'CO' and publn_kind = 'A2'
order by publn_date,tls211_pat_publn.appln_id
Geert Boedt
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Post Reply