Difference between revisions of "Fee Table"

From edegan.com
Jump to navigation Jump to search
Line 1: Line 1:
 
Return to [[Patent Data Specifications]].  
 
Return to [[Patent Data Specifications]].  
  
==Table Variables==
+
==Table Structure==
  
 
             Table "public.fee"
 
             Table "public.fee"
Line 13: Line 13:
 
  feedate  | date              |  
 
  feedate  | date              |  
 
  feecode  | character varying |
 
  feecode  | character varying |
 +
 +
Example of table entries:
  
 
  patent  | appdate | size |  filedate  |  gdate    |  feedate  | feecode  
 
  patent  | appdate | size |  filedate  |  gdate    |  feedate  | feecode  
Line 26: Line 28:
 
  4291808 | 6215853 | N    | 1980-12-12 | 1981-09-29 | 1985-10-31 | EXP.
 
  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.
 
  4291808 | 6215853 | N    | 1980-12-12 | 1981-09-29 | 1985-08-12 | REM.
 +
 +
==Table Variables==
 +
==Table Purpose==
 +
==Current Problems==

Revision as of 15:13, 13 July 2016

Return to Patent Data Specifications.

Table Structure

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

Example of table entries:

patent  | appdate | 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.

Table Variables

Table Purpose

Current Problems