Inbound Demographics/Second Address line

Inbound Demographics/Second Address line

Postby djohnson » Fri Apr 01, 2011 12:52 pm

Hello All,
I am hoping to get some feedback on an issue we are expieriencing.

in our ADT message our Practice Management System (Vision) is sending " in the line2 for the address, which populates the charactures " in the address of secondary systems.

PID|1|PatientNumber|MRN|124686^^^^XC~LPMR^^^^XH|Lname^FName^JR||MRN|M|PCP CADE||PO BOX 534^""^LA PINE^OR^97739||(541)536-1861|""||M|||phone-number

I have tried numerous ways to block it but let secondary address come through (example: apartment number) with no luck

Any Help would be apprediated

Debbie Johnson
Bend Memorial Clinic
Debbie Johnson
Bend Memorial Clinic
Application/Interface Analyst
541-317-4590
djohnson@bmctotalcare.com
djohnson
 
Posts: 29
Joined: Wed Mar 30, 2011 1:57 pm

Re: Inbound Demographics/Second Address line

Postby cwalloch » Fri Apr 01, 2011 1:57 pm

I dont know Vision PM, but I do know that when you are sending a null (Empty Field) value in HL7 it be will transmitted as two double quote marks ("").

Sorry I couldn't provide more info, maybe someone else will chime in.
cwalloch
 
Posts: 1
Joined: Wed Mar 30, 2011 2:24 pm
Location: SO_Cal

Re: Inbound Demographics/Second Address line

Postby rlape » Fri Apr 01, 2011 2:44 pm

Could you use a substitution on Address Line 2 where you substitute " with a blank so that if these characters are sent they will be stripped out of the procedure call. You risk a valid quotation being removed, but I'm not sure that you would ever expect to see a valid double quotation in an address. I haven't tried this specific instance, but I think I've had other cases that I've done something similar.

substitution.JPG
You do not have the required permissions to view the files attached to this post.
Ray Lape | Senior Consultant
Galen Healthcare Solutions
ray.lape@galenhealthcare.com
rlape
 
Posts: 40
Joined: Wed Mar 30, 2011 12:34 pm
Location: Burlington, KY

Re: Inbound Demographics/Second Address line

Postby djohnson » Fri Apr 01, 2011 11:26 pm

When I put in the subsititution as Ray suggested:

The Substitution from PID.1-[11]-Patient Address.1.2.0, of characters '"' with characters ''

I still got the double quotes
|||1234 NW HALO WAY^""^BEND^OR^
Unless I am overlooking something in the subsititution?

When I acutally filled in the second line with an apartment number:
1234 NW HALO WAY^APARTMENT 3^BEND
it works fine.

I have even tried blocking the segment equals ""

I am liking this new forum already, and looking forward to more feedback with this issue. :)
Debbie Johnson
Bend Memorial Clinic
Application/Interface Analyst
541-317-4590
djohnson@bmctotalcare.com
djohnson
 
Posts: 29
Joined: Wed Mar 30, 2011 1:57 pm

Re: Inbound Demographics/Second Address line

Postby jcampbell » Mon Apr 04, 2011 9:02 am

Debbie,

Can you post an example of the corresponding FilePatient_CMS call? Preferably both with and without the substitution. One additional means of mitigation may be to run a pre-proc CxR VBScript to globally substitute "".

-Justin
Justin Campbell | Director of Integrations
office 1.617.379.0841
cell 1.802.363.5654
fax 1.801.409.3982
http://www.galenhealthcare.com | 888.GALEN.44

Visit http://www.galenhealthcare.com/calendar/
for a list of Galen's upcoming FREE webcasts.
jcampbell
 
Posts: 34
Joined: Wed Mar 16, 2011 6:45 am
Location: Boston, MA

Re: Inbound Demographics/Second Address line

Postby tsuacci » Mon Apr 04, 2011 12:51 pm

There may be an option in the interface setup within the PM System that allows you to remove double quotes in the HL7 messages that it generates.

Tyler
Tyler Suacci
Consultant
Galen Healthcare Solutions
707.335.4710
tyler.suacci@galenhealthcare.com
tsuacci
 
Posts: 55
Joined: Mon Apr 04, 2011 12:08 pm

Re: Inbound Demographics/Second Address line

Postby djohnson » Tue Apr 05, 2011 12:12 pm

here is the subistution

