Agency Checkboxes

This is a quick way to activate the checkboxes inside Agencies for RequestOrReceive and CanProvideTransport.

Remember that Common Places are stored inside Agencies with a 1 in CommonPlace and account for them.

Instructions

--Checks all Agencies "Can Request or Receive"

UPDATE [EMS Agency] Set CanRequestOrReceive = 1

--Checks all Agencies "Can Provide Transport Box"

UPDATE [EMS Agency] SET CanProvideTransport = 1 WHERE CommonPlace = 0 AND Deleted = 0