I need to be able to upate the EIEID and the EIEDTTM from the document table in the Works DB. In our document interface coming in from the hospital and the documentID is the accession number in the table since the documentID in the document table is actually auto generated.
So, I would like to be able to remove a document from the chart viewer IF this document was cancelled in the upstream application. I can do this via SQL manually and the process works just fine. Is anyone able to help create something for me?
Ideally the script would work like this:
If MSH1.8 component 2 = T11 run script: update EIEDTTM and EIEID with the accession number provided in the actual HL7 message on PV1.19 component 2. If the accession number does not exist, block message. Is this possible?
IT Project Leader
Corporate and Physician Applications
West Penn Allegheny Health System