Tables [dbo].[Order_Guidelines_Detail]
Order guidelines details for Imaging and Diagnostic orders.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Order_Guidelines_Detail_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Order_Guidelines_Detail table
Cluster Key CIX_Order_Guidelines_Detail_ItemID: ItemIDForeign Keys FK_Order_Guidelines_Detail_ItemID: [dbo].[Item_Plan].ItemIDItemID[dbo].[uniqueid]9NOT NULL((0))Order. Link to Item_Plan.ID.
EHRSessionIDvarchar(70)70NOT NULL('')Session id of EHR app.
Scorenumeric(8,0)5NOT NULL((0))Score
Ranknumeric(8,0)5NOT NULL((0))Rank
VendorSessionIDchar(12)12NOT NULL('')Vendor Session ID
AdditionalReasonnvarchar(max)maxNOT NULL('')Additional Reason
ContentSourcevarchar(255)255NOT NULL('')Content Source of the Guideline
RADGCodevarchar(10)10NULL allowedRadiology G Code
RADModifiervarchar(50)50NULL allowedRadiology Modifier