===For the USPTO Maintenance Fee Data===
Download the file manually from https://bulkdata.uspto.gov/data2/patent/maintenancefee/and
replace existing file in McNair/Patent Data/Maintenance Fee Data.
Schema for maintenance fee table, called according to documentation:
feecode | character varying |
Seems to contain instructions for making maintenance fee and fee code tables in table - but how do we parse the original data? http://mcnair.bakerinstitute.org/wiki/Patent_Expiration_Rules
Based off opening the text file mentioned in the instructions in the above link and the new text file I downloaded from USPTO bulk, that text file is already in the correct format to load into the database using the code in Patent Expiration Rules.