Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.CaseRegistry_Details_SubmittingFor
Touchworks 25.2
[dbo].[CaseRegistry_Details_SubmittingFor]
MS_Description
Case registry to clinical item linkage
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
CaseRegistryDetailID
[dbo].[uniqueid]
9
NOT NULL
Case Registry Detail. Link to Case_Registry_Detail.ID
ItemType
varchar(10)
10
NOT NULL
Item Type (e.g. Problem)
SubmittingFor
[dbo].[uniqueid]
9
NOT NULL
Clinical Item (e.g. Problem_Header.ID)
OnsetDTTM
datetime
8
NULL allowed
Onset date and time
ResolvedDTTM
datetime
8
NULL allowed
Resolved date and time