Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Patient_Location
Touchworks 25.2
[dbo].[Patient_Location]
MS_Description
Current Location for a patient. Set from the banner.
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Key to the Person Table
(2)
SiteLocationDE
[dbo].[dict_id]
5
NOT NULL
Site Location. Key to the Site_Location_DE table.
LastUpdatedDTTM
datetime
8
NULL allowed
Last date location was updated
SiteDE
[dbo].[dict_id]
5
NOT NULL
Site. Key to the Site_DE table.
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Key to the Encounter table