Utility Model Priority Application
Posted: Fri Oct 26, 2018 10:14 pm
I need some help finding information on utility models in PatStat. Specifically, I am trying to identify utility model applications that have a U.S. patent application as a priority filing. Additionally, I would also like to find utility model applications that serve as the priority filing for a U.S. application. I realize this will be a small number of utility model filings because that specific protection does not exist in the U.S.
So far, I have figured out how to find the priority application ID by linking tls204 with tls201. But I cannot figure out how to get from the prior_appln_id to the actual priority application number or the priority application country code. Any advice? Below is my search to date (this one, restricted to German utility models):
SELECT p.person_name, han_name, prior_appln_id
from tls201_appln a
JOIN tls207_pers_appln pa on a.appln_id = pa.appln_id
JOIN tls206_person p on pa.person_id = p.person_id
Join tls204_appln_prior pr on a.appln_id = pr.appln_id
where a.appln_auth = 'de'
and a.ipr_type = 'um'
So far, I have figured out how to find the priority application ID by linking tls204 with tls201. But I cannot figure out how to get from the prior_appln_id to the actual priority application number or the priority application country code. Any advice? Below is my search to date (this one, restricted to German utility models):
SELECT p.person_name, han_name, prior_appln_id
from tls201_appln a
JOIN tls207_pers_appln pa on a.appln_id = pa.appln_id
JOIN tls206_person p on pa.person_id = p.person_id
Join tls204_appln_prior pr on a.appln_id = pr.appln_id
where a.appln_auth = 'de'
and a.ipr_type = 'um'