Three Ways IT Can Fix Data Quality, Even if Business Users Won't

Loraine Lawson
Slide Show

10 Critical Myths and Realities of Master Data Management

Prevalent myths surrounding MDM alongside an explanation of the realities.

This week, I had what-oddly enough-turned out to be a major disagreement with a friend in health care. I wanted to know why I had to copy my insurance information onto a form when they were then going to turn around and copy the card.


"Well, we do that so we can verify the information," she said.


"How does that verify the information?" I asked.


"We check what you wrote against what's on the card," she said.


"But that would just verify whether I copied it correctly. Or memorized from the card correctly. I think this form just hasn't been redesigned since the invention of copiers. I mean, really-do people sometimes write down a completely different insurance on the form and then give you a card that says differently and you're like, 'Aha! You said you have Anthem, but you actually have Humana?' What's the point? Wouldn't you trust the card over their memory anyway?"


I was told I didn't understand because I'm not in health care, but she is in health care and, trust her, the form matters.


She's right-I don't understand. And among the things I don't understand is how this duplication of effort is a legitimate health care issue OR a legitimate effort to control data quality. From where I stand, it looks like yet <em>another</em> example of the health care industry's antiquated and error-prone approach to (mis)handling data.


It's not as if I would know if my insurance card is wrong, since the card is the source of my information. Oh, sure, if I'm smart, I double-checked the information on the card against my policy letters. But, I'm guessing most people don't do that, so basically, most of us are relying on that card to be right. If we've memorized our insurance information, we used the card to do so.


Therefore, asking me to copy that information-or write it down from memory-just invites errors into the data. Oh sure, if I don't have the card, you've got to ask me to write it down, but otherwise, why bother? An even more ridiculous, but increasingly common scenario: They ask you to fill out your insurance information on a form and then scan your card directly into a computer.


But, honestly, for all my ranting about IT/business alignment, I can see why IT gives up. If a health care employee can't understand why using a copy of the card is a more reliable source than a handwritten form ... well, why bother?


Here's a good reason why somebody needs to bother: $314 billion. That's how much middleware expert Hollis Tibbetts of Artemis Ventures estimates fraud or inaccurate billing costs the U.S. health care industry each year.


I'll grant you, he arrives at that number through some mathematical gymnastics using the U.S. GDP and a remark by the U.S. Attorney General's office that 14 percent of health care dollars are wasted in fraud or inaccurate billing. The figure gets worse if you add in other ways data problems can raise the cost of health care.


Tibbetts believes IT must lead the way on improving data quality before it pollutes business processes:

But if IT doesn't deal with the bad data problem, then the cost gets pushed downstream to the 'business,' where the business costs are geometrically higher. The model is not that different from that of 'healthy software,' where it costs $1 to uncover a defect during developer/unit testing, but $100 to fix that defect if the software is released to the end-users.

He outlines three best practices for improving data quality within IT:

  1. When you integrate data, fix data quality during the integration.
  2. When you migrate data, fix data quality as part of the migration.
  3. When you integrate data or migrate data, use a data profiling tool and deduplicate the data.


This isn't just a health care integration issue, of course. Lots of organization would do well to introduce data quality into these three key processes.


I appreciate that Tibbetts specifically mentions deduplication, because I've often wondered why deduplication isn't discussed more often as a way to improve data quality during integration. I've been told most data integration platforms wrap up deduplication as part of the integration process, but if you're a hand-coding shop, check to make sure it's being incorporated into the process.


And while we're on the topic of deduplicating, if you're in health care IT, would you do me a solid? Introduce your business users to a card scanner and "deduplicate" those outdated forms, because what is this, the 70's?

Add Comment      Leave a comment on this blog post
Sep 26, 2011 9:18 AM Larisa Bedgood Larisa Bedgood  says:

Loraine - My thoughts exactly!  I have often wondered WHY I am filling everything in on the form when they make a copy of my insurance card.  Most of the time, I just write in "see copy on file". 

All that aside, improving healthcare data quality is paramount as the healthcare industry continues to transition from paper to electronic health records.  Poor data quality increases healthcare costs, can affect patient safety, and inhibits health information exchange. Great point as well about deduplication. 

Sep 26, 2011 11:32 AM Karen Lopez Karen Lopez  says:


My local medical lab REFUSES to accept lab requests that have my health card and personal data Pre-printed on it.  I have to hand write the same information next to it. It's crazy. My doctor generated the lab request, printed it out and handed it to me. And I still have to give them my health card which has all that great data on the mag stripe. 

I wonder if they have a vested interest in data quality errors, perhaps getting to charge the government or th doctor a data entry fee or something.

The next improvement for lab requests would be for the doctor to send it electronically to the lab.  But my guess is these idiots would still hand me the filthy clipboard and pen (I have to use their pen) to fill out the info again. Somewhere, someone is making money pushing these poor data quality practices. We just need to find him and stick him in an emergency centre waiting room. That should keep him occupied for a few months.

Sep 27, 2011 2:17 AM Susan Hall Susan Hall  says:

When registering for a medical test, I've seen them print out the form, have me fill it out by hand, then scan it into the computer! ???

Oct 30, 2011 1:32 AM Dan Myers Dan Myers  says:

Where can I get the article quoted above by Hollis Tibbetts?


Oct 30, 2011 9:29 AM Loraine Lawson Loraine Lawson  says: in response to Dan Myers



Post a comment





(Maximum characters: 1200). You have 1200 characters left.



Subscribe to our Newsletters

Sign up now and get the best business technology insights direct to your inbox.