Tables [dbo].[PatientOrderStatusReasons]
This is a worklist table to help keep tract of what items require some worklist action.
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_CIX_PatientOrderStatusReasons_ItemID_ItemType_OrderStatusReasonDE: ItemID\ItemType\OrderStatusReasonDEIndexes NIX_PatientOrderStatusReasons_OrderStatusReasonDE_ItemID_ItemTypeItemID[dbo].[uniqueid]9NOT NULLLink to dbo.Item_Medication.id, or dbo.Item_Plan.id, or dbo.Item_Immunization.id depending on the itemtype.
Cluster Primary Key PK_CIX_PatientOrderStatusReasons_ItemID_ItemType_OrderStatusReasonDE: ItemID\ItemType\OrderStatusReasonDEIndexes NIX_PatientOrderStatusReasons_OrderStatusReasonDE_ItemID_ItemTypeItemTypechar(2)2NOT NULLME|IM|PL  (Medications, Immunizations, Orders)
Cluster Primary Key PK_CIX_PatientOrderStatusReasons_ItemID_ItemType_OrderStatusReasonDE: ItemID\ItemType\OrderStatusReasonDEIndexes NIX_PatientOrderStatusReasons_OrderStatusReasonDE_ItemID_ItemTypeOrderStatusReasonDE[dbo].[dict_id]5NOT NULL(0)Reason an order is in the current status. Link to dbo.Order_status_Reason_de.id. It can hold one of many different reasons (ie. "Requires Verification" or "Retrospective Authorization" etc..)