The attached view will show the record id and record type that are associated with an element_global record. For each element_global, it will show:
ELEMENT_NATIONAL and subsequent ELEMENT_SUBNATIONAL and subsequent EOs, EO_RANK_SPECS
ELEMENT_GLOBAL (of which it is a parent),
This can be modified to include other records. Just copy over the basic select and change the record names.