EPO - Discussion forums

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'

Hello Lionpat,
here is a query that links utility models filed in DE with their US priority filings.
To look for DE utility models that served as priority for later US applications, simply switch the joins on the tls204 table.

Thank you so much! This is exactly the search that I needed. And with this assistance, I can figure out how to extend it for additional pieces of information quite easily. I very much appreciate the support!