Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Help with a SQL statement

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

4 Users

0 Reactions

70 Views

RSS

Hunter.Hines

(@hunter-hines)

Posts: 63

Estimable Member

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

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

Be glad to help you. Contact me at [email protected].

Posted : October 30, 2017 7:10 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

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

Hunter.Hines

(@hunter-hines)

Posts: 63

Estimable Member

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

SLHV

(@slhv)

Posts: 478

Honorable Member

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

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0