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 ELEMENT_SUBNATIONAL data from a local Network Program database to the central NatureServe database, a record is rejected if the Sname does not (a) match the Gname or (b) one of the names in the Global Synonyms grid.

WHAT THE QUERY DOES: This query finds ELEMENT_SUBNATIONAL records where the Subnational Scientific Name (Sname) is not the same as the Global Scientific Name in the related ELEMENT_GLOBAL record, and is also not included in the set of global synonyms for that ELEMENT_GLOBAL.

ACTION: Check the Sname to make sure it is correct and is a synonym for the same concept as indicated in the parent ELEMENT_GLOBAL. If not, update the Sname or move the subnational data and any EOs to a more appropriate element. If you believe the name is a synonym that needs to be added to the list of global synonyms, notify Central Science Staff by creating a support ticket to request the addition (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).