Procedural events: R161/Summons

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

Procedural events: R161/Summons

Post by AWFB » Tue May 07, 2019 4:03 pm

Is there any way to obtain the dates of either the issuance of an EESR or a summons to OPs from PATSTAT?
It seems possible to retrieve this data from the public register, but I can't seem to find anything that corresponds to this information in PATSTAT.


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

Re: Procedural events: R161/Summons

Post by EPO / PATSTAT Support » Thu May 09, 2019 5:13 pm

Hello AWFB,
can you give me a specific example from the register ?
That makes it easier to illustrate the example.
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


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

Re: Procedural events: R161/Summons

Post by AWFB » Thu May 09, 2019 5:47 pm

EP2927844

Via 'All documents', I can see that a summons was sent on 22.11.2017, and that a search opinion was issued on 28.08.2015.


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

Re: Procedural events: R161/Summons

Post by EPO / PATSTAT Support » Fri May 10, 2019 1:17 pm

With this query you can see all the "legal events" from EP2927844 in PATSTAT.

Code: Select all

SELECT reg102_pat_publn.publn_auth
      ,reg102_pat_publn.publn_nr
      ,reg102_pat_publn.publn_kind
      ,reg102_pat_publn.publn_date
	  ,reg101_appln.appln_auth
	  ,reg101_appln.appln_nr
	  ,reg101_appln.appln_filing_date
	  ,reg301_event_data.*
	  ,reg402_event_text.event_text
 FROM [reg101_appln]  join [reg301_event_data] 
   on reg101_appln.id = reg301_event_data.id
   join [reg402_event_text] 
   on reg402_event_text.event_code = reg301_event_data.event_code 
   join reg102_pat_publn on reg101_appln.id =reg102_pat_publn.id
  where reg102_pat_publn.publn_auth = 'EP' and reg102_pat_publn.publn_nr = '2927844'
order by reg101_appln.appln_id,event_date asc
From the results you can see that there is an event with the code "EPIDOSNORA1E" which stands for "New entry: Date of oral proceedings". This can probably be used as a "close enough" proxy to the date when the summons were send. There does not seem to be a specific coding referring to the issuing of the search opinion. The first "proxy" seems to be the publication of the search report.

You can use the above query to retrieve all applications by simply changing the WHERE clause.
Something like this:

Code: Select all

SELECT top 1000 reg102_pat_publn.publn_auth
      ,reg102_pat_publn.publn_nr
      ,reg102_pat_publn.publn_kind
      ,reg102_pat_publn.publn_date
	  ,reg101_appln.appln_auth
	  ,reg101_appln.appln_nr
	  ,reg101_appln.appln_filing_date
	  ,reg301_event_data.*
	  ,reg402_event_text.event_text
 FROM [reg101_appln]  join [reg301_event_data] 
   on reg101_appln.id = reg301_event_data.id
   join [reg402_event_text] 
   on reg402_event_text.event_code = reg301_event_data.event_code 
   join reg102_pat_publn on reg101_appln.id =reg102_pat_publn.id
  where reg301_event_data.event_code = 'EPIDOSNORA1E' and year(appln_filing_date) = '2005'
 --reg102_pat_publn.publn_auth = 'EP' and reg102_pat_publn.publn_nr = '2927844'
order by reg101_appln.appln_id,event_date asc
A word of caution here:
In PATSTAT there seems to be multiple codes used for the "Date of oral proceedings".

EPIDOSNORA1E
EPIDOSNORA1L
EPIDOSNORA1NE
EPIDOSNORA1NO
EPIDOSNORA1O
EPIDOSNORA1PO
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


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

Re: Procedural events: R161/Summons

Post by AWFB » Fri May 10, 2019 2:24 pm

Okay, thanks for that. That's a reasonable enough proxy :)


Post Reply