Schema

Column Name	Data Type	Description	Example	Max Length	Is Null
itemguid	varchar	Unique identifier for the audited item (the specific record accessed or modified). Part of the composite primary key.	{K1L2M3N4-O5P6-7890-QRST-901234567890}	38	False
patientguid	varchar	References the patient whose record was involved.	{F6A7B8C9-D0E1-2345-FABC-456789012345}	38	False
organisationguid	varchar	References the practice where the event occurred.	{C3D4E5F6-A7B8-9012-CDEF-123456789012}	38	False
modifieddate	date	The date the audit event was recorded.	2025-01-20	3	False
modifiedtime	time	The time the audit event was recorded.	11:00:00	5	False
userinroleguid	varchar	References the staff member who performed the action.	{G7H8I9J0-K1L2-3456-MNOP-567890123456}	38	True
itemtype	varchar	The type of clinical item that was accessed or modified (e.g., Consultation, Observation, Prescription).	Drug Issue	200	False
modetype	varchar	The type of action performed (e.g., Read, Write, Delete).	Delete	100	False