Tables [dbo].[PatientPortalUserActivityDetail]
An extension of PatientPortalUserActivity  table. Use to store relevant items extracted with a CCDA document (Activity Type - K).
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_PatientPortalUserActivityDetail_PatientPortalUserActivityID: PatientPortalUserActivityIDIndexes NIX_PatientPortalUserActivityDetail_WorkObjectIDForeign Keys FK_PatientPortalUserActivityDetail_PatientPortalUserActivityID: [dbo].[PatientPortalUserActivity].PatientPortalUserActivityIDPatientPortalUserActivityID[dbo].[uniqueid]9NOT NULLPortal Activity. Link to PatientPortalUserActivity.ID
WorkObjectTypevarchar(10)10NOT NULLType of object in WorkObjectID column. Ex. 'DOC' for DocumentID
Indexes NIX_PatientPortalUserActivityDetail_WorkObjectIDWorkObjectID[dbo].[uniqueid]9NOT NULLID of the object
CreatedDTTMdatetime8NOT NULLRecord Creation Data and Time