==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. The recdate is when the assignment was recorded in the USPTO. Lastupdatedate is the last date the assignment record was updated. If the assignment record has been erased from the assignment database, the purge indicator will have a Y entry. The corrname is the person or organization dealing with the documentation of the assignment. Typically, the correspondent will be part of a firm involved in the transaction or an attorney. The correspondent's address is given in the four subsequent columns. The conveyance text describes what kind of transaction occurred in the assignment, meaning in what form the intellectual property was assigned. There are 162,613 distinct types of conveyance text included in the table.
SELECT COUNT(DISTINCT conveyancetext) FROM conveyance;
count
-------
162613
==Current Problems==