Fee Table

From edegan.com
Jump to navigation Jump to search

Table Structure

          Table "public.fee"
 Column  |       Type        | Modifiers 
---------+-------------------+-----------
patent   | character varying | 
appnum   | integer           | 
size     | character varying | 
filedate | date              | 
gdate    | date              | 
feedate  | date              | 
feecode  | character varying | 

Example of table entries:

patent  | appnum  | size |  filedate  |   gdate    |  feedate   | feecode 
--------+---------+------+------------+------------+------------+---------
4287053 | 6218896 | N    | 1980-12-22 | 1981-09-01 | 1985-02-11 | M170
4289713 | 6222552 | Y    | 1981-01-05 | 1981-09-15 | 1993-03-30 | SM02
4289713 | 6222552 | Y    | 1981-01-05 | 1981-09-15 | 1993-03-03 | M285
4289713 | 6222552 | Y    | 1981-01-05 | 1981-09-15 | 1992-12-08 | RMPN
4289713 | 6222552 | Y    | 1981-01-05 | 1981-09-15 | 1992-12-08 | ASPN
4289713 | 6222552 | Y    | 1981-01-05 | 1981-09-15 | 1988-11-16 | ASPN
4289713 | 6222552 | Y    | 1981-01-05 | 1981-09-15 | 1988-11-07 | M171
4289713 | 6222552 | Y    | 1981-01-05 | 1981-09-15 | 1985-03-06 | M170
4291808 | 6215853 | N    | 1980-12-12 | 1981-09-29 | 1985-10-31 | EXP.
4291808 | 6215853 | N    | 1980-12-12 | 1981-09-29 | 1985-08-12 | REM.
4292069 | 6227825 | N    | 1981-01-23 | 1981-09-29 | 1993-09-26 | EXP.

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 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. [1] 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)
patent=# SELECT COUNT(DISTINCT patent) FROM fee WHERE size='Y'; 
count  
-------
906383
(1 row)
patent=# SELECT COUNT(DISTINCT patent) FROM fee WHERE size='M'; 
count 
------
12395
(1 row)

Table Purpose

The USPTO requires maintenance fees to be paid by the patent assignee. For each patent a firm owns, it must assert large, micro, or small entity status. According to the America Invents Act, both small and micro firms receive fee discounts on a majority of maintenance fees. The fee amount each firm pays is specified online by the USPTO on its comprehensive maintenance fee schedule. [2] By recording the status asserted for each issued patent, the McNair center is able to identify which firms identify as small and micro firms, establishing the research potential for the Little Guy Academic Paper. Once identified, these small and micro firms may be used to track the effects of patent litigation on patent ownership and a small or micro firm's livelihood.

Current Problems