Manage health care data more quickly

Community Care Behavioral Health Organization has reduced the time it takes to process data by two-thirds, despite the volume of data increasing by 50 percent a year. With the SAS® Data Integration platform, Community Care is better able to provide cost-effective services for its 1 million members while meeting regulatory obligations.

Pittsburgh-based Community Care manages behavioral health coverage for Pennsylvania Medicaid, Medicare and commercial members. It has been honored for ethical practices in patient care by the American Association of Community Psychiatrists. The organization prides itself on paying particular attention to coordinating care with medical insurers and social service agencies, as behavioral health often affects physical illness and vice versa.

For many years, Community Care used an outside vendor to assist with data processing, but felt going forward it needed to bring the process in-house and blend the data with additional sources to help truly coordinate care. "Our goal is to have one source for all our data reporting," says Mary Doyle, Associate Chief Information Officer.

Community Care's data vendor encouraged the organization to look at SAS. Community Care's IT department was not a SAS shop and was not familiar with the scope of SAS products. The organization invited SAS and another vendor to demonstrate their products. SAS was the unanimous choice – even among the technical staff that had reservations about SAS. "We were sold on the data quality/data cleansing aspects," Doyle said.

... we were able to apply SAS best practices in our data warehouse work, thus reducing the trial and error ...

Mary Doyle
Associate Chief Information Officer

"The pure nature of the data integration studio in terms of point and click versus some of the maintenance of the competitors – SAS is just so much more straightforward," Doyle said.

Community Care manages data obtained from claims processing, internal clinical transactions, member eligibility, and financial and pharmaceutical data.
 
Community Care now has the option to run reports weekly instead of monthly, and the run times have dropped dramatically. Programming is much simpler, Doyle says. Shortening processing time is incredibly important, because the company’s claims record is 60 gigabytes and is expected to grow by another 30 to 40 gigabytes in the next year. It also stores and reports on 15 gigabytes of authorization data.

Being able to run reports more frequently allows the organization to make better data-driven decisions. "That's something our CEO is really focused on," she says.

For instance, the company can now measure clinical interventions. Does a patient released from the hospital need six follow-up services to maintain the discharge plan, or is eight the preferred number? More importantly, can the staff quickly see which members aren't following post-hospitalization protocols?

"Being able to flag records is so much easier," Doyle says.

The speed and ease also gives Doyle more time to provide customized reports for individual departments.

The organization has also engaged in joint projects with an affiliated physical health insurance plan responsible for serving Pennsylvania residents enrolled in Medicare or Medicaid. The goal is to understand how physical diseases affect behavioral health and vice versa and to use data to help the consumer with all aspects of their health care. Once insurers understand the use patterns, they can team with medical personnel to come up with methods to address the problems. "We've actually been able to move our side of this analysis much quicker using SAS as an analytical tool," Doyle says. "We're looking at being able to structure some data to help answer public health-sector questions."

She says the organization plans to add a predictive analytics component..

The company used SAS Consulting® services to get SAS Data Integration up and running quickly.

"The decision to implement SAS strategies in building our warehouse had a direct impact upon its success. By partnering with SAS, we were able to apply SAS best practices in our data warehouse work, thus reducing the trial and error that we might have otherwise endured. We had a wonderful experience," Doyle said.

"I've worked with a lot of different consultants before, and I have to say this is the first one that came in under budget. I thought the folks we worked with were very practical. They were respectful of the fact that we had a very limited number of hours to work with and everything we asked for was given. Working with SAS has been exceptional."

Challenge

Needed to bring its data warehouse in-house, work with multiple sources of data and produce reports quickly.

Solution

SAS® Data Integration

Benefits

Slashed processing time by two-thirds and can make better data-driven decisions.

 

本文中所展示的成果取决于文中所述的特定场景、业务模式、数据输入和计算环境。每位SAS客户的体验都因其业务和技术特性而不同,请勿将本文观点视为通用观点。实际的成本节约、成果和效果最终取决于每位客户的实际配置和条件。SAS不保证每位客户都能取得本文类似的成果。SAS仅对SAS的产品和服务提供保证,请参阅SAS的产品服务质保条款,本文中提及的内容不能视为质保条款。客户可以按照合约商定的条款分享SAS软件实施项目的成功案例,相应的品牌和产品名称归属相应的公司所有。

Back to Top