DESCRIPTION
KB 119 instructs Kestrel users to submit an issue to Product Support if they receive an automated email notifying them that one or more observations are linked to deleted Biotics ENT records. The notification email will list the "name" of a deleted record as "UNKNOWN SPECIES: ELEMENT_NATIONAL.Y.XXXXXX", where Y = the element_national_ou_uid and XXXXXX = the element_national_seq_uid. We at NatureServe will need to query the deleted schema of Central Biotics to find out the name of the element and tell the Kestrel user.

CAUSE
Occasionally elements are deleted in Biotics because a duplicate has been entered, either with exactly the same name or with a slightly different name. There's no taxonomic difference between the two, so one is deleted instead of inactivated.

RESOLUTION
Example: The deleted species is UNKNOWN SPECIES: ELEMENT_NATIONAL.2.792094

Log into the deleted schema in Toad or TOra. Schema name is hdmsdel, password is same as production Biotics regular schema.

Run the following query:
select entdel.element_national_id, sn.scientific_name, entdel.n_primary_common_name, entdel.element_national_seq_uid, entdel.element_national_ou_uid
from element_national_del entdel, hdms.scientific_name sn
where entdel.nname_id = sn.scientific_name_id
and entdel.element_national_seq_uid = 792094 and entdel.element_national_ou_uid = 2

Example Results:
792094 Alces americanus Moose 792094 2
(usually, but not always, the element_national_id is the same as the element_national_seq_uid)

First, search for a Canadian ENT with exactly the same name in Tracker. If you find one, tell the Kestrel user the original scientific and common names and that there is a replacement record with the same scientific (and common, if applicable) name. He/she needs to edit the Observation record and search for that name (e.g., Alces americanus), select it, and save the Observation.

If you can't find the replacement element with the same name or you aren't sure about it, email a central zoologist or botanist to ask them why the original record was deleted and what took its place.