There are separate queries attached to this solution - one for Biotics5 (Oracle SQL) and one for Biotics6 (PostgreSQL).

WHY PERFORM THE QC: During the exchange of EST data from a local Network Program database to the central NatureServe database, a record is rejected if it has an Sname that is used in more than one locally maintained EST record.

WHAT THE QUERY DOES: This query finds ELEMENT_SUBNATIONAL records that have a Subnational Scientific Name (Sname) that is used in more than one ELEMENT_SUBNATIONAL record.

ACTION: Check the Sname, distribution data, and Concept Reference (in the related ELEMENT_GLOBAL) of each record to make sure you are maintaining only the record for the taxon accepted in your jurisdiction. Delete unnecessary EST records. If you are actively maintaining EST records in your system for taxonomic concepts your program does not actually recognize, notify Central Science staff by submitting a support ticket (in Biotics: click “Contact Support” at the bottom of any screen, select “New support ticket” and fill in the form, entering Application: Biotics, Component: Science Request).