WHAT THE QUERIES DO:

These queries report Data Exchange Workbench Alerts that are global and national notifications which are undismissed (i.e., appear in the workbench; the queries can be edited to included dismissed alerts).

• wb_alerts_global_national_notifications.txt - Contains basic workbench fields, data from the related subnational tracking record, and a count of related EOs.
• wb_alerts_g_n_notifications_tax-info.txt - Contains all fields from the basic query, plus Taxonomy Comments, Termination Comments, and Successors from the EGT record.

NOTES:

• The report is sorted by the workbench alert ID (alert_id, alias alert_id_wb_sort) to mimic the order in the workbench.
• The query is intended for ease of communication to those who may not have access to or comfort with the Data Exchange Alerts Workbench. Actual update of records is facilitated in the workbench. 
• Alerts should be dismissed in the workbench once information is reviewed and any desired updates have been made in Biotics.