Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Order_Guidelines_Detail
Touchworks 25.2
[dbo].[Order_Guidelines_Detail]
MS_Description
Order guidelines details for Imaging and Diagnostic orders.
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Order_Guidelines_Detail table
ItemID
[dbo].[uniqueid]
9
NOT NULL
((0))
Order. Link to Item_Plan.ID.
EHRSessionID
varchar(70)
70
NOT NULL
('')
Session id of EHR app.
Score
numeric(8,0)
5
NOT NULL
((0))
Score
Rank
numeric(8,0)
5
NOT NULL
((0))
Rank
VendorSessionID
char(12)
12
NOT NULL
('')
Vendor Session ID
AdditionalReason
nvarchar(max)
max
NOT NULL
('')
Additional Reason
ContentSource
varchar(255)
255
NOT NULL
('')
Content Source of the Guideline
RADGCode
varchar(10)
10
NULL allowed
Radiology G Code
RADModifier
varchar(50)
50
NULL allowed
Radiology Modifier