Description:

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.

Solution:

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.

Example:
SELECT getClassifCode(element_global_id) as classif_code,
elcode_bcd
FROM element_global
WHERE rownum <50

Caution: Higher classification/taxonomy codes have not been developed comprehensively for all elements, including nonvascular plants and fungi.