The attached getCLASSIFCODE function allows you to include the higher classification/taxonomy code for an element without linking to the higher classification table where the code is stored. The code is a summary of higher classification information down to the family level for species and the alliance level for communities and is displayed read-only in Element Tracking records.
Run the attached getCLASSIFCODE.sql script. The getClassifcode function returns the higher classification/taxonomy code for an element given the element_global_id so it can be easily retrieved without linking to higher_class_unit.
SELECT getClassifCode(element_global_id) as classif_code,
WHERE rownum <50
Caution: Higher classification/taxonomy codes have not been developed comprehensively for all elements, including nonvascular plants and fungi.