Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (11) | UserID | [dbo].[uniqueid] | 9 | NOT NULL | | User accessing the patient. Link to IDX_User.ID |
 | HostName | varchar(255) | 255 | NOT NULL | | The webserver the user is connected to |
 (10)![Foreign Keys FK_PatientAccessLog_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_PatientAccessLog_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | Patient. Link to Person.ID. |
(3) | OpenDTTM | datetime | 8 | NOT NULL | | Date the patients chart was opened |
(2) | CloseDTTM | datetime | 8 | NOT NULL | | Date the patients chart was closed |
 | ExposureTime | int | 4 | NOT NULL | | How long did the user have the patients chart open. |
(2) | BreakGlassStartDTTM | datetime | 8 | NULL allowed | | If the user broke glass to open the chart the time it was opened. |
(2) | BreakGlassExposure | int | 4 | NULL allowed | | If the user broke glass to open the chart how long did the user have the patients chart open. |
 | BreakGlassReason | varchar(255) | 255 | NULL allowed | | The 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. |
 | DeviceUsed | char(1) | 1 | NOT NULL | ('W') | Type of device Used "W" for web. |
(3)![Check Constraints CK_PatientAccessLog_BreakType_Break_Type : ([BreakType]='N' OR [BreakType]='BG' OR [BreakType]='PO') Check Constraints CK_PatientAccessLog_BreakType_Break_Type : ([BreakType]='N' OR [BreakType]='BG' OR [BreakType]='PO')](../../../../Images/c-constraint.png) | BreakType | char(2) | 2 | NULL allowed | (null) | "N" means this was not a break glass event, "PO" I believe means "Patient Opened" |