===Branch Offices===
I did not use old branch office data because I could not find it anywhere in the old data set. I have since found old data in the table firmbasecoords in vcdb2.
First copy all of the needed data out of the database to do geocoding.