Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 (2)![Foreign Keys FK_Patient_Iorg_PersonID_Patient_Member_ID: [dbo].[Patient_Member].PersonID Foreign Keys FK_Patient_Iorg_PersonID_Patient_Member_ID: [dbo].[Patient_Member].PersonID](../../../../Images/fk.png) | PersonID | [dbo].[uniqueid] | 9 | NOT NULL | | | Patient Identifier. Foreign key to Patient_Member.ID |
 (2) | InternalOrganization | [dbo].[dict_id] | 5 | NOT NULL | | | Organization. Link to Organization.ID |
 | OrganizationMrn | varchar(20) | 20 | NOT NULL | | | Medical Record Number |
 | OtherNumber | varchar(255) | 255 | NOT NULL | | | Other Number. An external Identifier for the patient. |
 | SortedMRN | varchar(20) | 20 | NOT NULL | | ('Unknown') | Sorted Medical Record Number based on the definition in the MRN_Sort table |
 | Other2 | varchar(255) | 255 | NOT NULL | | ('') | Other Number 2. An external Identifer for the patient |
| Ident_ID | bigint | 8 | NOT NULL | 1 - 1 | | Unique key to the Patient_Iorg table. |