A "Code Brown" is declared by a health service or facility when additional capability and capacity needs to be mobilised with hospitals preparing to expect an influx of patients due to an emergency.

I'm having trouble figuring out how to write a particular trigger to avoid having it recurse. This trigger is an after update trigger that operates on the same table that fires it. This is a database ...