Hello,
Does anyone have suggestions on pulling last office visit date on a note that will be created at a later date. I am having difficulty capturing the office visit date only due to phone notes and clinical list updates being created after the office visit note has been signed.
Any suggestions greatly appreciated!
So, do I understand:
1/1/2019, office visit (signed)
1/8/2019, lab(s)
3/4/2019, phone
4/1/2019, clinical update
==> 8/1/2019, office visit ** show the 1/1/2019 date onto a form
Yes, that is correct.
We use LAST_SIGNED_OBS_DATE("CHIEF CMPLNT") as the basic idea of the last office visit. Our expectation is that staff will always complete the chief complaint regardless of what other data points they complete during the office visit. Also, chief complaint does not exist anywhere else in any other type of visit. Occasionally we run into an issue where the staff does not complete the chief complaint but that is very rare. I would suggest looking at your office visit and finding a value that is both completed at every office visit and also only in office visits. You should be able to pull your date from that. If you don't have a data point like that as an option you could always add one into a page close handler for a form and his it populated that way.
Brad
We use "BP SYSTOLIC" as a surrogate for office visit, under the assumption that the BP is taken at every office visit encounter. If you use this OBS, you could pull LAST_SIGNED_OBS_DATE. If you do not use "BP SYSTOLIC", perhaps you would consider modifying the form used so that an OBS code is updated at every office visit.
Thank you all for the feedback!