Notifications
Clear all
Topic starter
Hello,
We're looking to mass move data from one field to another in the "Referring Provider" setup area - the fields being "Organization" to "Email" as we want the referring providers organization to appear in the patient banner and there seems to be no data symbol for org. but there is one for email.
I tried searching through the database to find the table in which this data was stored but nothing turned up. If someone could point me in the right direction on getting this data moved to a different field or assist me in this process it would be much appreciated
We're using CPS if helps any.
Posted : July 10, 2018 5:32 am
SELECT OrgName,EmailAddress,* FROM DoctorFacility WHERE TYPE = 3
Posted : July 10, 2018 5:53 am
Topic starter
Thank you very much for this! I was able to update the table to copy everything from org>e-mail.
Posted : July 10, 2018 6:49 am
An alternative approach would be to use the OBS term REFAGENCYNME to record the referring organization name for the patient and then display that in the banner with OBSANY("REFAGENCYNME"). This would keep you from having to use a workaround if you ever did need to legitimately record the email address of your referring physicians.
Posted : July 10, 2018 7:54 am
Topic starter
How does one go about mapping OBSterms? I'm a bit new to this side of CPS.
Thank you for the alternate route - I'm sure it will eventually come up that we need the email field cleared out for actual emails.
Posted : July 10, 2018 8:27 am
One of the downsides to OBS terms is that they are not exposed to folks doing patient registration on the PM side, so it is likely you would need to get the nurse or physician to identify the referring organization when the patient is seen for the first time and enter the info on a custom form. You could also create a flowsheet with that OBS term and have staff enter it manually once the patient has been registered on the PM side.
Screenshot of a flowsheet to capture patient registration data:
Either way, once the data had been entered for the patient, it would display in your custom banner from that point forward until a new value was entered. You would customize the banner with a string similar to what I have below:
Referring Org: {if OBSANY("REFAGENCYNME") = "" then "Unknown" else OBSANY("REFAGENCYNME") endif}
It would display like this:
Posted : July 10, 2018 8:54 am
Topic starter
This makes more sense now. I was under the impression that there was another way to manipulating the OBS to be picked up.
This can be something to consider for newer form dev.
Thank you very much for your input, especially the flow sheet workaround.
Posted : July 10, 2018 9:02 am
