Item Dictionary Synchronization

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Jump to navigation Jump to search


The Item Dictionary Sync Interface allows for the addition of a new item from a vendor to be added to the Item Dictionary if it does not already exist. This is helpful if a vendor has new item which requires addition to the dictionary in that it facilitates automatic update, alleviating the tedious manual update.



  • This makes sense for groups who can't/don't focus on ConnectR errors as it ensures patients' interfaced results make it to the EHR


  • OID Build: During the Build of the OID. The IC/Client begin with both the Utilization and Compendium from the Vendor or in many cases these days Vendor (s). The Utilization allows the client to see all the test ordered in the last year and how many times. From this, the client is deciding, not so much on what they “expect” will be ordered, but also..the exact test they want to allow the users to order. This is often based on Insurance, Lab Vendor Practices or preferring to order one Lab from one vendor over another vendor. Auto-Filer completely takes this control away from the client during the build and after Go-Live as even though the wrong Order has been placed an resulted…it is more difficult to monitor when they are auto-filing in.
  • OID descriptions: Auto-file descriptions are often times just codes that appear in the patients chart with no description of the exact order until the admin staff enters the proper information in the corresponding dictionary
  • OID data fields: During the build of the OID there are numerous other fields that must be considered and built…often built with an “Apply Below” function of SSMT so that all items in a particular class…say Chemistry have the same behavior for say, RPL, When to Charge, Specimen sources, etc. Once these have been loaded and a new order is auto-filed in…it will not be in this class and will not be a part of these needed defaults.

Best-Practice Approach

  • Train staff to monitor ConnectR at least 2 times a day (or via autonotification) to work any result errors
  • Have vendor call-in critical results


  • The Item Dictionary Sync utilizes the ACS_ImpSetOrderResulWSync stored procedure which will need to be installed to the AE-EHR Works database.
  • Creation of an additional interface is required and as such a separate dictionary target should be created. Make sure to give the target a descriptive name – "Test LabCorp Dictionary Target" for instance.
  • An interface mapping will need to be created between the Result Source (ORU message) and the Dictionary Target (ACS_ImpSetOrderResultWSync). The interface mapping can either be created from scratch or imported in (after exporting from the Allscripts ConnectR Interface library).
  • The interface mapping facilitates the addition of the new item with a parent classification specified in the mapping as shown below:

ACS ImpSetOrderResultWsync2.gif

  • The item classification will need to be added to the Item Dictionary via TWAdmin as shown below:

ACS ImpSetOrderResultWsync.gif

  • The original Results interface target should lag behind the new Dictionary target. This way, new items will be added to the dictionary before the result is filed.

ACS ImpSetOrderResultWsync3.gif

  • !!!!GOTCHA!!!! It is important to take into consideration any prefixing or suffixing of Orderable and Resultable codes to uniquely identify them. For instance, a Orderable and Resultable code may be prefixed with an 'L' for LabCorp. As such, the interface mapping should concatenate prefixes or suffixes as appropriate in the QC_Entrymnemonic, QC_EntryCode, QODE_EntryMnemonic, and QODE_EntryCode fields:

ACS ImpSetOrderResultWsync4.gif

ACS_ImpSetOrderResultWSync Message Description and Data Types

1.	QC_Entrymnemonic 	 c255 		Orderable Entry Mnemonic 
2.	QC_EntryCode 		 c255		Order Code 
3.	QC_Entryname 		 c255		Item Master Entry Name 
4.	QODE_Entrymnemonic 	 c255		Result Mnemonic 
5.	QODE_EntryCode		 c255		Result Code 
6.	QODE_EntryName		 c255		Result Name 
7.	AnswerType 		 c255 		Result Answer Data Type
8.	QC_ParentName 		 c255		Order Class Category ie. MRI, Lab etc. 
9.	CharInAnswer		 c255
10.	DecimalInAnswer          c255 
11.	SetOrder 		 c255
12.	V4OrderingAuthority 	 c255		Ordering Auth
13.	OrderAlwaysDisplayDetail c255 		Always display order detail when ordering
14.	CommMethDE 		 c255 		2 for interface 3 for Manual 
15.	OnHoldFlag 		 c255		On hold pending activation flag 
16.	CPT4CodeMN 		 c255		CPT code for MN checking 
17.	SpecimenLabel 		 c255 		0 for none, otherwise specify the id for specimen label entry
18.	IsSynched 	         c255 		'N' --Y or N set to Y if the result interface is using the AltQoClass mapping, otherwise set to N 
19.	PerfLocName 		 c255		Performing Location of Vendor being filed 
20.	TestFlag 		 c255
21.	Status 			 c255

ACS_ImpSetOrderResultWSync Interface Mapping Example

   (If OBR.1-[11]-Verified by.1.1.0 = 'G' Then (OBR.1-[29]-Parent Number.1.1.0 _ 'L')) | (OBR.1-[4]-Universal Service ID.1.1.0 _ 'L')
   (If OBR.1-[11]-Verified by.1.1.0 = 'G' Then (OBR.1-[29]-Parent Number.1.1.0 _ 'L')) | (OBR.1-[4]-Universal Service ID.1.1.0 _ 'L')
   (If OBR.1-[11]-Verified by.1.1.0 = 'G' Then OBR.1-[29]-Parent Number.1.2.0) | OBR.1-[4]-Universal Service ID.1.2.0
   OBX.1-[3]-Observation Identifier.1.1.0 _ 'L'
   OBX.1-[3]-Observation Identifier.1.1.0 _ 'L'
   OBX.1-[3]-Observation Identifier.1.2.0

SQL Stored Procedures

These are provided as-is with no warranty whatsoever. Please review the SQL code enclosed and have a certified SQL Server DBA apply the appropriate procedure to your Works database.