INSERT INTO V1
  (AGENCYID, V1INITIALTRAVELDIRECTION, V1VEHICLEMANEUVER, V1VEHICLECONFIGURATION, V1FIRSTEVENT, V1DRIVERDOB, VISION_BLOCKAGE, DRIVER_CONDITION)
  
  select b.acdyear_number as agencyid, b.vehicle_direction as V1INITIALTRAVELDIRECTION, b.vehicle_action as V1VEHICLEMANEUVER,
  b.vehicle_type as V1VEHICLECONFIGURATION, b.contrib_factor as V1FIRSTEVENT, b.operator_dob as V1DRIVERDOB, b.vision_blockage, b.driver_condition
  from acdu_units_loc_02_09 b
  where b.UNIT_NBR = '01'; 