OpenEMR - Adding Time Stamp to Past Encounter List
The challenge was to change the current encounter list to include the time of the encounter.
This was an important feature to have for the behavioral health client. So we set out on the task to see what could be done to place the data here.
Tracing down the code that generated this display, we could see that this was a function of a SQL call to two tables. We needed to add a third table where the appointments are stored. Once getting the SQL call down to where it would extract and match up the data from all three tables. We were able to produce this.
However, there was a side effect of adding the time to the list of encounters. The list will only show past encounters that have a calendar appointment with it. If the encounter does not have a calendar appointment, it will not show. See image below.