Page 1 of 1

Inbound Demographics/Second Address line

PostPosted: Fri Apr 01, 2011 12:52 pm
by djohnson
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

Re: Inbound Demographics/Second Address line

PostPosted: Fri Apr 01, 2011 1:57 pm
by cwalloch
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.

Re: Inbound Demographics/Second Address line

PostPosted: Fri Apr 01, 2011 2:44 pm
by rlape
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

Re: Inbound Demographics/Second Address line

PostPosted: Fri Apr 01, 2011 11:26 pm
by djohnson
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. :)

Re: Inbound Demographics/Second Address line

PostPosted: Mon Apr 04, 2011 9:02 am
by jcampbell
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

Re: Inbound Demographics/Second Address line

PostPosted: Mon Apr 04, 2011 12:51 pm
by tsuacci
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

Re: Inbound Demographics/Second Address line

PostPosted: Tue Apr 05, 2011 12:12 pm
by djohnson
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.

Re: Inbound Demographics/Second Address line

PostPosted: Sat Apr 09, 2011 5:16 pm
by jcampbell
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