Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
  (6) | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to the AUDIT_LOG table. |
(2)![Foreign Keys FK_AUDIT_LOG_UserID_IDX_User_ID: [dbo].[IDX_User].UserID Foreign Keys FK_AUDIT_LOG_UserID_IDX_User_ID: [dbo].[IDX_User].UserID](../../../../Images/fk.png) | UserID | [dbo].[uniqueid] | 9 | NOT NULL | | | User. Key to the IDX_User Table |
 | RecordID | numeric(16,0) | 9 | NOT NULL | | | Stores the recordID being touched. In some cases depending on the RecordType this will be the same as the PatientID. In other cases such as Patient Query it will be a 0 as you don't have a record in context yet because you are searching for one. Then for some events such as Medication/Order/Problems updates the recordID will map out to Activity Header ID in order_activity_header.id and problem_header.id. It can also be task ID for a Task record type. |
 | RecordType | varchar(255) | 255 | NOT NULL | | | What is being updated? Is it a Medication, order, Task? This is used in conjunction with the RecordID |
 | TypeofAction | char(1) | 1 | NOT NULL | | | R = Read, Q = Query, U = Update, W = Write, S = Sign |
| JustificationText | varchar(255) | 255 | NOT NULL | | (' ') | This is really only used for Patient Query, ie when you are searching for a patient. It will display the free text you searched for. |
 (2) | AccessedDTTM | datetime | 8 | NOT NULL | | | Date record was accessed |
| AuditMode | char(1) | 1 | NOT NULL | | ('B') | Audit Mode |
 | DeviceUsed | char(1) | 1 | NOT NULL | | ('W') | W for Web |
| VTBKey | varchar(255) | 255 | NULL allowed | | | Vertical Tool Bar Key from Framework |
| VTBName | varchar(255) | 255 | NULL allowed | | | Vertical Tool Bar item selected |
| HTBKey | varchar(255) | 255 | NULL allowed | | | Horizontal Tool Bar Key from Framework |
| HTBName | varchar(255) | 255 | NULL allowed | | | Horizontal Tool Bar tab selected. |
| DocumentKey | varchar(255) | 255 | NULL allowed | | | FrameWork workspace you have open, usually qChart |
| DocumentName | varchar(255) | 255 | NULL allowed | | | What pane of the workspace, typically Clinical Desktop |
(3) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | (0) | Patient. Link to person.ID. |
| EntryNameOld | varchar(255) | 255 | NULL allowed | | ('') | Old value of what was updated |
| EntryNameNew | varchar(255) | 255 | NOT NULL | | ('') | New value |