Granted?

[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?

[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

[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