QC Queries

Threats Assessment Missing Higher Level Threat
WHY PERFORM THE QC:  Threat Impact is calculated from Level 1 threats only (e.g. 7 Natural system modifications).  If a Level 2 or 3 threat (e.g. 7.2 Dams &...
Thu, 18 Apr, 2019 at 8:00 AM
Threats Assessment: Mismatches between Calculated Threat Impact and Scope/Severity/Timing
WHY PERFORM THE QC:  The threat impact calculation has been implemented in biotics ranking records, so going forward Calculated Impact will automatically ca...
Mon, 1 Apr, 2019 at 8:15 AM
Identify Invalid References
How to clean up your references to meet reference rules Reference codes must be 12 characters long and end in subnationCode followed by nationCode. For exa...
Fri, 10 Aug, 2018 at 9:50 AM
Use of Central references in program databases
What is a Central reference? A central reference has Maintained By Status = C: Centrally. It should also have one of these Accepted Central suffixes. If it...
Fri, 10 Aug, 2018 at 3:28 PM
Review of EO records that are marked "Do Not Exchange"
WHY PERFORM THE QC:  During the local to central data exchange process, all EO records that are marked as "Do Not Exchange", as well as compone...
Tue, 25 Oct, 2022 at 11:15 AM
EST records for SPECIES that have an EO but the DISTRIBUTION CONFIDENCE is not “confident”:
This query finds all ELEMENT_SUBNATIONAL records for SPECIES that have an EO, and the DISTRIBUTION CONFIDENCE is any value other than “confident”:  NT (Ne...
Thu, 4 Apr, 2019 at 11:31 AM
Identify inconsistencies in the SRANK of infra taxa and their related “parent” species
This query checks for inconsistencies in the SRANK of infra taxa and their related “parent” species.  Example: Infra SRANK = S4 and parent SRANK = SH.    ...
Tue, 20 Dec, 2016 at 3:41 PM
QC ESTs on Nonstandard Elements
WHY PERFORM THE QC:  It is much better for your ESTs to be on Standard rather than Nonstandard elements, because: Nonstandard elements are NOT on Explorer...
Tue, 14 Mar, 2023 at 8:25 AM
EO records with “Last Observation Date” (LASTOBS) values that potentially need review
This query selects EO records with “Last Observation Date” (LASTOBS) values that potentially need review.  ACTION: Please review the values in the EO LA...
Tue, 20 Dec, 2016 at 3:44 PM
EST records that have a NATIONAL origin of “exotic”, the SUBNATIONAL DISTRIBUTION CONFIDENCE is “Confident,” and the SUBNATIONAL ORIGIN is either “Native” or “Unknown/Undetermined
This query selects all ELEMENT_SUBNATIONAL records that have a NATIONAL origin of “exotic” in your nation, the SUBNATIONAL DISTRIBUTION CONFIDENCE is “Confi...
Tue, 20 Dec, 2016 at 3:46 PM