Who to send an email to: This procedure builds a list of User ID’s that have the role of Fiscal Editor, Public Safety Editor, or Administrator and are assictaed with the School District that has at least one Public Safety Drill scheduled in the next 8 days. The prodecure stores this list of User ID’s in a temp table named: “tmp_psd_users”. It loops through these User IDs and calls the stored procedure named: “psdEmailGatherDrillsForUserID

”.

Uses: temp table: tmp_psd_users

Calls: psdEmailGatherDrillsForUserID