Difference between revisions of "Assignee Count Table"
| (One intermediate revision by one other user not shown) | |||
| Line 2: | Line 2: | ||
==Table Purpose== | ==Table Purpose== | ||
| − | In a transaction, multiple assignees and assignors may be involved. The | + | <section begin="assigneecount" /> |
| + | In a transaction, multiple assignees and assignors may be involved. The Assignee Count Table gives the number of assignees involved in a given assignment. The table was made using the Assignee 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="assigneecount" /> | ||
==Table Structure== | ==Table Structure== | ||
| Line 34: | Line 36: | ||
==Current Problems== | ==Current Problems== | ||
| + | |||
| + | [[Category: Internal]] | ||
| + | [[Internal Classification: Internal Resources| ]] | ||
Latest revision as of 16:14, 2 September 2016
Return to USPTOAssigneesData.
Table Purpose
In a transaction, multiple assignees and assignors may be involved. The Assignee Count Table gives the number of assignees involved in a given assignment. The table was made using the Assignee 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.assigneecount" Column | Type | Modifiers ------------+---------+----------- reel | integer | frame | integer | recdate | date | patent | integer | numassignee | bigint |
Example of table entries:
reel | frame | recdate | patent | numassignee ------+-------+------------+---------+------------- 4974 | 662 | 1988-10-18 | 9999999 | 1 4974 | 662 | 1988-10-18 | 9999999 | 1 18015 | 523 | 2006-06-30 | 9933719 | 1 10425 | 882 | 1999-12-06 | 9925487 | 1 11177 | 159 | 2000-09-14 | 9907141 | 1 11177 | 159 | 2000-09-14 | 9907141 | 1 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 | 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. Numassignees is the number of assignees involved in the transaction. The table has a composite key consisting of reel number, frame number, and recdate.
