Page 1 of 1
ISA?
Posted: Mon Oct 22, 2018 6:58 pm
by AWFB
How can I determine the ISA for a Euro-PCT application?
The PATSTAT catalogue seems to suggest that within the procedural steps tables, the field ISAT should reveal this information. However, the field doesn't ever seem to contain the identifier of the ISA.
Any ideas?
Re: ISA?
Posted: Wed Oct 24, 2018 7:12 am
by EPO / PATSTAT Support
The procedural step ISAT in the "PATSTAT EP Register" Database does only contain the office of the ISR (Internat. Search Report), not its citations etc.
In general, citations cannot be found in the "PATSTAT EP Register" database but only in "PATSTAT Global". Both databases can easily been used together. Here is a query which selects a single EuroPCT in "PATSTAT EP Register" and gets from "PATSTAT Global" the publication of its PCT application and the (ISR) citations of this publications.
Code: Select all
select *
from reg101_appln a
join tls211_pat_publn p on a.internat_appln_id = p.appln_id
-- p is the publication of the internat. appln of the selected EuroCT aplication
join tls212_citation c on p.pat_publn_id = c.pat_publn_id
where internat_appln_id > 0
and a.id = 900004 -- just a random EuroPCT
You can do a very similar thing within "PATSTAT Global" only by using table TLS201_APPLN instead of REG101_APPLN.
Best regards
Re: ISA?
Posted: Wed Oct 24, 2018 10:49 pm
by EPO / PATSTAT Support
Here is an addition to my previous post in this thread: I forgot to mention that the situation has changed in the newest PATSTAT edition: This 2018 Spring Edition is available as PATSTAT data since early October and will be available soon in PATSTAT Online.
In the 2018 Autumn Edition of PATSTAT Global the EuroPCTs will also include the (ISR - International Search Report) citations from their respective PCT publications. The attribute CITN_REPLENISHED will contain the information whether the data is replenished from the PCT application or originates from the EuroPCT itself. Please check this attribute in the Data Catalog for more details.
Best regards,
Martin