select bioRecordKey, institution_code_id, collection_code_id,
	bioRecordTaxonKey, bioRecordResourceKey, bioRecordCountryCode,
	gatheringYear, recordBasis
into bioRecord_base
from syn_raw.dbo.raw_data;

select bioRecordKey as brKey, bioRecordId, geoLongitude, geoLatitude, gatheringDate,
	collector, localityText, guid, fieldNumber, collectorNumber, accessionNumber
into bioRecord_ext
from syn_raw.dbo.raw_data;