Changes

Jump to navigation Jump to search
265 bytes added ,  11:45, 18 July 2016
==Table Variables==
Patent represents patent number and appnum represents application number for the patent in question. Size records whether the firm that owns the patent is considered large by the USPTO or if it has asserted [[Small Entity vs. Micro Entity| small or micro entity status]], according to the guidelines set by the America Invents Act. When the entry is N, the firm is large, and when the entry is Y, the firm is small. An M indicates a micro firm. Filedate is the date the patent application was filed. Gdate is the date the patent was granted. Feedate corresponds to when each maintenance fee payment was received by the USPTO. Each fee has a specific code defined by the USPTO. [http://www.mcnaircenter.org/mediawiki/images/2/2b/MaintFeeEventsFileDocumentation.pdf] The table has a composite key consisting of a unique combination of patent, feedate, and feecode. The table has multiple entries per patent number as maintenance fees are paid every four years and patent owners may have to pay other maintenance fees including patent renewal or late fee charges.
 
The majority of the entries in the table correspond to large firms.
 
patent=# SELECT COUNT(DISTINCT patent) FROM fee;
count
--------
4192602
(1 row)
 
patent=# SELECT COUNT(DISTINCT patent) FROM fee WHERE size='N';
count
--------
3273824
(1 row)
==Table Purpose==

Navigation menu