Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Encounter_Status
Touchworks 25.2
[dbo].[Encounter_Status]
MS_Description
Status of an Encounter. This is optional but can be set from the banner.
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Link to Encounter.ID
(3)
EncounterStatusDE
[dbo].[dict_id]
5
NOT NULL
Status. Link to Encounter_Status_DE.ID
(3)
LastUpdatedDTTM
datetime
8
NULL allowed
Last updated date and time
SiteDE
[dbo].[dict_id]
5
NOT NULL
Site. Link to Site_DE.ID
(3)
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Link to Person.ID