Hello Simon,
the model of the PATSTAT Legal data base has indeed changed a little bit; some of the attributes have been renamed.
This is an adapted query based on the one you used:
Code: Select all
SELECT appln_auth+appln_nr+' '+appln_kind ap_number, appln_filing_date, event_seq_nr, event_code, event_publn_date, fee_country, fee_payment_date, fee_renewal_year, fee_text
from tls201_appln
join tls231_inpadoc_legal_event
on tls201_appln.appln_id = tls231_inpadoc_legal_event.appln_id
where tls201_appln.appln_auth = 'EP'
and appln_nr = '06807506'
and event_code = 'pgfp'
order by event_seq_nr
For up-to-date information on the tables and the attirbutes, please check the relevant Data Catalog that goes with the PATSTAT version that you are using.
http://www.epo.org/searching-for-patent ... html#tab-3
Adapting the query a bit further to narrow down to certain applicant you have to include the tls206_person table. Something like this:
Code: Select all
SELECT appln_auth+appln_nr+' '+appln_kind ap_number, psn_name, person_ctry_code,appln_filing_date, event_seq_nr, event_code, event_publn_date, fee_country, fee_payment_date, fee_renewal_year, fee_text
from tls201_appln
join tls231_inpadoc_legal_event on tls201_appln.appln_id = tls231_inpadoc_legal_event.appln_id
join tls207_pers_appln on tls201_appln.appln_id = tls207_pers_appln.appln_id
join tls206_person on tls207_pers_appln.person_id = tls206_person.person_id
where applt_seq_nr > 0 and psn_name = 'Fresenius'
and event_code = 'pgfp'
order by tls201_appln.appln_id, event_seq_nr
You have to keep in mind that patent validity years follow the application date and not the calendar year.
You could use for example criteria as "where renewal fee was paid for in the year 2000" and the "fee-renewal-year <= 20", then you know that the fee was also paid for the previous year. If a fee was then paid in 1999, and fee_renewal_year <=20, then you know that the applicant did not want to keep the patent further alive. Be careful when you do this for the most recent years, some countries apply generous grace times to pay renewal fees and also the PATSTAT production process could distort the data for the most recent year(s).