My name is Ron Moses; welcome to Adventures in Centricity, a blog about my work with SQL and Crystal Reports in the GE CPS12 environment. I’ll probably throw in a bit of MEL here and there along with the occasional text file hack as well. I don’t expect this blog to be of much interest to SQL/Crystal users in general; I’m primarily targeting the Centricity tech who’s wearing multiple hats in addition to having to figure out how to create new reports and queries as the need arises. Maybe you know your way around Crystal pretty well, but haven’t considered what digging into the database might gain you. Maybe you’re a member of the support team who’d like to be more proactive in tracking down errors and customizing the application. If either of those come anywhere close to describing you, welcome to Adventures in Centricity.
I am a member of the Ambulatory EMR team for a private hospital in New England, incorporating several primary care practices along with Surgical and Cardiology departments. A big part of my job is creating reports for all levels of the organization, from upper management to EMR end-users. I’m also regularly involved in supporting the Centricity software. In the course of both parts of my job, I often need to find creative ways not only to generate data, but also to troubleshoot (and sometimes hack) the system itself. I have a lot of stories to tell, and the fun shows no signs of stopping soon. So I’ve decided to share as much of what I’ve learned with my fellow Centricity techs, and with data nerds in general. (I use that word both affectionately and self-referentially, by the way.)
I don’t care to call myself an expert, per se, but I have managed to pull off a few neat tricks. I hope that by posting them here, I will elicit one of two responses:
1. “Hey that’s pretty cool! I think I’ll try that!”
2. “You’re an idiot. You should have done it this way instead.”
I’m hoping to get more of the former than the latter, but I’ll take what I can get. (After all, I’d rather be told I did something stupid than continue to do it.) I hope you find something of use here, and please send me your feedback in the comments!