Version 21.0
Path: Admin tab > Audit Trail button
What Do These Audit Trail Codes Mean?
The Audit Trail is very good at capturing significant changes made to your OP -- who changed the patient to Checked In? Who cancelled an appointment? Who deleted an Encounter Note?
However, the Audit Trail lists only the relevant codes, not the descriptions of what each code means -- this is necessary so performance isn't bogged down. It may therefore be helpful to get a sense of what some of the common codes mean.
Common Definitions for Code Abbreviations
Table Changed | Field changed | What does this mean? | Code lookup SQL |
Schedule | "ADDR_ID" | Provider the appointment was scheduled with | select staffid, staffname, activestatus from staff1 where staffid >99 and activestatus not in ('1','2') |
Schedule:Appt, Schedule : Main | "activity_status" | The current visit status of an appointment ("In Waiting Room", "MD In Progress" etc) | select appt_type_id as status_number, description as status from appt_type where code_type = 1 order by 1 |
Schedule:Appt | "r_addr_id" | Room/resource assignment | select staffid as resource_id, staffinit as abbrev, staffname as room_resource from staff1 where activestatus = '2' order by 1 |
Sample Lists
Activity Status
"activity_status": Your practice's particular activity status list is customizable, but many practices who have not done extensive customization may have a list similar to this. For a precise list of your practice's activity status codes, use the SQL above.
Activity status code | Meaning |
13 | Waiting room |
14 | Triage |
15 | In progress |
12 | Scheduled |
18 | Note |
17 | Checked out |
201 | FInished |
202 | MD pt waiting |
203 | MD in progress |
204 | MD finished |
205 | Nurse pt waiting |
206 | Nurse in progress |
207 | Nurse finished |
208 | Nurse shots |
209 | Nurse labs |
No show | No show |
Cancelled | Cancelled |
Diagnostic Test Status
When viewing the changes made to records in the Audit Logs, you will notice codes attached to Diagnostic Test changes. An explanation of these codes is listed below:
Diagnostic Test status code | Meaning |
6 | Deferred |
4 | Informed |
5 | No Show |
0 | Order to be Placed |
14 | Partial Infd |
7 | Complete |
12 | Partial Rec'd |
13 | Partial Rev'd |
1 | Pending |
2 | Received |
3 | Reviewed |
| 8 | Cancelled |
