Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Patient_Iorg_History
Touchworks 25.2
[dbo].[Patient_Iorg_History]
MS_Description
History of changes to the Patient_Iorg table
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
ChangeDTTM
datetime
8
NOT NULL
Time of change
PersonID
[dbo].[uniqueid]
9
NOT NULL
Patient. Link to Person.ID
InternalOrganization
[dbo].[dict_id]
5
NOT NULL
Organization. Link to Organization.ID
OrganizationMRNOld
varchar(20)
20
NULL allowed
Previous MRN
OrganizationMRNNew
varchar(20)
20
NULL allowed
Post MRN
OthernumberOld
varchar(255)
255
NULL allowed
Previous Other Number
OtherNumberNew
varchar(255)
255
NULL allowed
Post Other Number
Other2Old
varchar(255)
255
NULL allowed
Previous Other2
Other2New
varchar(255)
255
NULL allowed
Post Other2