Hi Alex,

 

I added a new entry in OID registry under AA. So based on OID the code will be populated in the Patient Number field. I have a written a Custom SQL code to pull just the code for our downstream systems. The issue that I have is there are existing data in the DB with the OID instead of Code in the Patient Numbers field and I am looking for a way to update them without reprocessing all the files.

 

Regards

Joseph

Thanks Steve. Looks like the example has what I needed. I will try it and come back here if I run in to something that I am unable to foresee.