Notifications
Clear all
Topic starter
Hey all, I'm needing a little help coming up with a SQL statement for an upcoming HL7 interface for NRC Picker (Patient Outreach) that pulls directly from our CPS DB. I'm currently sending them a flat file with most of the fields they're requesting that was built in Crystal Reports, but they're transitioning over to HL7 outbound so I have to re-invent the wheel inside QIE. They've sent a structure for the information that they're needing, but the fields reside in multiple different tables and I'm not too keen on SQL or joins, so I was hoping maybe someone here could help me out.
Currently, the flat file I send to them is on a weekly basis, and has a date criteria where I specify the time-frame to pull the data for patient appointments. However, this new interface is dropping HL7's on a daily basis for patients with an appointment during the current day with all of the fields list below.
Format:
Patient First
Patient Last
Primary Phone
MRN (PatientID)
DOB
Gender
Primary Language
Email
VisitType (Outpatient/AMB by default)
FacilityNum (FacilityID)
VisitNumber (Appointment ID)
Service Date
Location of Care
Attending Prov First
Attending Prov Last
Attending Prov NPI
If anyone here could help, I would be extremely thankful.
Posted : October 30, 2017 6:42 am
You said they want it in HL7, did they tell you the HL7 message type they wanted? All of those fields with the exception of maybe NPI would be in an outbound Scheduling interface in CPS. Are you taking the outbound HL7 interface into qie and then creating a flat file with it that you are sending, or will the file be HL7?
If you would like someones help to set it up for you I have extensive experience in interfaces in LinkLogic, QIE and Mirth. If you want to do it yourself, just let me know what questions you have.
Posted : October 30, 2017 9:21 am
Topic starter
The flat file is generated from a Crystal Report that was built using the built in Database Expert to include the fields that they requested. Currently I'm exporting from CPS via a Demographics to a network share, then pulling those HL7's into QIE and transforming them there and exporting them to another network share for testing. I'm not familiar with the outbound Appointments interface from CPS..as far as I'm aware, it's only available via inbound ACP.
Their specifications include ADT-A03 (discharge) and ADT-A08 (updated demo) messages.
Posted : October 30, 2017 9:38 am
I agree with rwilliams. I was thinking the ADT A04 message might trigger at the right time with the right data. It triggers on patient registration. It looks like an SCH may work as well.
I am looking at one of my ADT A04 messages. I don't see the NPI, in the message but it would be easy to add it to the HL7. Glancing at it it looks like all the rest is in the ADT A04.
As far as interface engine, I suggest Mirth. We use it all the time. It is generally more cost-effective than QIE. There is quite a learning curve with either of them IMHO.
-dp
Posted : October 30, 2017 9:51 am
I don't think a Demographics outbound interface will do the trick. It sounds like you want the information to be sent after the patient arrives for a visit. According to the CPS interface documentation, demographics are only exported when a patient is registered (created) or updated, not when they arrived/discharged.
I believe what you need is an outbound Appointments interface. Linklogic does not have one outbound because appointments are handled by PM. Instead what you need is an interface configued in MIK as a Scheduling interface (SIU). You can take data from this outbound SIU message and make changes to it and turn it into an ADT message then pass it along. Like I said previously, you would likely have all of the information you requested above, with the exception of NPI. You could either build a table that you maintain within QIE or you could query the CPS database for that information.
Posted : October 30, 2017 12:33 pm
