353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 16:46, 27 March 2017
, 16:46, 27 March 2017→Restructure Address Information
::*ptoassigneend_missus_final
:::State and postcode information are extracted from addrline1, addrline2 and city columns and are stored in ptoassigneend_missus_final table. See section 2 and 3 and 4.
:::This table is a subset of ptoassigneend_allus table.
:::state_city is the state name extracted from 'city'. state_addr1 is the state name extracted from 'addrline1'. state_addr2 is the state name extracted from 'addrline2'.
::*ptoassigneend_cityptoassigneend_missus_city_final
:::City information are extracted from addrline1, addrline2 and city columns and are stored in ptoassigneend_city table. See section 54.
:::This table is a subset of ptoassigneend_allus table.
