Changes

Jump to navigation Jump to search
::*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.

Navigation menu