Bill, It tracks date/timestamp, what the user name is, and whether a record was added or just looked at, changed, or deleted. It also tracks a date/timestamp for any patient correspondence.
My system also keeps a historical record of exams so that you can look at old address or different last names - but not detail of editing changes on a give record. The data auditing table has the potential to get pretty big, but with storage space being pretty inexpensive these days, it is not a big deal. Steve Vellella William Stacy wrote: > Steve Vellella wrote: > > > > > I have included a audit trail to record access to patient records, editing > > changes, additions, etc... > > How do you do that? I can imagine an audit table that records every access to > patient info by employee, but this table would grow immensely, no? And do you > keep track of what the data was before it was edited? So you could actually > look back, for example, and see every old phone number, address, etc. a patient > had? > > I'm not saying it's a bad idea; I'm just not sure how it should be implemented. > > bill
