1,181
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 14:34, 3 May 2017
, 14:34, 3 May 2017→Semester Plan
Currently the pto tables contain varying identifiers for one invention title that is involved in a reassignment. The purpose of the table is to have each identifier for an invention title listed in a single row, making it easy to track the invention through various transactions. The Match By column will inform the user which identifier should be used to match to other tables in the patent database.
The tables that currently comprise the assignment data are as follows.
Table "public.ptoassignment"
Column | Type | Modifiers
-------------------------+------------------------+-----------
reelno | integer |
frameno | 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) |
==Data Cleanup Progress==
