Tables [dbo].[Patient_Iorg_History]
History of changes to the Patient_Iorg table
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Key Cix_Patient_Iorg_History: ChangeDTTM\PersonID\InternalOrganizationChangeDTTMdatetime8NOT NULLTime of change
Cluster Key Cix_Patient_Iorg_History: ChangeDTTM\PersonID\InternalOrganizationIndexes Nix_Patient_Iorg_History_PersonID_InternalOrganizationPersonID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID
Cluster Key Cix_Patient_Iorg_History: ChangeDTTM\PersonID\InternalOrganizationIndexes Nix_Patient_Iorg_History_PersonID_InternalOrganizationInternalOrganization[dbo].[dict_id]5NOT NULLOrganization. Link to Organization.ID
OrganizationMRNOldvarchar(20)20NULL allowedPrevious MRN
OrganizationMRNNewvarchar(20)20NULL allowedPost MRN
OthernumberOldvarchar(255)255NULL allowedPrevious Other Number
OtherNumberNewvarchar(255)255NULL allowedPost Other Number
Other2Oldvarchar(255)255NULL allowedPrevious Other2
Other2Newvarchar(255)255NULL allowedPost Other2