Skip to main content
2 posts
Last seen: 06/11/2021 - 04:18
Joined: 06/08/2021 - 19:55
ID in Pre-Grant Publications Data

Dear PatientsView team,

I want to ask about the id variable in pre-grant data. I try to join the "application" table with "CPC"/"rawlocation"/"location" tables with "id", but they do not match. An example of id in "application" is "0008dcaa-ccf9-11ea-ba95-121df0c29c1e". 

For "CPC" table, it seems that I can use "document number" to join. Howeverer, the only identifier in location table is id. 

What format is the "id" in Pre-grant Data in? And how can I join location table with applicatoin table? 

Thanks a lot!

Last seen: 06/13/2021 - 06:30
Joined: 11/14/2017 - 19:15
three way join

Hi Hebe,

I think you could join application and rawinventor and rawlocation.  It would be similar to where you might want to limit it to the first inventor depending on what you are trying to do.

Russ Allen