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

Posts: 140
Joined: Wed Jul 08, 2009 5:51 pm


Post by nico.rasters » Mon Dec 30, 2013 3:09 pm

The PATSTAT Online Extension contains a field called "Granted".
Description: "1" if there exists a publication of the grant; "0" otherwise.

Would it be possible to describe the algorithm used to determine whether granted is 1 or 0?
Is it simply checking the `publn_first_grant` field, or is it something more advanced?
Nico Doranov
Data Manager

Daigu Academic Services & Data Stewardship

Posts: 114
Joined: Wed Sep 04, 2013 6:17 am
Location: Vienna

Re: Granted?

Post by mkracker » Tue Jan 07, 2014 1:18 pm

Dear Nico,

You are right: The GRANTED field of table TLS201_APPLN is derived from the PUBLN_FIRST GRANT field of table TLS211_PAT_PUBLN. (cf. Data Catalog v5.00 Oct 2013, p.126)

More specifically, it is done this way:

update tls201_appln
set granted = 1 -- default was 0
where exists
(select *
from tls211_pat_publn pub
where tls201_appln.appln_id = pub.appln_id
and publn_first_grant = 1)

Martin Kracker, EPO - PATSTAT
Martin Kracker / EPO

Post Reply