Dear All,
I've met one more problem: how to lookup separately for inventors (who on my point of view
can be only real persons, not legal) and applicants - who can be both.
When I am trying to find person_name - everything is mixed there. Am I right?
How to make a query like in Espacenet where they are placed in different columns?
Regards and thanks beforehand,
Kirill.
Inventors & Applicants - how to distiguish?
-
- Posts: 140
- Joined: Wed Jul 08, 2009 5:51 pm
- Contact:
Re: Inventors & Applicants - how to distiguish?
In tls207_pers_appln there are two variables: applt_seq_nr and invt_seq_nr.
If applt_seq_nr > 0 the corresponding person_id is is an applicant.
If invt_seq_nr > 0 the corresponding person_id is is an inventor.
If applt_seq_nr > 0 and invt_seq_nr > 0 the corresponding person_id is is an applicant and an inventor (less than 10% of the records I would reckon).
If applt_seq_nr > 0 the corresponding person_id is is an applicant.
If invt_seq_nr > 0 the corresponding person_id is is an inventor.
If applt_seq_nr > 0 and invt_seq_nr > 0 the corresponding person_id is is an applicant and an inventor (less than 10% of the records I would reckon).
________________________________________
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/