  INSERT INTO V2
  (AGENCYID, V2INITIALTRAVELDIRECTION, V2VEHICLEMANEUVER, V2VEHICLECONFIGURATION, V2FIRSTEVENT, V2DRIVERDOB, VISION_BLOCKAGE, DRIVER_CONDITION)

  select b.acdyear_number as agencyid, b.vehicle_direction as V2INITIALTRAVELDIRECTION, b.vehicle_action as V2VEHICLEMANEUVER,
  b.vehicle_type as V2VEHICLECONFIGURATION, b.contrib_factor as V2FIRSTEVENT, b.operator_dob as V2DRIVERDOB, b.vision_blockage, b.driver_condition
  from acdu_units_loc_02_09 b
  where b.UNIT_NBR = '02'; 