Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.PatientPortalUserActivityDetail
Touchworks 25.2
[dbo].[PatientPortalUserActivityDetail]
MS_Description
An extension of PatientPortalUserActivity table. Use to store relevant items extracted with a CCDA document (Activity Type - K).
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
PatientPortalUserActivityID
[dbo].[uniqueid]
9
NOT NULL
Portal Activity. Link to PatientPortalUserActivity.ID
WorkObjectType
varchar(10)
10
NOT NULL
Type of object in WorkObjectID column. Ex. 'DOC' for DocumentID
WorkObjectID
[dbo].[uniqueid]
9
NOT NULL
ID of the object
CreatedDTTM
datetime
8
NOT NULL
Record Creation Data and Time