619
edits
Changes
Jump to navigation
Jump to search
Table "public.assignee"
no edit summary
==Table Purpose==
<section begin="assignee2" />
The Assignee Table gives the assignee and location of each assignee involved in an assignment. The table gives a non-standardized inventory of companies involved in assignments as well as an indication of a company's patent portfolio over time. Additionally, the Assignee Table was used to create the Assignment and Assignee Count Tables.
<section end="assignee2" />
==Table Structure==
Column | Type | Modifiers
----------+------------------------+-----------
3818 | 140 | 1980-01-02 | E. EDELMANN & CO. | | 60076
reel | frame | recdate | assignee | addrline1 | addrline2 | city | state - ------+-------+------------+-------------------------------------------------------------------------------------------+-------------------------+---------------------------------+------------------+-----------
15283 | 287 | 1970-01-04 | RANBAXY LABORATORIES LIMITED | 19, NEHRU PLACE | | NEW DELHI |
5744 | 401 | 1975-09-08 | ROLLS-ROYCE (1971) LIMITED | | NORFOLK HOUSE, ST. JAMES SQUARE | LONDON |
==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 assignee receives ownership or interest in the patents involved in the transaction from the assignor. The recdate is the date the transaction was recorded. The rest of the entries in the table give the location of the assignee. The key for the table is composite and consists of a unique combination of reel number, frame number, and recdate.
==Current Problems==
[[Category: Internal]]
[[Internal Classification: Legacy| ]]
