Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Reconciled_List
Touchworks 25.2
[dbo].[Reconciled_List]
MS_Description
data related to the reconciliation of Medication and Allergy Orders including the User ID for the reconciling User
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Reconciled_List table
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Link to Person.ID
UserID
[dbo].[uniqueid]
9
NOT NULL
Reconciling User ID. Link to IDX_User.ID
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Link to Encounter.ID
RecordedDTTM
datetime
8
NOT NULL
Recorded Date
ItemType
char(2)
2
NOT NULL
Item Type i.e. ME,AL