329
edits
Changes
Jump to navigation
Jump to search
Table "public.fee"
----------+-------------------+-----------
appdate appnum | integer |
no edit summary
Return to [[Patent Data Specifications]].
==Table VariablesPurpose==<section begin='fee' />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 [http://www.uspto.gov/learning-and-resources/fees-and-payment/uspto-fee-schedule maintenance fee schedule.] 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. The fee table was used to create the [[Fee Status Table| fee status table]], facilitating the identification and tracking process.<section end='fee' /> ==Table Structure==
Column | Type | Modifiers
patent | character varying |
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 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 [http://www.mcnaircenter.org/mediawiki/images/2/2b/MaintFeeEventsFileDocumentation.pdf defined by the USPTO.] 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)[[Category: Internal]][[Internal Classification: Data Tables| ]]
