Difference between revisions of "Fee Table"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
Return to [[Patent Data Specifications]]. | Return to [[Patent Data Specifications]]. | ||
− | ==Table | + | ==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.