We are planning to ADD a new value to USESA Code, Description, and Display Value in the table D_USESA to conform with the Species Status Codes assigned by the U.S. Fish and Wildlife Service (USFWS).
New value: UR: Under Review
Definition from https://www.fws.gov/endangered/about/listing-status-codes.html: Species that have been petitioned for listing and for which a 90 day finding has not been published or for which a 90 day substantial has been published but a 12 Month finding have not yet been published in the Federal Register. Also includes species that are being reviewed through the candidate process, but the CNOR has not yet been signed.
This domain table is referenced by the TAXON_GLOBAL table only.
Values for the new row in D_USESA:
D_USESA_ID: 43
USESA_CD: UR
USESA_DESC: Under Review
DISPLAY_VALUE: UR: Under Review
DISPLAY_ORDER: 43
SEARCH_VALUE: UR
Interpreted USESA fields
Note that, although rare, there may be cases where "UR" is stored in the field Interpreted USESA in the global and national tables (TAXON_GLOBAL.INTERPRETED_USESA and TAXON_NATIONAL.INTERPRETED_USESA). Remember that the State Interpreted USESA field is populated locally only, so Under Review will only be entered in that field if your program enters it.
Calculated USESA
The Calculated USESA field will return the new codes when the result of the calculation is the value in D_USESA.USESA_CD (from TAXON_GLOBAL.D_USESA_ID).
------------
In addition, we are planning to ADD a new value to Ranking field: Rank Methodology Used
New value: Calculated rank revised by expert
This field appears in the Global, National, and Subnational Element Ranking record. The purpose of this new value is so that we can clearly identify the unusual cases where the rank value calculated by the rank calculator has been intentionally adjusted manually by an expert. The value in the global record will then be reported on NatureServe Explorer (for Rank Method Used) with reasons entered in the field Rank Adjustment Reasons.
Biotics domain table: D_RANK_METHOD_USED
New domain row values:
D_RANK_METHOD_USED_ID = 9
RANK_METHOD_USED_DESC = Calculated rank revised by expert
EXTERNAL_DESC = Calculated rank revised by expert
DISPLAY_ORDER = 9
These have not yet been implemented but will likely be in the upcoming sprint which ends on 3/29/22. If anyone has any questions regarding the upcoming change, please submit a ticket to the Help Desk.