Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Description |
---|
  | ID | bigint | 8 | NOT NULL | 1 - 1 | Key to the Audit_Event table |
![Foreign Keys FK_Audit_Event_AuditEventTypeID: [dbo].[Audit_Event_Type].AuditEventTypeID Foreign Keys FK_Audit_Event_AuditEventTypeID: [dbo].[Audit_Event_Type].AuditEventTypeID](../../../../Images/fk.png) | AuditEventTypeID | smallint | 2 | NOT NULL | | Audit Event Type. Link to Audit_Event_Type.ID |
 | UserID | numeric(16,0) | 9 | NOT NULL | | User involved in audit event. Link to Works.dbo.IDX_User.ID |
![Foreign Keys FK_Audit_Event_ApplicationID: [dbo].[Application].ApplicationID Foreign Keys FK_Audit_Event_ApplicationID: [dbo].[Application].ApplicationID](../../../../Images/fk.png) | ApplicationID | tinyint | 1 | NOT NULL | | Application. Link to Application.ID |
| ObjectID | bigint | 8 | NOT NULL | | Object. DocumentID, ChartGroupID, or AccessGroupID depending on eventtype |
| RelatedObjectID | bigint | 8 | NOT NULL | | Some audit events need an extra identifier. IE assign a Chart Group to a user. ObjectID will be the ChartGroupID, and RelatedObjectID will be the user it was assigned to. |
| Details | varchar(255) | 255 | NULL allowed | | Free Text for more details on audit. Could put in batch name being deleted, or old Chart Group Name for a Chart group rename event. |
 | PatientID | numeric(16,0) | 9 | NOT NULL | | Patient involved in the Audit. Link to Works.dbo.Patient_Member.ID |
 | EventDTTM | datetime | 8 | NOT NULL | | Date and time of the audit event |