Introduction

For results transmission to Nova Vesalius HIS, the generated HL7 message contains the result’s a flag to indicate whether the result has been revalidated or not.

Script to Reset Revalidate Flag

UPDATE pmo_patient_specimens
   SET firsttransmitted=null, lasttransmitted=null
 WHERE 
sampleid = _sample_barcode_number_

_sample_barcode_number_ is the value from the sampleid column ofr the pmo_patient_specimens table.