Tables [dbo].[PatientAccessLog]
Audit of patients brought into context.
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Key PK_Patient_Access: PatientID\UserIDIndexes NIX_PatientAccessLog_UserID_OpenDTTM, NIX_PatientAccessLog_UserID_PatientID_BreakGlassExposure_WithIncludeColumns, TWstat_PatientAccessLog_BreakGlassExposure_PatientID_UserID, TWstat_PatientAccessLog_BreakGlassReason_PatientID_UserID, TWstat_PatientAccessLog_BreakGlassStartDTTM_PatientID_UserID, TWstat_PatientAccessLog_BreakType_PatientID_UserID, TWstat_PatientAccessLog_CloseDTTM_PatientID_UserID, TWstat_PatientAccessLog_DeviceUsed_PatientID_UserID, TWstat_PatientAccessLog_ExposureTime_PatientID_UserID, TWstat_PatientAccessLog_HostName_PatientID_UserID, TWstat_PatientAccessLog_OpenDTTM_PatientID_UserID(11)UserID[dbo].[uniqueid]9NOT NULLUser accessing the patient. Link to IDX_User.ID
Indexes TWstat_PatientAccessLog_HostName_PatientID_UserIDHostNamevarchar(255)255NOT NULLThe webserver the user is connected to
Cluster Key PK_Patient_Access: PatientID\UserIDIndexes NIX_PatientAccessLog_UserID_PatientID_BreakGlassExposure_WithIncludeColumns, TWstat_PatientAccessLog_BreakGlassExposure_PatientID_UserID, TWstat_PatientAccessLog_BreakGlassReason_PatientID_UserID, TWstat_PatientAccessLog_BreakGlassStartDTTM_PatientID_UserID, TWstat_PatientAccessLog_BreakType_PatientID_UserID, TWstat_PatientAccessLog_CloseDTTM_PatientID_UserID, TWstat_PatientAccessLog_DeviceUsed_PatientID_UserID, TWstat_PatientAccessLog_ExposureTime_PatientID_UserID, TWstat_PatientAccessLog_HostName_PatientID_UserID, TWstat_PatientAccessLog_OpenDTTM_PatientID_UserID(10)Foreign Keys FK_PatientAccessLog_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID.
Indexes XAK1PatientAccessLog_CloseDTTM, NIX_PatientAccessLog_UserID_OpenDTTM, TWstat_PatientAccessLog_OpenDTTM_PatientID_UserID(3)OpenDTTMdatetime8NOT NULLDate the patients chart was opened
Indexes XAK1PatientAccessLog_CloseDTTM, TWstat_PatientAccessLog_CloseDTTM_PatientID_UserID(2)CloseDTTMdatetime8NOT NULLDate the patients chart was closed
Indexes TWstat_PatientAccessLog_ExposureTime_PatientID_UserIDExposureTimeint4NOT NULLHow long did the user have the patients chart open.
Indexes NIX_PatientAccessLog_UserID_PatientID_BreakGlassExposure_WithIncludeColumns, TWstat_PatientAccessLog_BreakGlassStartDTTM_PatientID_UserID(2)BreakGlassStartDTTMdatetime8NULL allowedIf the user broke glass to open the chart the time it was opened.
Indexes NIX_PatientAccessLog_UserID_PatientID_BreakGlassExposure_WithIncludeColumns, TWstat_PatientAccessLog_BreakGlassExposure_PatientID_UserID(2)BreakGlassExposureint4NULL allowedIf the user broke glass to open the chart how long did the user have the patients chart open.
Indexes TWstat_PatientAccessLog_BreakGlassReason_PatientID_UserIDBreakGlassReasonvarchar(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.
Indexes TWstat_PatientAccessLog_DeviceUsed_PatientID_UserIDDeviceUsedchar(1)1NOT NULL('W')Type of device Used "W" for web.
Indexes XAK1PatientAccessLog_CloseDTTM, NIX_PatientAccessLog_UserID_PatientID_BreakGlassExposure_WithIncludeColumns, TWstat_PatientAccessLog_BreakType_PatientID_UserID(3)Check Constraints CK_PatientAccessLog_BreakType_Break_Type : ([BreakType]='N' OR [BreakType]='BG' OR [BreakType]='PO')BreakTypechar(2)2NULL allowed(null)"N" means this was not a break glass event, "PO" I believe means "Patient Opened"