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 characters not recognized by the rank rounding logic, the ROUNDED_S_RANK field will contain the word “invalid.” The ROUNDED_S_RANK is often used for analyses. In addition, NatureServe Explorer relies on a valid ROUNDED_S_RANK in two important ways:
- ROUNDED_S_RANK is used to validate the distribution grid and the distribution grid is used to select which ELEMENT_SUBNATIONAL records are displayed on NatureServe Explorer.
- ROUNDED_S_RANKs are used on the NatureServe Explorer province/state maps.
WHAT THE QUERY DOES:
The attached query finds ELEMENT_SUBNATIONAL records that have an invalid rounded s_rank.
ACTION:
Correct the S_RANK by fixing the invalid syntax, or re-entering if necessary.