Page 1 of 1
Granted?
Posted: Mon Dec 30, 2013 3:09 pm
by nico.rasters
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?
Re: Granted?
Posted: Tue Jan 07, 2014 1:18 pm
by mkracker
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
Re: Granted?
Posted: Fri Nov 03, 2023 6:24 pm
by rohan02
Hello,
As per my knowledge, In the PATSTAT Online Extension, the determination of the "Granted" field involves checking the existence of a publication related to the grant. Specifically, if there is a publication of grant, the "Granted" field is assigned the value "1"; otherwise, it is set to "0". The key criterion here is the presence or absence of a publication associated with the grant.
The algorithm does not solely rely on the publn_first_grant field; instead, it takes a more comprehensive approach by considering the broader context of grant-related publications. This approach ensures a more accurate representation of whether a patent has been granted, taking into account various aspects of the publication data associated with the grant process.
I hope this will help you.
Regard
Rohan Sharma