Difference between revisions of "Assignor Count Table"
| (2 intermediate revisions by one other user not shown) | |||
| Line 2: | Line 2: | ||
==Table Purpose== | ==Table Purpose== | ||
| + | <section begin="assignorcount" /> | ||
| + | Since multiple assignees and assignors may be involved in a patent transaction, the Assignor Count Table keeps track of the number of assignors involved in a given assignment. The table was made using the Assignor Table and counting the number of rows per each distinct group of reel number, frame number, and recdate. The table was used to create the Party Count Table. | ||
| + | <section end="assignorcount" /> | ||
==Table Structure== | ==Table Structure== | ||
| Line 30: | Line 33: | ||
==Table Variables== | ==Table Variables== | ||
| + | Reel and frame give the location on the microfilm files where the particular transaction is recorded. The reel number and frame number are unique to a transaction between the assignee and assignor. The recdate is the date the assignment was recorded. Patent gives the patent number of the patent involved in a specific transaction. Numassignors is the number of assignors involved in the transaction. The table has a composite key consisting of reel number, frame number, and recdate. | ||
| + | |||
| + | ==Current Problems== | ||
| − | + | [[Category: Internal]] | |
| + | [[Internal Classification: Legacy| ]] | ||
Latest revision as of 16:18, 2 September 2016
Return to USPTOAssigneesData.
Table Purpose
Since multiple assignees and assignors may be involved in a patent transaction, the Assignor Count Table keeps track of the number of assignors involved in a given assignment. The table was made using the Assignor Table and counting the number of rows per each distinct group of reel number, frame number, and recdate. The table was used to create the Party Count Table.
Table Structure
Table "public.assignorcount" Column | Type | Modifiers ------------+---------+----------- reel | integer | frame | integer | recdate | date | patent | integer | numassignor | bigint |
Example of table entries:
reel | frame | recdate | patent | numassignor ------+-------+------------+---------+------------- 4974 | 662 | 1988-10-18 | 9999999 | 2 18015 | 523 | 2006-06-30 | 9933719 | 1 10425 | 882 | 1999-12-06 | 9925487 | 1 11177 | 159 | 2000-09-14 | 9907141 | 2 13036 | 521 | 2002-06-25 | 9903592 | 1 13011 | 193 | 2002-06-19 | 9827659 | 1 13036 | 521 | 2002-06-25 | 9824727 | 1 12653 | 532 | 2002-02-25 | 9808340 | 6 11566 | 681 | 2001-02-13 | 9802673 | 1 22928 | 276 | 2009-07-06 | 9727320 | 1
Table Variables
Reel and frame give the location on the microfilm files where the particular transaction is recorded. The reel number and frame number are unique to a transaction between the assignee and assignor. The recdate is the date the assignment was recorded. Patent gives the patent number of the patent involved in a specific transaction. Numassignors is the number of assignors involved in the transaction. The table has a composite key consisting of reel number, frame number, and recdate.
