Tables [dbo].[PatientAccessLog]
Audit of patients brought into context.
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Key CIX_PatientAccessLog_PatientID_UserID: PatientID\UserIDIndexes NIX_PatientAccessLog_UserID_PatientID_BreakGlassExposure_WithIncludeColumnsUserIDnumeric(16,0)9NOT NULLUser accessing the patient. Link to IDX_User.ID
HostNamevarchar(255)255NOT NULLThe webserver the user is connected to
Cluster Key CIX_PatientAccessLog_PatientID_UserID: PatientID\UserIDIndexes NIX_PatientAccessLog_UserID_PatientID_BreakGlassExposure_WithIncludeColumnsPatientIDnumeric(16,0)9NOT NULLPatient. Link to Person.ID.
Indexes NIX_PatientAccessLog_OpenDTTM_CloseDTTM_BreakTypeOpenDTTMdatetime8NOT NULLDate the patients chart was opened
Indexes NIX_PatientAccessLog_OpenDTTM_CloseDTTM_BreakTypeCloseDTTMdatetime8NOT NULLDate the patients chart was closed
ExposureTimeint4NOT NULLHow long did the user have the patients chart open.
Indexes NIX_PatientAccessLog_UserID_PatientID_BreakGlassExposure_WithIncludeColumnsBreakGlassStartDTTMdatetime8NULL allowedIf the user broke glass to open the chart the time it was opened.
Indexes NIX_PatientAccessLog_UserID_PatientID_BreakGlassExposure_WithIncludeColumnsBreakGlassExposureint4NULL allowedIf the user broke glass to open the chart how long did the user have the patients chart open.
BreakGlassReasonvarchar(255)255NULL allowedThe reason Break Glass was used. Some of this text gets hard coded as "Security Over-ride" but it will also tack on anything the user decides to type into the override box.
DeviceUsedchar(1)1NOT NULLType of device Used "W" for web.
Indexes NIX_PatientAccessLog_OpenDTTM_CloseDTTM_BreakType, NIX_PatientAccessLog_UserID_PatientID_BreakGlassExposure_WithIncludeColumns(2)BreakTypechar(2)2NULL allowed"N" means this was not a break glass event, "PO" I believe means "Patient Opened"