Difference between revisions of "PTO Assignment"

From edegan.com
Jump to navigation Jump to search
(Created page with "Back to Patent Data Specifications. Table "public.ptoassignment" Column | Type | Modifiers ----------------...")
 
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Back to [[Patent Data Specifications]].  
+
Back to [[PTO Tables]].  
  
 +
==Table Structure==
 
                         Table "public.ptoassignment"
 
                         Table "public.ptoassignment"
 
         Column          |          Type          | Modifiers  
 
         Column          |          Type          | Modifiers  
Line 15: Line 16:
 
  correspondent_address_4 | character varying(500) |  
 
  correspondent_address_4 | character varying(500) |  
 
  conveyance_text        | 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==
 +
[[Category: Internal]]
 +
[[Internal Classification: Data Tables| ]]

Latest revision as of 12:13, 20 January 2017

Back to PTO Tables.

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