insert into claim
(
    id,
    policy_id,
    person_id,
    incident_id,
    first_notification_of_loss,
    police_reference,
    photos_to_follow,
    sketch_to_follow,
    description_of_weather,
    description_of_property_damage,
    created_at,
    updated_at
)
select
    a.id,
    a.policy_id,
    a.person_id,
    b.id                              as incident_id,
    a.first_notification_of_loss,
    a.police_reference,
    a.photos_to_follow,
    a.sketch_to_follow,
    a.description_of_weather,
    a.description_of_property_damage,
    a.created_at,
    now()                             as updated_at
from
    old_claim a
    left outer join
    incident b
    on a.id = b.id;
