Difference between revisions of "Assignment Date Table"
| (2 intermediate revisions by one other user not shown) | |||
| 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== | ||
| Line 32: | Line 34: | ||
==Table Variables== | ==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.[http://www.uspto.gov/sites/default/files/products/assign-documentation.pdf] | + | 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== | ==Current Problems== | ||
Meaning of dateproduced is unknown. | Meaning of dateproduced is unknown. | ||
| + | |||
| + | [[Category: Internal]] | ||
| + | [[Internal Classification: Legacy| ]] | ||
Latest revision as of 16:16, 2 September 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.
