At Texas Children’s, Data Transparency and Analytics Help Improve Physician Productivity

Nov. 3, 2015
Leveraging an enterprise data warehouse (EDW) and doing advanced analytics allowed Texas Children’s Hospital to take a deep dive into physicians’ actual productivity.

While physician compensation continues to rise, productivity remained flat in 2014, according to consulting firm SullivanCotter’s Medical Group Compensation and Productivity Survey, released this summer. For hospitals, that’s an unsustainable trend, as their survival depends on getting the most—and best—work possible out of their physicians.

As such, as patient care organizations experience the shift to value-based care, they might begin to see their bottom lines decline at first. At Texas Children’s Hospital in Houston, this trend created a new urgency to fully understand its costs in relation to its revenues. At the core of the hospital’s approach involved using an enterprise data warehouse (EDW) and analytics to take a deep dive into physicians’ actual productivity.

In the past, Texas Children’s process for determining physician productivity was far too labor-intensive to support efficient decision-making, the organization’s officials say. Specifically, practice managers were required to access multiple databases on an ongoing basis to gather the data required to calculate relative value units (wRVUs)—a measure of value used in the Medicare reimbursement formula for physician services.

The effort was so resource-intensive that it took four weeks to obtain the necessary data. To compound matters, the reports lacked a common look or feel; each report was unique to the practice administrator, revenue cycle manager or data analyst that produced it. This complicated, time-consuming and inconsistent process made it very difficult—and sometimes impossible—for leadership to understand where physicians’ productivity and associated compensation stood compared to their peers internally and nationwide, says Mark Mullarkey, senior vice president at Texas Children’s.

While evaluating what was needed to make physician practice management more efficient, Texas Children’s leaders knew that they needed to have complete transparency and readily-available data to be able to put in front of administrative and physician leaders so they can see quickly if operational tweaks would create the outcome and change they were looking for, Mullarkey says. As such, they tapped into many different data sources from financial systems, its electronic medical record (EMR), patient satisfaction surveys, and other interfaces of other systems, bringing that all into its enterprise data warehouse, he says. On top of this, the organization leveraged Salt Lake City, Utah-based Health Catalyst’s Labor Productivity application to run on its existing EDW platform.

“The [EDW] enabled us to have one consistent view, rather than going to 20 or 30 different spreadsheets or systems to look things up. [We] used to spend more time looking for data and massaging it than understanding the data and doing interventions to make the needed changes. The data was at our fingertips, and that made a big difference,” Mullarkey says.

Mark Mullarkey

Mullarkey gives an example of bringing in EMR scheduling into the database, which allowed Texas Children’s to show in its reporting what its schedule template utilizations were. “We created such complexities in our EMR, it was not evident to us that we had the various openings in our schedules that we had,” he says. “Doctors would say to us that we want them to be as productive as possible, but they have these opening slots in their day which we need to fill in. This wasn’t about telling physicians to work harder, but about us as a team to make sure every opportunity was being maximized. We brought that right into the EDW, and we could [categorize] by specialty, by group, by physician, or by location to see where the opportunities were,” Mullarkey says. As such, the hospital was able to see in real time, through the data warehouse views that it built, if these operational tweaks were making a difference. “We saw 70 percent utilization rates increase to 90 percent. There was much greater transparency with the ability to slice-and-dice data,” he says.

Another operational improvement was made with no-show rates, Mullarkey notes. “If the physicians are there and the staff has done its job putting patients on schedules, how do you address no-shows? One would typically say to overbook patients by the no-show rate which is a fair strategy,” Mullarkey says. For example, if your no-show rate is 15 percent and you overbook by a 15 percent rate on every single provider but don’t pay attention to when you’re overbooking them, you will create havoc in the practice, he says.

“When we brought data into the EDW and created our views, we saw that one provider has a 20 percent no-show rate, while another has a 7 percent rate. So we were able to differentially overbook.  The organization was also able to see that no-show rates were greater at certain times of the day and certain days of the week, allowing the staff to target overbooking so they could predict where those no-show rates could be higher. As a result, there weren’t heavy volumes of patients coming in, and there were no patient experience issues where they ended up waiting for long periods,” Mullarkey says.

Mullarkey additionally notes that while these sorts of predictions were attempted before, it took data gurus and spreadsheet experts to export things out of their systems into raw data. Then they had to create graphs and manipulate the data in Excel. But in the EDW, with simple filters and clicks, those views are much more readily available, he says. “Do you want bar charts, trend graphs, standard deviation lines, different colors representing different things? Now everyone has use of those views, and administrative leaders are working with leaders above them and with physicians. They know they have a short period of time and attention, so the more effective you can present that data, and let the graph speak for itself, the better off you are. It allows more time to strategize,” Mullarkey says.

From a results standpoint, Mullarkey points to physician RVUs above all. “They were lagging below the 40th percentile compared to our benchmarks. We now have our practices all above the 55th percentile, over the median,” he says. He adds that the organization has also improved what it calls its “third-available appointment,” or its access to care measure. “We offer say day walk-in appointments, but if you’re not going through that process, we want to be able to get patients in within 14 days,” Mullarkey explains. He notes this is the usual approach across the industry because it adjusts for the possibility that patients will cancel an appointment on the same day that the inquiry is made. And if you had a one-month wait, that would show up as well. As such, there were a number of specialties that got that third-available appointment to within 14 days; 77 percent of practices can now do that, he says.

In addition to improving physician productivity, the EDW also helped Texas Children’s reduce patients’ length of stay. Care teams were brought together and began predicting when a patient would be discharged on the day of his or her admission. “By doing so, you can align all resources at home. We’re a children’s hospital, so finding out if parents are working, seeing if they can deliver for their child at home, and knowing if they have home health set up is very valuable,” Mullarkey says. As a result, severity-adjusted length of stay, which takes different variables into consideration, was reduced by 20 percent from its baseline, he notes. “About 20 months ago, we were turning away patients,” Mullarkey adds. Other hospitals that needed our expertise were calling us needed to transfer children, but we were so full had to turn away patients. We needed to fulfill our promise to the patients and the community; we needed to build access and create beds for the next child to come in.”

Mullarkey attests that the physicians themselves have been on board with these operational changes thanks to honest and frank discussions from the top. “They have not shied away from sharing with us where there are opportunities, and we have to address those things and be receptive. We approached this with a shared governance approach, having both administrative and clinical leaders on our teams. That transparency fostered much more frank conversations, and it also fostered competition that is natural, as one practice wants to do as well or better than the other,” he says. “Now, the data is right there in front of you. All you [have to do] is walk down the hallway to sit down with leaders and find out what’s working, and replicate best practices.”

Sponsored Recommendations

How Digital Co-Pilots for patients help navigate care journeys to lower costs, increase profits, and improve patient outcomes

Discover how digital care journey platforms act as 'co-pilots' for patients, improving outcomes and reducing costs, while boosting profitability and patient satisfaction in this...

5 Strategies to Enhance Population Health with the ACG System

Explore five key ACG System features designed to amplify your population health program. Learn how to apply insights for targeted, effective care, improve overall health outcomes...

A 4-step plan for denial prevention

Denial prevention is a top priority in today’s revenue cycle. It’s also one area where most organizations fall behind. The good news? The technology and tactics to prevent denials...

Healthcare Industry Predictions 2024 and Beyond

The next five years are all about mastering generative AI — is the healthcare industry ready?