QC Queries

Review of EOs with Invalid Principal / Sub-EO relationships
WHY PERFORM THE QC:  During the local to central data exchange process, all EO records that have invalid Principal/ Sub-EO relationships will not be provide...
Fri, 11 Jan, 2019 at 8:24 AM
Find Independent Source Features
WHY PERFORM THE QC:   When a Program does not want a sensitive Source Feature (SF) uploaded to Central Biotics via the local to central data exchange proce...
Tue, 15 Oct, 2019 at 11:16 AM
Endemic Species - Find Rank and Data Inconsistencies
WHAT THE QUERY DOES: This query reports any record where a taxon is recorded as: endemic to a single state or province in the Global Tracking field “Juris...
Fri, 2 Sep, 2022 at 7:51 AM
Invalid SRANK QC
WHY PERFORM THE QC: When a user updates the S_RANK field, a stored procedure generates the ROUNDED_S_RANK. If the S_RANK contains syntax errors or charact...
Fri, 27 Oct, 2023 at 7:56 AM