Tables [dbo].[PatientCommunication]
portal/communication preferences (migrated from person_other)
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_PatientCommunication_PatientID_OrgID: PatientID\OrgIDForeign Keys FK_PatientCommunication_PatientID_Person_ID: [dbo].[Person].PatientIDPatientID[dbo].[uniqueid]9NOT NULL((0))Patient. Link to Person.ID
Cluster Primary Key PK_PatientCommunication_PatientID_OrgID: PatientID\OrgIDForeign Keys FK_PatientCommunication_OrgID_Organization_ID: [dbo].[Organization].OrgIDOrgID[dbo].[dict_id]5NOT NULL((0))Organization. Link to Organization.ID
Foreign Keys FK_PatientCommunication_CSPtCommunicationDE_Patient_Communication_DE_ID: [dbo].[Patient_Communication_DE].CSPtCommunicationDECSPtCommunicationDE[dbo].[dict_id]5NOT NULL((0))Clinical summary communication. Link to Patient_Communication_DE.ID
Foreign Keys FK_PatientCommunication_ReminderPtCommunicationDE_Patient_Communication_DE_ID: [dbo].[Patient_Communication_DE].ReminderPtCommunicationDEReminderPtCommunicationDE[dbo].[dict_id]5NOT NULL((0))Reminder communication. Link to Patient_Communication_DE.ID
Foreign Keys FK_PatientCommunication_ChartUpdatePtCommunicationDE_Patient_Communication_DE_ID: [dbo].[Patient_Communication_DE].ChartUpdatePtCommunicationDEChartUpdatePtCommunicationDE[dbo].[dict_id]5NOT NULL((0))Chart Update communication. Link to Patient_Communication_DE.ID
Foreign Keys FK_PatientCommunication_ResultNotificationPtCommunicationDE_Patient_Communication_DE_ID: [dbo].[Patient_Communication_DE].ResultNotificationPtCommunicationDEResultNotificationPtCommunicationDE[dbo].[dict_id]5NOT NULL((0))Result Notification communication. Link to Patient_Communication_DE.ID
Foreign Keys FK_PatientCommunication_PortalRegistrationStatusDE_Portal_Registration_Status_DE_ID: [dbo].[Portal_Registration_Status_DE].PortalRegistrationStatusDEPortalRegistrationStatusDE[dbo].[dict_id]5NOT NULL((0))Portal registration status. Link to Portal_Registration_Status_DE.ID
UpdatedBySourcechar(1)1NOT NULL('')Source of change. (T - TouchWorks,  ' ' - Other source, E - Existing record).
WhoDidItId[dbo].[uniqueid]9NOT NULL((0))User who entered. Link to IDX_User.ID.