We are working on a plugin that syncs some of the Open Dental tables with another system. One of the pieces of data that we were hoping to capture was when a record on any of these tables is updated by an OD user, who made that change and when?
I can see that many tables have a column for SecDateTEdit which appears to be updated per edit, however the usernum of the editing user is not tracked. Is there another way to achieve this?
Thanks
How do I detect what user made a change on a given record?
-
- Posts: 64
- Joined: Thu Aug 20, 2015 11:08 am
Re: How do I detect what user made a change on a given recor
Tough to say. Would have a better idea if we had a list of the tables you need.
Re: How do I detect what user made a change on a given recor
I guess in a way that answers my question, as we were hoping to find same common logging convention that tables followed. If the data does exist, but is somewhat custom per table or genre of table, than it probably will not work the way we were hoping. Some of the tables i know we will be grabbing:
carriers
claim (and many of the other claim tables)
patient (and many of the other patient tables)
procedure tables
treatplan
carriers
claim (and many of the other claim tables)
patient (and many of the other patient tables)
procedure tables
treatplan
-
- Posts: 64
- Joined: Thu Aug 20, 2015 11:08 am
Re: How do I detect what user made a change on a given recor
Hmm if I understand your best bet would be to reference the securitylog table. But I don't think it will be bullet proofs.
Re: How do I detect what user made a change on a given recor
It looks like you're right. While it does appear to contain the information we want, its not in a format we can use in the way we intended. Thanks for getting back to me though.