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?
Granted?
-
- Posts: 140
- Joined: Wed Jul 08, 2009 5:51 pm
- Contact:
Granted?
________________________________________
Nico Doranov
Data Manager
Daigu Academic Services & Data Stewardship
http://www.daigu.nl/
Nico Doranov
Data Manager
Daigu Academic Services & Data Stewardship
http://www.daigu.nl/
Re: Granted?
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
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
Martin Kracker / EPO
Re: Granted?
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
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
Thanks
msbi training
msbi training