Tables [dbo].[PatientCommunication_Audit]
Audit of changes to the PatientCommunication table
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_PatientCommunication_Audit_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Identity Column
Cluster Key CIX_PatientCommunication_Audit_PatientID_OrgID: PatientID\OrgIDForeign Keys FK_PatientCommunication_Audit_PatientID_Person_ID: [dbo].[Person].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to PatientCommunication.PatientID.
Cluster Key CIX_PatientCommunication_Audit_PatientID_OrgID: PatientID\OrgIDOrgID[dbo].[dict_id]5NOT NULLOrganization
OldCSPtCommunicationDE[dbo].[dict_id]5NOT NULLOld value of PatientCommunication.CSPtCommunicationDE
NewCSPtCommunicationDE[dbo].[dict_id]5NOT NULLNew value of PatientCommunication.CSPtCommunicationDE
OldReminderPtCommunicationDE[dbo].[dict_id]5NOT NULLOld value of PatientCommunication.ReminderPtCommunicationDE
NewReminderPtCommunicationDE[dbo].[dict_id]5NOT NULLNew value of PatientCommunication.ReminderPtCommunicationDE
OldChartUpdatePtCommunicationDE[dbo].[dict_id]5NOT NULLOld value of PatientCommunication.ChartUpdatePtCommunicationDE
NewChartUpdatePtCommunicationDE[dbo].[dict_id]5NOT NULLNew value of PatientCommunication.ChartUpdatePtCommunicationDE
OldResultNotificationPtCommunicationDE[dbo].[dict_id]5NOT NULLOld value of PatientCommunication.ResultNotificationPtCommunicationDE
NewResultNotificationPtCommunicationDE[dbo].[dict_id]5NOT NULLNew value of PatientCommunication.ResultNotificationPtCommunicationDE
OldPortalRegistrationStatusDE[dbo].[dict_id]5NOT NULLOld value of PatientCommunication.PortalRegistrationStatusDE
NewPortalRegistrationStatusDE[dbo].[dict_id]5NOT NULLNew value of PatientCommunication.PortalRegistrationStatusDE
CreatedDTTMdatetime8NOT NULLRecord Creation Data and Time
OldUpdatedBySourcechar(1)1NOT NULL('E')Previous UpdatedBySource value.
NewUpdatedBySourcechar(1)1NOT NULL('E')New UpdatedBySource value.
OldWhoDidItId[dbo].[uniqueid]9NOT NULL((0))User who entered the previous version. Link to IDX_User.ID.
NewWhoDidItId[dbo].[uniqueid]9NOT NULL((0))User who made the current edit. Link to IDX_User.ID.