ISA?

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

AWFB
Posts: 12
Joined: Mon Oct 22, 2018 6:56 pm

ISA?

Post by AWFB » Mon Oct 22, 2018 6:58 pm

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?


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

Re: ISA?

Post by EPO / PATSTAT Support » Wed Oct 24, 2018 7:12 am

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
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


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

Re: ISA?

Post by EPO / PATSTAT Support » Wed Oct 24, 2018 10:49 pm

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
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Post Reply