Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.PatientCommunication_Audit
Touchworks 25.2
[dbo].[PatientCommunication_Audit]
MS_Description
Audit of changes to the PatientCommunication table
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Identity Column
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Link to PatientCommunication.PatientID.
OrgID
[dbo].[dict_id]
5
NOT NULL
Organization
OldCSPtCommunicationDE
[dbo].[dict_id]
5
NOT NULL
Old value of PatientCommunication.CSPtCommunicationDE
NewCSPtCommunicationDE
[dbo].[dict_id]
5
NOT NULL
New value of PatientCommunication.CSPtCommunicationDE
OldReminderPtCommunicationDE
[dbo].[dict_id]
5
NOT NULL
Old value of PatientCommunication.ReminderPtCommunicationDE
NewReminderPtCommunicationDE
[dbo].[dict_id]
5
NOT NULL
New value of PatientCommunication.ReminderPtCommunicationDE
OldChartUpdatePtCommunicationDE
[dbo].[dict_id]
5
NOT NULL
Old value of PatientCommunication.ChartUpdatePtCommunicationDE
NewChartUpdatePtCommunicationDE
[dbo].[dict_id]
5
NOT NULL
New value of PatientCommunication.ChartUpdatePtCommunicationDE
OldResultNotificationPtCommunicationDE
[dbo].[dict_id]
5
NOT NULL
Old value of PatientCommunication.ResultNotificationPtCommunicationDE
NewResultNotificationPtCommunicationDE
[dbo].[dict_id]
5
NOT NULL
New value of PatientCommunication.ResultNotificationPtCommunicationDE
OldPortalRegistrationStatusDE
[dbo].[dict_id]
5
NOT NULL
Old value of PatientCommunication.PortalRegistrationStatusDE
NewPortalRegistrationStatusDE
[dbo].[dict_id]
5
NOT NULL
New value of PatientCommunication.PortalRegistrationStatusDE
CreatedDTTM
datetime
8
NOT NULL
Record Creation Data and Time
OldUpdatedBySource
char(1)
1
NOT NULL
('E')
Previous UpdatedBySource value.
NewUpdatedBySource
char(1)
1
NOT NULL
('E')
New UpdatedBySource value.
OldWhoDidItId
[dbo].[uniqueid]
9
NOT NULL
((0))
User who entered the previous version. Link to IDX_User.ID.
NewWhoDidItId
[dbo].[uniqueid]
9
NOT NULL
((0))
User who made the current edit. Link to IDX_User.ID.