Tables [dbo].[AUDIT_LOG]
Audit Log of user and system actions.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_AUDIT_LOG_ID: IDCluster Key CIX_AccessedDTTM_ID_AuditLog: AccessedDTTM\IDIndexes TWstat_AUDIT_LOG_AccessedDTTM_ID, TWstat_AUDIT_LOG_DeviceUsed_ID, TWstat_AUDIT_LOG_PatientID_ID, TWstat_AUDIT_LOG_RecordID_ID, TWstat_AUDIT_LOG_RecordType_ID, TWstat_AUDIT_LOG_UserID_ID(6)ID[dbo].[uniqueid]9NOT NULL1 - 1Key to the AUDIT_LOG table.
Indexes NIX_AuditLog_AccessedDTTM, TWstat_AUDIT_LOG_UserID_ID(2)Foreign Keys FK_AUDIT_LOG_UserID_IDX_User_ID: [dbo].[IDX_User].UserIDUserID[dbo].[uniqueid]9NOT NULLUser. Key to the IDX_User Table
Indexes TWstat_AUDIT_LOG_RecordID_IDRecordIDnumeric(16,0)9NOT NULLStores 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.
Indexes TWstat_AUDIT_LOG_RecordType_IDRecordTypevarchar(255)255NOT NULLWhat is being updated? Is it a Medication, order, Task? This is used in conjunction with the RecordID
Indexes TWstat_AUDIT_LOG_TypeofActionTypeofActionchar(1)1NOT NULLR = Read, Q = Query, U = Update, W = Write, S = Sign
JustificationTextvarchar(255)255NOT 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.
Cluster Key CIX_AccessedDTTM_ID_AuditLog: AccessedDTTM\IDIndexes NIX_AuditLog_AccessedDTTM, TWstat_AUDIT_LOG_AccessedDTTM_ID(2)AccessedDTTMdatetime8NOT NULLDate record was accessed
AuditModechar(1)1NOT NULL('B')Audit Mode
Indexes TWstat_AUDIT_LOG_DeviceUsed_IDDeviceUsedchar(1)1NOT NULL('W')W for Web
VTBKeyvarchar(255)255NULL allowedVertical Tool Bar Key from Framework
VTBNamevarchar(255)255NULL allowedVertical Tool Bar item selected
HTBKeyvarchar(255)255NULL allowedHorizontal Tool Bar Key from Framework
HTBNamevarchar(255)255NULL allowedHorizontal Tool Bar tab selected.
DocumentKeyvarchar(255)255NULL allowedFrameWork workspace you have open, usually qChart
DocumentNamevarchar(255)255NULL allowedWhat pane of the workspace, typically Clinical Desktop
Indexes NIX_AuditLog_AccessedDTTM, XAK2Audit_Log_PatientID, TWstat_AUDIT_LOG_PatientID_ID(3)PatientID[dbo].[uniqueid]9NOT NULL(0)Patient. Link to person.ID.
EntryNameOldvarchar(255)255NULL allowed('')Old value of what was updated
EntryNameNewvarchar(255)255NOT NULL('')New value