EMA Makes Data Safe and Sound

Case Study: The physicians group uses BI tools to analyze patient information and spot health-crisis trends.

Jonathan Rothman knows the value of information, and, as an executive in the emergency services field, he also places top priority on issues of safety and security.

Rothman is the director of data management for Emergency Medical Associates, of Livingston, N.J.

The information that his company collects in its Oracle Corp. data warehouse can help facilitate everything from a patient getting the correct medication to measuring the quality of care in an emergency room to EMA getting new business.

EMA has been gathering and crunching data for about 17 years. Those years of work were crucial when the federal government reached out to the medical community after the Sept. 11, 2001, terrorist attacks in New York and Washington.

The task: help the government prepare for medical emergencies ranging from biological attacks involving such weapons as anthrax to tracking outbreaks of such new diseases as SARS (severe acute respiratory syndrome) and West Nile virus.

EMA would eventually enlist the help of systems integrator Sapphire Consulting Services Inc. to assist in bringing this information onto the Web and to help EMA safeguard that sensitive data.

EMA is an association made up of more than 220 doctors who manage 16 emergency rooms in greater New York City and northern New Jersey. With more than a decades worth of collected data and the business intelligence tools to manipulate and analyze the data, EMA was in a very good position for this type of work, Rothman said.

"After Sept. 11, there was a lot of talk from the federal government ... about what can be done with the data and who in the health community can supply the data to detect an anomaly," Rothman said. There was a limited number of databases available containing relevant information. But Rothman said it made sense to look at where EMAs physicians did their work for signs of an impending epidemic.

/zimages/5/28571.gifADP offers health care decision support. Read more here.

"What location would patients go to if there was a problem? They would go to their doctors office or the emergency room, and the most common place for patient complaints would be made available there," Rothman said.

That, of course, raised a new set of challenges related to protecting the integrity and privacy of collected data, since the EMA databases are fed directly from individual physicians and operating hospitals.

EMA installed its first emergency department management systems on computers at hospitals that had contracted with the company. The systems were used by doctors, nurses and other staff to house such information as lab data, prescriptions, doctors notes and discharge instructions, Rothman said.

The collection of data continued to evolve over time, and, in 1994, the company pulled the patient demographics—such as gender and patient needs—into its billing system.

EMA soon found it needed more BI and security tools to help it manage, analyze and protect the data, Rothman said. In 2000, the company moved away from giving physicians access to unique data sets for them and their sites and moved toward reporting and report distribution by analysts, which called for integrating information from inside and outside the data warehouse.

Rothman contacted various data warehousing software vendors to see what products they offered.

As a result of that process, EMA undertook a six-month pilot with Business Objects S.A. After the test, Rothman said EMA adopted the San Jose, Calif., vendors BusinessObjects software suite.

Business Objects BI technology enabled EMA to consolidate billing and clinical data into a single data warehouse. It also gave EMA greater control over the data, which, given the amount of patient information that was included, was crucial—particularly when HIPAA (Health Insurance Portability and Accountability Act) regulations took effect in 1996.

"The goal was to try to use the information that was consolidated to support the operations of the emergency departments," Rothman said.

"Prior to 1998, we had no business intelligence [regarding the data]. It became a requirement for us. ... The goal of the data warehouse at the outset was just to keep us afloat and help us survive. Now we can use it for more efficient care, better customer satisfaction and to prove our worth to clients."

Pat Morrissey, worldwide marketing director for enterprise development management at Business Objects, said EMAs use of the BI software improved the groups operation.

"Their view of the world is that they can provide better quality of patient care and are absolutely certain they can back it up with the numbers," Morrissey said.

After the 9/11 attacks and the ensuing worries over bioterrorism, Rothman said he knew that EMA needed tools to help use the clinical and billing information it was gathering from patient contacts to help it track medical problems before they blossomed into epidemics.

The need was to include massive amounts of data from individual patient records in a database that would reveal only general health care and patient injury trends to group members accessing the information.

Next Page: Business Objects provides the solution.