QC Queries
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
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
There are separate queries attached to this solution - one for Biotics5 (Oracle SQL) and one for Biotics6 (PostgreSQL). This query of plant and animal E...
Thu, 22 Oct, 2026 at 12:07 PM
WHY PERFORM THE QC: During the exchange of ELEMENT_SUBNATIONAL data from a local Network Program database to the central NatureServe database, only locally ...
Wed, 20 Sep, 2017 at 3:39 PM
There are separate queries attached to this solution - one for Biotics5 (Oracle SQL) and one for Biotics6 (PostgreSQL). WHY PERFORM THE QC: During the e...
Thu, 22 Oct, 2026 at 5:41 PM
There are separate queries attached to this solution - one for Biotics5 (Oracle SQL) and one for Biotics6 (PostgreSQL). WHY PERFORM THE QC: During the e...
Thu, 22 Oct, 2026 at 5:57 PM
WHY PERFORM THE QC: During the exchange of ELEMENT_SUBNATIONAL data from a local Network Program database to the central NatureServe database, records with ...
Wed, 20 Sep, 2017 at 3:00 PM
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 r...
Wed, 20 Sep, 2017 at 3:28 PM
There are separate queries attached to this solution - one for Biotics5 (Oracle SQL) and one for Biotics6 (PostgreSQL). WHY PERFORM THE QC: During the...
Thu, 22 Oct, 2026 at 5:48 PM
WHY PERFORM THE QC: This is an invalid condition not allowed or expected by the Biotics 5 interface. Furthermore, during the exchange of ELEMENT_OCCURRENCE ...
Thu, 31 May, 2018 at 10:53 AM