Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Person_Multi_Dictionary
Touchworks 25.2
[dbo].[Person_Multi_Dictionary]
MS_Description
Patient attributes , which have multiple entries. View vPersonMultiDictionary will return a unique row per Person
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
PersonID
[dbo].[uniqueid]
9
NOT NULL
Person. Link to Person.ID
DictionaryID
[dbo].[dict_id]
5
NOT NULL
Dictionary. Link to Dictionary.ID
DictionaryName
varchar(30)
30
NOT NULL
Dictionary Name
DisplayOrder
tinyint
1
NOT NULL
Dictionary Entry Display Order
IsDeleted
bit
1
NOT NULL
((0))
Flag deleted ethnicity entries
LastUpdatedDTTM
datetime
8
NULL allowed
Modified date/time of Entry