Primary Key of legal-status-document

This space is made available to users of Open Patent Services (OPS) web-service and now also to users of EPO’s bulk data subscription products such as 14. EPO worldwide bibliographic database (DOCDB), 14.11 EPO worldwide legal status database (INPADOC), 14.12 EP full text data, 14.1 EP bibliographic data (EBD)and more.

Users can ask each other questions, exchange experiences and solutions, post ideas. The moderator will use this space to announce changes or other relevant information.
Post Reply

Chris Every
Posts: 23
Joined: Mon Jun 24, 2013 10:21 am

Primary Key of legal-status-document

Post by Chris Every » Mon Jun 19, 2017 11:10 am

Hi!

Currently we implement a batch job that imports INPADOC legal-status-documents into a database. As such we wonder what would be the natural primary key for legal-status-documents?

Taken from the sample, a legal-status-document looks like below.

There are several attributes or combinations of attributes, we could use as primary key. But what I would expect as the right thing is the combination of family-id="4211500" and sequence-number="1".

Is that right?

Code: Select all

	<legal-status-document family-id="4211500" status="C" country="CH" number-of-events="1">
	    <application-reference doc-id="5860841">
	        <document-id>
	            <country>CH</country>
	            <doc-number>148296</doc-number>
	            <kind>A</kind>
	            <date>19960613</date>
	        </document-id>
	    </application-reference>
	    <publication-reference doc-id="296901770" lang="de">
	        <document-id>
	            <country>CH</country>
	            <doc-number>690950</doc-number>
	            <kind>A5</kind>
	            <date>20010228</date>
	        </document-id>
	    </publication-reference>
	    <ipr-type>patent for invention</ipr-type>
	    <legal-event providing-office="CH" status="C" date-added="20160707" sequence-number="1">
	        <event-date>20160630</event-date>
	        <event-code>PL</event-code>
	        <event-details>
	            <event-description event-description-type="original">LOESCHUNG/RADIATION/RADIAZION</event-description>
	            <event-description lang="en">PATENT CEASED</event-description>
	        </event-details>
	    </legal-event>
	</legal-status-document>


EPO / OPS Support
Posts: 1298
Joined: Thu Feb 22, 2007 5:32 pm

Re: Primary Key of legal-status-document

Post by EPO / OPS Support » Mon Jun 19, 2017 12:59 pm

No, you should use either application number or application-reference doc-id

Regards,
OPS support


Chris Every
Posts: 23
Joined: Mon Jun 24, 2013 10:21 am

Re: Primary Key of legal-status-document

Post by Chris Every » Mon Jun 19, 2017 1:20 pm

Thank you for the insight.

Which one is better? Are always both present?


EPO / OPS Support
Posts: 1298
Joined: Thu Feb 22, 2007 5:32 pm

Re: Primary Key of legal-status-document

Post by EPO / OPS Support » Mon Jun 19, 2017 1:22 pm

I would go for application number, that one must be present to have legal status. ID might not be available for entire collection because it was introduced later.

Regards,
OPS support


Post Reply