Tables [dbo].[PatientPortalUserActivity]
Audit of how patients are accessing data on the portal and FIHR activity.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Primary Key PK_PatientPortalUserActivity_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the PatientPortalUserActivity table.
Indexes NIX_PatientPortalUserActivity_PatientPortalIDPatientPortalIDvarchar(255)255NOT NULLPortal ID for the patients who are registered for portal.
FHIR - For FHIR API activity
GUID value - For FMH Portal
Indexes NIX_PatientPortalUserActivity_PatientEEHRIDForeign Keys FK_PatientPortalUserActivity_PatientEEHRID_Patient_Member_ID: [dbo].[Patient_Member].PatientEEHRIDPatientEEHRID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID.
Activitychar(1)1NOT NULLwhat activity has the patient performed.
V-View
D- Download
T-Transmit
A - Access from FIHR API
U - Retrieved the data from FIHR API
K - CCDA extracted
Cluster Key CIX_PatientPortalUserActivity_PerformedDTTM: PerformedDTTMPerformedDTTMdatetime8NOT NULLdate & time when the patient performed the activity.
PracticeIDvarchar(255)255NOT NULLPortal Practice ID that can be mapped to EEHR Organization.
MessageIDvarchar(100)100NULL allowedID of the message that is to be sent from Portal to EEHR or vice versa.
ProviderPortalIDvarchar(255)255NULL allowedProvider ID (necessary for the PHR clinical information)