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 ...

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.