Validation state

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

ferhane
Posts: 1
Joined: Mon Feb 10, 2020 1:46 pm

Validation state

Post by ferhane » Mon Feb 10, 2020 2:16 pm

is it possible to extract data relating to applications which paid the validation fee for a validation states, for example MOROCCO.


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

Re: Validation state payment

Post by EPO / PATSTAT Support » Fri Feb 14, 2020 4:26 pm

Hello Ferhane,
In patstat you can retrieve some of the data on validation fees being paid for Morocco via this query:

Code: Select all

SELECT * 
FROM tls201_appln join tls231_inpadoc_legal_event 
on tls201_appln.appln_id = tls231_inpadoc_legal_event.appln_id 
where event_code = 'RAV' and extension_states like '%MA%'
order by tls201_appln.appln_id
HOWEVER, due to the way data was aggregated and processed in the past for the EP RAV code, the data in PATSTAT may be incomplete and wrong. We have fixed the problem but some corrective actions still need to be done. We anticipate that this will be reflected in the PATSTAT 2020b edition, but I can only confirm this when we have tested the new data. (Sept-Oct 2020)
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Post Reply