Difference between revisions of "Assignment Date Table"
| Line 2: | Line 2: | ||
==Table Purpose== | ==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== | ==Table Structure== | ||
Revision as of 16:24, 28 July 2016
Return to USPTOAssigneesData.
Table Purpose
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.
Table Structure
Table "public.assignmentdate" Column | Type | Modifiers --------------+------------------------+----------- reel | integer | frame | integer | recdate | date | actionkeycode | character varying(500) | trandate | date | dateproduced | date |
Example of table entries:
reel | frame | recdate | actionkeycode | trandate | dateproduced ------+-------+------------+---------------+------------+-------------- 15283 | 287 | 1970-01-04 | AN | 2016-01-06 | 2013-11-01 5744 | 401 | 1975-09-08 | AN | 2016-01-04 | 2013-11-01 3634 | 874 | 1979-03-02 | AN | 2016-01-04 | 2013-11-01 3634 | 875 | 1979-03-02 | AN | 2016-01-04 | 2013-11-01 3625 | 888 | 1979-03-05 | AN | 2016-01-04 | 2013-11-01 8613 | 265 | 1979-05-27 | AN | 2016-01-06 | 2013-11-01 3835 | 710 | 1979-09-07 | AN | 2016-01-04 | 2013-11-01 3692 | 537 | 1979-09-26 | AN | 2016-01-04 | 2013-11-01 3696 | 452 | 1979-10-11 | AN | 2016-01-04 | 2013-11-01 3818 | 140 | 1980-01-02 | AN | 2016-01-04 | 2013-11-01
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.[1] The table has a composite key consisting of reel, frame, and recdate.
Current Problems
Meaning of dateproduced is unknown.
