SQL Queries For Mapping Your EPCR

These are the queries you can provide your IT in order to map your Hospitals, Agencies, Crew Member in your EPCR

 

Agencies

SELECT ID2, Name, Address, City, State FROM [EMS Agency] WHERE Deleted = 0

Hospitals

SELECT ID2, Name, Address, City, State FROM Hospitals WHERE Deleted = 0

Crew Names

SELECT ID2, Lastname, Firstname, (SELECT Name FROM CrewType WHERE ID = CrewTypeID) FROM Crew WHERE Deleted = 0

Bases

SELECT ID, NNumber, CallSign, Type, (SELECT Name FROM Bases WHERE ID = Assets.BaseID) FROM Assets

Priority

SELECT * FROM priority WHERE Deleted = 0