Comm Log Audit Trail?

[Rickliftig]

Just had an interesting situation where my front desk changed a comm log entry by accident to a future date. Is that entry a part of the audit trail? I was just thinking for legal purposes, since a conversation may be recorded or summarized in the comm log if that was the case?

Rick

[jsalmon]

In a roundabout way it is part of the audit trail. It will show up as a CommlogEdit item. The part that is lacking is that you won't know exactly what changed, just the fact that it was edited by someone on a specific date. The only way I could see to know what changed would be to load up a backup before the commlog was edited. I'm fairly certain our audit trail is going to be getting an overhaul one of these days which will better document the specifics of changes made.

[Rickliftig]

Thanks Jason.

Rick

[irfan]

That would be awesome if the audit trail kept track of the actual changes. Its kind of useless as it is other than seeing that a user made some sort of change, but we cant use it to see who actually did what

[edwardkellydds]

I switched to OpenDent some years ago, from MOGO. I did have a problem with an employee embezzling insurance checks. She would go back far enough in a patient's account and make the changes.

These changes were all documented in the MOGO software. When we discovered the fraud, she was nailed, and was prosecuted.

Does Opendent keep a log of such changes.??

Thanks
E Kelly dds

[KevinRossen]

I switched to OpenDent some years ago, from MOGO. I did have a problem with an employee embezzling insurance checks. She would go back far enough in a patient's account and make the changes.

These changes were all documented in the MOGO software. When we discovered the fraud, she was nailed, and was prosecuted.

Does Opendent keep a log of such changes.??

Thanks
E Kelly dds

Yes, I believe it does track what you're looking for. I just tested a query that will search for deleted completed procedures or deleted payments. This is not a catch all for embezzlement, but it is a start. Here's what I came up with:

Code: Select all

SELECT * FROM securitylog
WHERE (PermType=10 AND LogText LIKE '%Deleted') OR PermType=16
ORDER BY LogDateTime DESC;

[MKM]

Open Dental's Audit Trail is sadly lacking. I have been asking for this change for a while now. I understand it is a big deal to overhaul the audit trail, but it is a critical function for our businesses and it is almost useless as it is now. Hoping we see a new Audit Trail Soon!