619
edits
Changes
Jump to navigation
Jump to search
reelno reel | integer | frameno frame | integer |
reelno reel | frameno frame | recdate | actionkeycode | trandate | dateproduced -------+---------+------------+---------------+------------+-------------- 15283 | 39090 287 | 698 | 20161970-0701-07 04 | DA AN | 2016-0701-08 06 | 2013-11-01 39092 5744 | 620 401 | 20161975-0709-07 08 | DA AN | 2016-0701-08 04 | 2013-11-01 39090 3634 | 667 874 | 20161979-0703-07 02 | DA AN | 2016-0701-08 04 | 2013-11-01 39090 3634 | 676 875 | 20161979-0703-07 02 | DA AN | 2016-0701-08 04 | 2013-11-01 39090 3625 | 740 888 | 20161979-0703-07 05 | DA AN | 2016-0701-08 04 | 2013-11-01 39092 8613 | 129 265 | 20161979-0705-07 27 | DA AN | 2016-0701-08 06 | 2013-11-01 39090 3835 | 591 710 | 20161979-0709-07 | DA AN | 2016-0701-08 04 | 2013-11-01 39090 3692 | 664 537 | 20161979-0709-07 26 | DA AN | 2016-0701-08 04 | 2013-11-01 39094 3696 | 73 452 | 20161979-0710-07 11 | DA AN | 2016-0701-08 04 | 2013-11-01 39094 3818 | 38 140 | 20161980-0701-07 02 | DA AN | 2016-0701-08 04 | 2013-11-01
Assignment Date Table (view source)
Revision as of 17:16, 2 September 2016
, 17:16, 2 September 2016no edit summary
==Table Purpose==
<section begin="date" />The Assignment Date Table distinguishes which USPTO XML file an assignment was stored on based on whether the assignment was included in an annual or daily release of records. Recently, the USPTO began to update its assignment records on a daily basis. For assignments that occurred earlier on, the assignment records were only updated on an annual basis. <section end="date" />
==Table Structure==
Column | Type | Modifiers
--------------+------------------------+-----------
recdate | date |
actionkeycode | character varying(500) |
trandate | date |
dateproduced | date |
Example of table entries:
==Table Variables==
Reel and frame give the location on the microfilm files where the particular transaction is recorded. The reel number and frame number are unique to a transaction between the assignee and assignor. The recdate is the date the assignment was recorded. The actionkeycode is an indicator for whether the transaction was included in a daily, weekly, bi-monthly or annual release. The trandate is when the data was extracted into the file.[http://www.uspto.gov/sites/default/files/products/assign-documentation.pdf] The table has a composite key consisting of reel, frame, and recdate.
==Current Problems==
Meaning of dateproduced is unknown.
[[Category: Internal]]
[[Internal Classification: Legacy| ]]
