Tables [dbo].[Patient_MasterChart]
Table to provide a master patient index external identifier for the patient. This must be unique per organization pool and only one per patient.
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key pk_Patient_MasterChart_PatientID: PatientIDForeign Keys fk_Patient_MasterChart_PatientID: [dbo].[Person].PatientIDPatientID[dbo].[uniqueid]9NOT NULLKey to the Person Table
Indexes nix_Patient_MasterChart_MasterChartID_OrgSharingDEOrgSharingDE[dbo].[dict_id]5NOT NULLOrganization Sharing Pool. Link to Org_Sharing_DE.ID.
Indexes nix_Patient_MasterChart_MasterChartID_OrgSharingDEMasterChartIDvarchar(255)255NOT NULLExternal identifier for the patient. This must be unique within the organizatio sharing pool. Only one per patient is allowed.