INSERT INTO ANIMAL_TB
        (
        GROUP_INDEX,
        PEDIGREE_PREFIX,
        PEDIGREE_SUFFIX,
        STRAIN,
        GENOTYPE,
        COAT_COLOR,
        SEX,
        DISPOSITION,
        BIRTH_DATE,
        INVESTIGATOR,
        FACILITY_INDEX
        )
        VALUES
        (
        :groupID,
        :pedigree1,
        :pedigree3,
        :strain,
        :genotype,
        :coatColor,
        :sex,
        :disposition,
        to_date(:birthDate, 'mm/dd/yyyy'),
        :investigator,
        :facilityID
        )
        RETURNING ANIMAL_INDEX