Difference between revisions of "PTO Assignment"

From edegan.com
Jump to navigation Jump to search
Line 56: Line 56:
  
 
==Table Variables==
 
==Table Variables==
==Table Purpose==
 
==Current Problems==
 

Revision as of 12:14, 29 July 2016

Back to Patent Data Specifications.

Table Structure

                       Table "public.ptoassignment"
        Column          |          Type          | Modifiers 
------------------------+------------------------+-----------
reel_no                 | integer                | 
frame_no                | integer                | 
last_update_date        | date                   | 
purge_indicator         | character varying(2)   | 
recorded_date           | date                   | 
correspondent_name      | character varying(500) | 
correspondent_address_1 | character varying(500) | 
correspondent_address_2 | character varying(500) | 
correspondent_address_3 | character varying(500) | 
correspondent_address_4 | character varying(500) | 
conveyance_text         | character varying(500) |

Example of table entries:

reel_no | frame_no | last_update_date | purge_indicator | recorded_date |          correspondent_name          
--------+----------+------------------+-----------------+---------------+--------------------------------------
   1280 |      340 | 1999-07-29       | N               | 1994-12-30    | THOMAS J. ENGELLENNER
   3625 |      888 | 2010-09-24       | N               | 1979-03-05    | NORTHERN TELECOM LIMITED
   3634 |      874 | 1999-08-17       | N               | 1979-03-02    | MORRISON & FOERSTER LLP
   3634 |      875 | 1999-08-17       | N               | 1979-03-02    | THOMAS KAYDEN HORSTEMEYER ET AL.
   3692 |      537 | 2002-04-06       | N               | 1979-09-26    | EHD, INC.
   3696 |      452 | 2010-09-24       | N               | 1979-10-11    | PFIZER INC.
   3729 |      735 | 1999-07-29       | N               | 1980-01-28    | FLEHR, HOHBACH, TEST, ALBRITTON ETAL
   3737 |      606 | 2008-09-24       | N               | 1980-02-13    | SAMSON HELFGOTT
   3741 |      900 | 2010-09-24       | N               | 1990-03-24    | BROWDY & NEIMARK
   3765 |      757 | 1999-07-29       | N               | 1980-05-14    | WAQTSON COLE STEVENS DAVIS, P.L.L.C.
   3788 |      668 | 2010-09-24       | N               | 1980-08-15    | CHRISTIE, PARKER & HALE
   3788 |      670 | 2010-09-24       | N               | 1980-08-15    | ROBERT M. SPERRY
   3788 |      673 | 2008-09-24       | N               | 1980-08-05    | SPENCER & KAYE
   3788 |      675 | 1999-07-29       | N               | 1980-08-05    | HENRY W. KOSTER
   3788 |      676 | 2010-09-24       | N               | 1980-08-05    | DRESSLER, GOLDSMITH, SHORE
reel_no | frame_no |    correspondent_address_1    |     correspondent_address_2     |    correspondent_address_3     | correspondent_address_4 |                        conveyance_text                        
--------+----------+-------------------------------+---------------------------------+--------------------------------+-------------------------+---------------------------------------------------------------
   1280 |      340 | LAHIVE & COCKFIELD            | 60 STATE STREET                 | SUITE 510                      | BOSTON, MA  02109       | ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS).
   3625 |      888 | PATENT DEPT 265               | P.O. BOX 3511 STATION C         | OTTAWA ONTARIO CANADA K1Y 4H7  |                         | CHANGE OF NAME (SEE DOCUMENT FOR DETAILS).
   3634 |      874 | GARY E. CANN                  | 345 CALIFORNIA STREET           | SAN FRANCISCO, CA 94104-2675   |                         | ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS).
   3634 |      875 | DANIEL A. MCCLURE             | 100 GALLERIA PARKWAY, STE. 1500 | ATLANTA, GA 30339              |                         | ASSIGNMENT OF ASSIGNOR'S INTEREST (SEE DOCUMENT FOR DETAILS).
   3692 |      537 | 500 GOULD DRIVE               | COOKEVILLE, TN  38501           |                                |                         | ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS).
   3696 |      452 | PATENT DEPARTMENT, 20TH FLOOR | 235 EAST 42ND STREET            | NEW YORK, NEW YORK  10017-5755 |                         | MERGER (SEE DOCUMENT FOR DETAILS).
   3729 |      735 | FOUR EMBARCADERO CENTER       | SUITE 3400                      | SAN FRANCISCO, CA  94111-4187  |                         | ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS).
   3737 |      606 | POB 5012, FDR STATION         | NEW YORK, NY  10022             |                                |                         | ASSIGNMENT OF ASSIGNORS INTEREST.
   3741 |      900 | 419 7TH ST., N.W.             | WASHINGTON, DC 20004            |                                |                         | ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS).
   3765 |      757 | SUITE 1000 / CWV 17168        | 1400 K STREET , N.W.            | WASHINGTON, D.C.  20005        |                         | ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS).
   3788 |      668 | 201 SOUTH LAKE AVE.           | PASADENA, CA 91101              |                                |                         | ASSIGNMENT OF ASSIGNORS INTEREST.
   3788 |      670 | ROCKETDYNE DIV.               | 6633 CANOGA AVE.                | CANOGA PARK, CA 91304          |                         | ASSIGNMENT OF ASSIGNORS INTEREST.
   3788 |      673 | 1111 19TH, STREET N.W.        | WASHINGTON, D.C. 20036          |                                |                         | ASSIGNMENT OF ASSIGNORS INTEREST.
   3788 |      675 | C/O CURTIS, MORRIS & SAFFORD  | 530 FIFTH AVE.                  | NEW YORK, N. Y. 10036          |                         | ASSIGNMENT OF ASSIGNORS INTEREST.
   3788 |      676 | SUTKER & MILNAMOW, LTD.       | 1800 PRUDENTIAL PLAZA           | CHICAGO, IL 60601              |                         | ASSIGNMENT OF ASSIGNORS INTEREST.

Table Variables