Tables [dbo].[Audit_Event]
Audit log entries for Integrated Scan
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Primary Key PK_Audit_Event_ID: IDCluster Key CIX_Audit_Event_EventDTTM_ID: EventDTTM\IDIDbigint8NOT NULL1 - 1Key to the Audit_Event table
Foreign Keys FK_Audit_Event_AuditEventTypeID: [dbo].[Audit_Event_Type].AuditEventTypeIDAuditEventTypeIDsmallint2NOT NULLAudit Event Type. Link to Audit_Event_Type.ID
Indexes NIX_Audit_Event_UserIDUserIDnumeric(16,0)9NOT NULLUser involved in audit event. Link to Works.dbo.IDX_User.ID
Foreign Keys FK_Audit_Event_ApplicationID: [dbo].[Application].ApplicationIDApplicationIDtinyint1NOT NULLApplication. Link to Application.ID
ObjectIDbigint8NOT NULLObject. DocumentID, ChartGroupID, or AccessGroupID depending on eventtype
RelatedObjectIDbigint8NOT NULLSome 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.
Detailsvarchar(255)255NULL allowedFree Text for more details on audit. Could put in batch name being deleted, or old Chart Group Name for a Chart group rename event.
Indexes NIX_Audit_Event_PatientIDPatientIDnumeric(16,0)9NOT NULLPatient involved in the Audit. Link to Works.dbo.Patient_Member.ID
Cluster Key CIX_Audit_Event_EventDTTM_ID: EventDTTM\IDEventDTTMdatetime8NOT NULLDate and time of the audit event