Facility Profiler. North Dakota Department of Health- Environmental Health Section Gary Haberstroh firstname.lastname@example.org 701.328.5206. Facility Profiler. Why did we implement the Facility Profiler How the Facility Profiler Works Facility Profiler Mapping Tool Overview.
North Dakota Department of Health-Environmental Health Section
Section Wide Enterprise database solution
Ware house database
Very Expensive, Very Process Dependent
Data is duplicated, but everyone has their own data
Requires a lot of coordination and who owns what data
We chose Ware house
FP is a Microsoft .NET with a Microsoft SQL Database.
Stored Procedures extract facility data from program databases each night
Data retrieved includes Name, Location (911 address, TRS, Lat Long), Contacts, Program permit data.
Checks for new facilities and changes to data
North Dakota Department of Health
Environmental Health Section Chief’s Office