bradymiller wrote on Wednesday, June 30, 2010:
hey,
I’ve noted two recent projects getting reviewed, Disclosures and Med Reconciling, which place their information into the openemr log table. Does this make sense (and still fulfill MU) if this log gets effectively removed from the database daily (via the log archive script)?
-brady
visolveemr wrote on Wednesday, June 30, 2010:
Hi Brady,
We did discuss this in our last openemr MUO project meeting. For disclosures, we are planning to come up with a new log table. We can have this table generalized so that the log information which needs to be existed for longer time can be stored in this “extended_log” table with differnet “event” name.
Do share your views.
Thanks
ViCarePlus team
bradymiller wrote on Thursday, July 01, 2010:
hey,
sounds good,
brady
visolveemr wrote on Friday, July 02, 2010:
Hi team,
We are planning to come up with the generalized “extended_log” table which can be used to store informations like “disclosures” and other items which need to be maintained for longer time irrespective of the log archival, removal or deletion.
Here goes the “extended_log” table description:-
id - Identifier for the log - autoincrement value
date & time - Date and time the event happened
event - Event name (“Disclosures” for recording disclosures)
user- Provider who performs the current task
description - Details about the task (what info is disclosed)
notes - Other notes
patient_id - Identifier of the Patient who involved in this operation
status - Status of the event (success=1; Failure=0)
Do share your views here.
Thanks
ViCarePlus Team
bradymiller wrote on Friday, July 02, 2010:
Rod,
What are you thoughts on this. Is there another mechanism already in openemr to do this (such as notes or pnotes); I remember you making some mechanism to allow flexible mapping of some sort of notes. The medication reconciliation code in the code review tracker also needs a better mechanism than the current transient log.
If no general mechanism exist, then would it be better to just consider making tables specific for disclosures and medication reconciliations? I don’t know, just asking.
-brady