Hello friends! Wow, it has been way too long since my last post. Things have been absurdly busy, as I’m guessing they have for you. I’d like to be more active on this blog in 2017, so let’s start now!
I get a lot of requests to pull data pertaining to CMS measures, especially for purposes of tracking our progress against CQR. That system is not the least bit user-friendly, so it’s nice to be able to bring up a report that shows how we’re doing organization-wide on a given measure. Continue reading
“Hey, can you send me Dr. Darvin’s panel for a mailing list I’m putting together? Name, DOB, Address? Thanks.”
Seems like a simple request. And since you’re confident you know exactly what they’re asking for, you proceed on your merry way. Oh, woe is you… Continue reading
Somebody sends you an Excel spreadsheet with a bunch of OBS terms on it. Could be patient PIds, could be anything – it’s a big list. You want to use that list in a query, and there could be dozens or hundreds of them. Options are to set up a data connection to the spreadsheet, or paste the list into your query and start adding single quotes and commas. Or, you can copy this little bit of code and put it in your tricks file: Continue reading
I attended the Intermediate PM Reports class in Boston this week, and met some great people (learned a lot, too!). Everyone came with their own list of problems they wanted to solve. One of my classmates wanted to identify duplicate SSNs in the patient data. While she left with a working solution, I think we could take it one more step and learn a bit more about SQL in the process. Continue reading
As ICD-10 approaches, I’ve been getting quite a few requests for the top 100 diagnoses for a facility, or a group of facilities. Judging from what I’ve seen (and responded to) on CHUG, it looks like a few of you have been receiving the same request. It’s easy-peasy! Continue reading
Our practice managers wanted to be able to track the time from when a patient was checked in, to when they were roomed, to when they were seen by the provider, to when they were checked out. We spent some time researching how this could be done, and were not able to come up with a reliable way to identify rooming or when the doctor walked in.
We considered using the time vitals were taken as “roomed,” but the managers (who know their staff’s workflows far better than I) didn’t feel that would be accurate enough. And none of our providers start documenting as soon as they walk in the room, so we decided we had to abandon those two measures for now. But we can definitely track check-in to check-out. Continue reading
No-shows and late cancels are a significant cause of revenue loss for a practice. There’s little we can do from a reporting perspective to prevent these events, but today we’ll look at a report that at least allows the practices to track them.
There are plenty of tools out there you can use to compare two versions of a database. Perhaps you use one all the time (tell me about it in the comments if you like!), or perhaps you find yourself wondering what exactly has changed after each upgrade. If you fall into the latter camp, I have just the script for you.
Continued from part one. Okay, the grueling part is over. Time to have some fun.