Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.PatientCommunication
Touchworks 25.2
[dbo].[PatientCommunication]
MS_Description
portal/communication preferences (migrated from person_other)
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
PatientID
[dbo].[uniqueid]
9
NOT NULL
((0))
Patient. Link to Person.ID
OrgID
[dbo].[dict_id]
5
NOT NULL
((0))
Organization. Link to Organization.ID
CSPtCommunicationDE
[dbo].[dict_id]
5
NOT NULL
((0))
Clinical summary communication. Link to Patient_Communication_DE.ID
ReminderPtCommunicationDE
[dbo].[dict_id]
5
NOT NULL
((0))
Reminder communication. Link to Patient_Communication_DE.ID
ChartUpdatePtCommunicationDE
[dbo].[dict_id]
5
NOT NULL
((0))
Chart Update communication. Link to Patient_Communication_DE.ID
ResultNotificationPtCommunicationDE
[dbo].[dict_id]
5
NOT NULL
((0))
Result Notification communication. Link to Patient_Communication_DE.ID
PortalRegistrationStatusDE
[dbo].[dict_id]
5
NOT NULL
((0))
Portal registration status. Link to Portal_Registration_Status_DE.ID
UpdatedBySource
char(1)
1
NOT NULL
('')
Source of change. (T - TouchWorks, ' ' - Other source, E - Existing record).
WhoDidItId
[dbo].[uniqueid]
9
NOT NULL
((0))
User who entered. Link to IDX_User.ID.