Good afternoon, I'm wondering if anyone knows of a way to search the referring doctor's table in a form. I have a form with a field for "Patient Referred to the following physician" and our doctor's would like to be able to search the doctor's table for the physician's name, just as they do in the Registration Module when staff search for the Referring and Primary physicians by clicking on the binoculars. Is there a way, using VFE, to do this? Thanks in advance for any assistance.
Pat Apanasewicz
GI Associates, LLC
You can always use the PATIENT.REFMD... or PATIENT.PCP symbols if you want only the one name.
You can pull in all the patient's contacts using REGPROVIDER (although you always have to click on the Reg button to refresh the patient's context first). We had something similar developed with Lee Cooper because that's so clunky.
We run an scheduled task SQL statement every 10 minutes that pulls all the doctors right out of the PERSON table. It saves the list into a local text file on each Citrix server, from where the encounter form pulls in the docs. Then the form saves the individual patient's values to a flowsheet for quicker use at the next visit.
Jim Eppright
Thanks for your ideas, Jim! That may actually work for me. I was looking for it to search the entire table but chances are our doctor would be looking to put that individual patient's referring physician into the edit field anyhow. Thank you for your response! I really appreciate it.
Pat