FilePatient_CMS (1120,'31150707','','250237',3,'P357664','EMRTEST','SPATIENT','','','','','','','','','','','','14 BABY BEAR DRIVE','','CULVER','OR','97734','','','','','20050901','542-25-4561','F','M','',0,0,0,'',0,0,0,'0','',0,0,0,'','','C','',0,'','','','',3,0,0,0,'','','','','','N','N','','','','','Y','N',0,'N','N',0,'N','N','N','N','N','N',0,0,'','','C','',0,'',0,'','',0,'',0,'','','','',0,0,0,'',0,0,0,'','','','','E',0,'',NULL,NULL,'',0,0,0,0,'300930','BMCTST^OTHER','','Y','','','4','Y','AP1','','','','',NULL,'EMRTEST','SPATIENT','1','C',0,0,0,'',0,0,0,'','','14 BABY BEAR DRIVE','CULVER, OR 97734','G','(842)654-8211','(842)564-2188','','','','(842)654-8211','(842)564-2188','GT1||^MISYS||||||||||||||||~IN1||INS|||||||||||||||||||||||^MISYS~IN2|||||||||~PV1|BMC','','I','','','','','','','','','',0,'','','','','','P','','N','')

Here is my blocking logic (let me know if I have the wrong logic)
Block Segment If PID.1-[11]-Patient Address.1.2.0 equals '', Or'd with PID.1-[11]-Patient Address.1.2.0

and the call:
FilePatient_CMS (1120,'31150813','','250240',3,'P357675','EMRTEST','YPATIENT','','','','','','','','','','','','678 SOUTH LAKE DRIVE','','CULVER','OR','97734','','','','','19890309','444-44-4444','M','M','',0,0,0,'',0,0,0,'0','',0,0,0,'','','C','',0,'','','','',6,0,0,0,'','','','','','N','N','','','','','Y','N',0,'N','N',0,'N','N','N','N','N','N',0,0,'','','C','',0,'',0,'','',0,'',0,'','','','',0,0,0,'',0,0,0,'','','','','E',0,'',NULL,NULL,'',0,0,0,0,'300942','BMCTST^OTHER','','Y','','','4','Y','AP1','','','','',NULL,'EMRTEST','YPATIENT','1','C',0,0,0,'',0,0,0,'','','678 SOUTH LAKE DRIVE','CULVER, OR 97734','G','(541)546-6821','(999)999-9999','','','','(541)546-6821','(999)999-9999','GT1||^MISYS||||||||||||||||~IN1||INS|||||||||||||||||||||||^MISYS~IN2|||||||||~PV1|BMC','','I','','','','','','','','','',0,'','','','','','P','','N','')


We have talked to the vendor at length about this with no resolution. my hope is we can come up with somthing in the ConnectR side.
Debbie Johnson
Bend Memorial Clinic
Application/Interface Analyst
541-317-4590
djohnson@bmctotalcare.com
djohnson
 
Posts: 29
Joined: Wed Mar 30, 2011 1:57 pm

Re: Inbound Demographics/Second Address line

Postby jcampbell » Sat Apr 09, 2011 5:16 pm

Debbie,

Please reference the following Galen Wiki article which outlines a method to suppress the consecutive double quotes via deployment of a CxR pre-processing script: http://wiki.galenhealthcare.com/Q:_The_PM_system_is_sending_%22%22_in_line2_for_the_address,_which_causes_error_when_trying_to_file_data_to_the_address_field_of_secondary_systems._How_can_the_double_quotes_be_suppressed%3F.

The issue is due to the fact that in Misys registration and appointment interface, Misys will send "" in fields to designate that a value used to reside there but has now been deleted.

For more information on pre-processing scripts, reference the following wiki article: http://wiki.galenhealthcare.com/ConnectR_Pre_Proc_Script

Thanks!
Justin
Justin Campbell | Director of Integrations
office 1.617.379.0841
cell 1.802.363.5654
fax 1.801.409.3982
http://www.galenhealthcare.com | 888.GALEN.44

Visit http://www.galenhealthcare.com/calendar/
for a list of Galen's upcoming FREE webcasts.
jcampbell
 
Posts: 34
Joined: Wed Mar 16, 2011 6:45 am
Location: Boston, MA


Return to Inbound ADT

Who is online

Users browsing this forum: No registered users and 1 guest

cron