QC Queries

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...
Wed, 8 Aug, 2018 at 8:22 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 (N...
Tue, 20 Dec, 2016 at 3:41 PM
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
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
Identify errors related to SRANK Review Date
Queries to help find and fix possible errors related to SRANK Review Date. (Updated 9/19/2016 by Lynn Kutner)   The following are modified from queries p...
Tue, 20 Dec, 2016 at 3:55 PM
Identify species EOs with an SRANK of "SX" or "SH" and with an EORANK value that is NOT “X”, “H”, or “F” (or is null)
This query selects species EO with an SRANK of "SX" or "SH" and with an EORANK value that is NOT “X”, “H”, or “F” (or is null). This app...
Tue, 20 Dec, 2016 at 3:57 PM
Identify invalid distribution data and rank for species EST records
This query of plant and animal ELEMENT_SUBNATIONAL records finds inconsistent or invalid distribution data and rank using the Rank and Distribution Data Con...
Tue, 11 Sep, 2018 at 7:43 AM