Difference between revisions of "Fee Table"
Jump to navigation
Jump to search
| Line 3: | Line 3: | ||
==Table Structure== | ==Table Structure== | ||
| − | + | Table "public.fee" | |
Column | Type | Modifiers | Column | Type | Modifiers | ||
| − | + | ----------+-------------------+----------- | |
patent | character varying | | patent | character varying | | ||
| − | + | appnum | integer | | |
size | character varying | | size | character varying | | ||
filedate | date | | filedate | date | | ||
gdate | date | | gdate | date | | ||
feedate | date | | feedate | date | | ||
| − | feecode | character varying | | + | feecode | character varying | |
Example of table entries: | Example of table entries: | ||
| − | patent | | + | patent | appnum | size | filedate | gdate | feedate | feecode |
| − | + | ---------+---------+------+------------+------------+------------+--------- | |
4287053 | 6218896 | N | 1980-12-22 | 1981-09-01 | 1985-02-11 | M170 | 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-30 | SM02 | ||
| Line 28: | 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. | ||
| + | 4292069 | 6227825 | N | 1981-01-23 | 1981-09-29 | 1993-09-26 | EXP. | ||
==Table Variables== | ==Table Variables== | ||
==Table Purpose== | ==Table Purpose== | ||
==Current Problems== | ==Current Problems== | ||
Revision as of 10:51, 18 July 2016
Return to Patent Data Specifications.
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.
