Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Patient_List_Entry
Touchworks 25.2
[dbo].[Patient_List_Entry]
MS_Description
Patients on a Patient List
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
(4)
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Patient_list_Entry table
(4)
PatientListID
[dbo].[uniqueid]
9
NOT NULL
Patient List. Link to Patient_List.ID
PersonID
[dbo].[uniqueid]
9
NOT NULL
Patient. Link to Person.ID
StartDT
datetime
8
NOT NULL
Date of entry onto the list. Used with inpatient lists.
EndDT
datetime
8
NULL allowed
Date entry no longer meets the criteria of the list. Used with inpatient lists.
SequenceNumber
int
4
NULL allowed
Sequence on the list
(3)
VisitID
[dbo].[uniqueid]
9
NOT NULL
(0)
Inpatient visit associated with the Inpatient list