Tables [dbo].[Patient_Iorg]
Table linking Patients to Organizations.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Patient_Iorg_PersonID_InternalOrganization: PersonID\InternalOrganizationIndexes NIX_Patient_Iorg_InternalOrganizationPersonID, TWstat_Patient_Iorg_SortedMRN_PersonID_InternalOrganization(2)Foreign Keys FK_Patient_Iorg_PersonID_Patient_Member_ID: [dbo].[Patient_Member].PersonIDPersonID[dbo].[uniqueid]9NOT NULLPatient Identifier. Foreign key to Patient_Member.ID
Cluster Primary Key PK_Patient_Iorg_PersonID_InternalOrganization: PersonID\InternalOrganizationIndexes NIX_Patient_Iorg_InternalOrganizationPersonID, TWstat_Patient_Iorg_SortedMRN_PersonID_InternalOrganization(2)InternalOrganization[dbo].[dict_id]5NOT NULLOrganization. Link to Organization.ID
Indexes NIX_Patient_Iorg_OrganizationMrnOrganizationMrnvarchar(20)20NOT NULLMedical Record Number
Indexes PatientIorg_OtherNumberOtherNumbervarchar(255)255NOT NULLOther Number. An external Identifier for the patient.
Indexes TWstat_Patient_Iorg_SortedMRN_PersonID_InternalOrganizationSortedMRNvarchar(20)20NOT NULL('Unknown')Sorted Medical Record Number based on the definition in the MRN_Sort table
Indexes PatientIorg_Other2Other2varchar(255)255NOT NULL('')Other Number 2. An external Identifer for the patient
Ident_IDbigint8NOT NULL1 - 1Unique key to the Patient_Iorg table.