Admin/system generated logging help
I am trying to figure out how to set up a "system-generated" account log (system generated account activity such as when a user clicks a button that generates a document) for recording certain actions. For example when anyone adds any type of child records, edits a record, emails a specific invoice, changes the status of child records (ie changes the status of a record, authorizes and schedules a patient for something),
I want to have this type of activity documented separately from any data entry/notes that they enter directly. And even when they add a note directly, some type of table to keep track of all activity related to the parent record.
I would like this documented as "system admin" and not by the actual user since this is already in another place.
What is the best way to tackle something like this?
Would I want to create a new user - System Admin - and then create some type of pipeline to capture these changes as the admin?
Would use audit logs or similar work???
I have attached a screenshot of how our previos database did this for reference.
Thanks for any ideas
------------------------------
Kelly Lyons
------------------------------