Johnathon

Wright

I am successfully retrieving HL7 messages, including data and embedded PDF, via Ruby. I wish I had kept better notes... so I'm doing that now. My current challenge is to send an ACK message. I can tell that the people at Quest were very satisfied with their recent guidance to me, which I can fairly summarize as: Oh, you were using our...

For my current project, I need to show MapQuest maps next to an address form. As the user enters an address, I need the map to attempt to show the address. Note: When testing, I often use console.log... so if you don't have developer tools installed, some of these won't work for you. Step One: Basic Gist ----------------------- Using...

My client has asked me to automate the monthly generation of reports from AllScripts/Misys Tiger. I have a list of reports that must be generated: * Daily Recap - for a given month, show one row for every day ** Day of Month ** Charges ** Misc Charges ** Charge Adjustments ** Insurance Write-Offs ** Net Charges = charges + misc_charges -...

h2. Preface: nil for those of you who don't know, nil is like NULL, but way cooler. But if you don't know, just pretend it means NULL, but if you ask whether NULL is true or false, it will say, "Oh, yeah, I'm false." Yes, I know, if you haven't heard of nil this makes you think I'm on crack. Roll with me. h2. Returning a value or "Sorry,...

This page documents the process of creating an HL7 interface between my client's "micro-EMR" and a medical laboratory named "BioReference":bioreference.com BioReference presented me with two interface options: * install software on my windows machine. Their software would dump files into a directory of my choosing. * SFTP Since our...

h2. Inconsistent use of HL7 Value Types Trying to increase quality control, I set told my import agent not to flag any observations where the value type wasn't what my app would have selected as the value type. The results were surprising. |Field|Quest's Value Type|Quest's Value|LabCorp Value Type|LabCorp...

In addition to storing data about a patient's current visit, my clients want to store a patient history. Thus, I need to store fields like: - history of breast cancer? y/n - history of lung cancer? y/n - history of x cancer? y/n and then: - if yes, any evidence of cancer in the last 5 years? What medicines are you taking? Have you been...

"select sum(NOI_AMOUNT) FROM NOI WHERE NOI_ALLOC_DATE = { d '2012-12-05' };" ~ instant select NOI_TRN_NUMBER, sum(NOI_AMOUNT) FROM NOI WHERE NOI_ALLOC_DATE = { d '2012-12-05' } GROUP BY NOI.NOI_TRN_NUMBER; ~ instant select TRAN_TYPES.TRN_NAME, NOI_TRN_NUMBER, sum(NOI_AMOUNT) FROM NOI, TRAN_TYPES WHERE NOI_ALLOC_DATE = { d '2012-12-05' } AND...