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
Comments
0 comments
Please sign in to leave a comment.