-603: Unable to identify QO Classification DE from alternate identifier

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Revision as of 20:15, 18 August 2010 by Justin.Campbell (talk | contribs) (Created page with '=Diagnosis= The value in AltQOClassificationIn may not be in the orderitem_identifier table in the Works database. =Base Stored Procedure= FileResult_CMS =Fix= Check the orde…')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Diagnosis

The value in AltQOClassificationIn may not be in the orderitem_identifier table in the Works database.

Base Stored Procedure

FileResult_CMS

Fix

Check the orderitem_identifier table in Touchworks. Does the AltQOClassificationIn code exist in that table (EntryCode or EntryMnemonic)? If so, what QOClassDE does it go to? Is the ReqPerfLocDE code value (look this up in requested_perf_location_de or whatever that table is called) for that AltQoClassificationIn code in the orderitem_identifier table equal to the reqperflocationin field sent in that fileresult call? The match on order code for the order identifiers section is on the altqoclassificationin and reqperflocationin, then it finds a corresponding QOClassDE which exists in the item master.

If the AltQOClassificationIn code does not exist in the orderitem_identifier, then it needs to added via the Order Admin page in TWAdmin.