WHY PERFORM THE QC:  During the local to central data exchange process, all EO records that have invalid Principal/ Sub-EO relationships will not be provided to Central. This is an invalid data state, and records with this error do not appear in the import report because they are not exported. Running the QC and reviewing the records will potentially reduce the number of EO records that are missing from Central.  


WHAT THE QUERY DOES: This query finds EO records where the EO references itself as its own principal EO or the principal EO has its own principal EO (EO nesting of more than 2 levels). All records that are returned by the query will be excluded from the local-to-central data updates. 


ACTION: Review the results of the query and make edits to the EO Principal / Sub-EO relationships to fix any problems.