Tables [dbo].[Item_Plan]
Item level table for non-medication orders.
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_Item_Plan_ID: IDIndexes nix_Item_Plan_ID_ActivityHeaderID_CurrentID_Include, XAK2ItemPlan(2)ID[dbo].[uniqueid]9NOT NULLKey to the Item_Plan table
Indexes xak2_itemplan_acthdr, nix_Item_Plan_ID_ActivityHeaderID_CurrentID_Include, XAK2ItemPlan, STAT_Item_Plan_ActivityHeaderID(4)ActivityHeaderID[dbo].[uniqueid]9NOT NULLActivity Header. Link to Order_Activity_Header.ID.
Cluster Key XAK1ItemPlan: PatientIDIndexes STAT_Item_Plan_ActivityHeaderID, TWstat_Item_Plan_CurrentID_PatientID, TWstat_Item_Plan_ItemType_PatientID, TWstat_Item_Plan_LastUpdateDTTM_PatientID, TWstat_Item_Plan_OrderItemEXT_PatientID, STAT_Item_Plan_PatientID, TWstat_Item_Plan_QOClassificationDE_PatientID, TWstat_Item_Plan_QOMod1DE_PatientID, TWstat_Item_Plan_QOMod2DE_PatientID, TWstat_Item_Plan_QOMod3DE_PatientID(10)Foreign Keys FK_Item_Plan_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID
Indexes xak3_itemplan_orditmext, TWstat_Item_Plan_OrderItemEXT_PatientID(2)OrderItemEXTvarchar(20)20NOT NULLExternal Order Number.
Indexes nix_Item_Plan_CurrentID_QOClassificationDE, nix_Item_Plan_ID_ActivityHeaderID_CurrentID_Include, XAK2ItemPlan, TWstat_Item_Plan_CurrentID_PatientID(4)CurrentIDnumeric(16,0)9NOT NULLCurrent Detail row. Link to Plan_Item.ID.
Foreign Keys FK_Item_Plan_QODE_QO_DE_ID: [dbo].[QO_DE].QODEQODE[dbo].[dict_id]5NOT NULLResultable Item. Link to QO_DE.ID. Not used with orders.
QODETvarchar(255)255NOT NULLResultable item text. No longer used.
Indexes nix_Item_Plan_ID_ActivityHeaderID_CurrentID_Include, XAK2ItemPlan, TWstat_Item_Plan_QOMod1DE_PatientID(3)Foreign Keys FK_Item_Plan_QOMod1DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod1DEQOMod1DE[dbo].[dict_id]5NOT NULLFirst orderable item modifier. Link to QO_Mod_DE.ID.
Indexes nix_Item_Plan_ID_ActivityHeaderID_CurrentID_Include, XAK2ItemPlan, TWstat_Item_Plan_QOMod2DE_PatientID(3)Foreign Keys FK_Item_Plan_QOMod2DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod2DEQOMod2DE[dbo].[dict_id]5NOT NULLSecond orderable item modifier. Link to QO_Mod_DE.ID.
Indexes nix_Item_Plan_ID_ActivityHeaderID_CurrentID_Include, XAK2ItemPlan, TWstat_Item_Plan_QOMod3DE_PatientID(3)Foreign Keys FK_Item_Plan_QOMod3DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod3DEQOMod3DE[dbo].[dict_id]5NOT NULLThird orderable item modifier. Link to QO_Mod_DE.ID.
Indexes XAK2ItemPlanQOModDETvarchar(255)255NOT NULLOrderable Item modifier text. no longer used.
Indexes nix_Item_Plan_CurrentID_QOClassificationDE, XAK2ItemPlan, STAT_Item_Plan_PatientID, TWstat_Item_Plan_QOClassificationDE_PatientID(4)Foreign Keys FK_Item_Plan_QOClassificationDE_QO_Classification_DE_ID: [dbo].[QO_Classification_DE].QOClassificationDEQOClassificationDE[dbo].[dict_id]5NOT NULLOrderable Item. Link to QO_Classification_DE.ID.
Indexes XAK2ItemPlanQOClassificationDETvarchar(255)255NOT NULLOrderable Item Text. Link to QO_Classification_DE.Entryname.
DocFolderIDnumeric(16,0)9NOT NULLDocument Folder Identifier. No Longer Used.
EntryNamevarchar(255)255NOT NULLOrderbale Item name. Link to QO_Classification_DE.Entryname.
Indexes XAK2ItemPlan, TWstat_Item_Plan_CreateDTTM(2)CreateDTTMdatetime8NOT NULLDate/Time that the entry was added
Indexes nix_Item_Plan_ID_ActivityHeaderID_CurrentID_Include, XAK2ItemPlan, XAK4ItemPlan, TWstat_Item_Plan_LastUpdateDTTM_PatientID(4)LastUpdateDTTMdatetime8NOT NULLLast updated date and time
Check Constraints CK_Item_Plan_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')HasSecurityFLAG[dbo].[BOOL]1NOT NULLSecurity indicator (Y/N)
Check Constraints CK_Item_Plan_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')HasAnnotationFLAG[dbo].[BOOL]1NOT NULLAnnotation indicator (Y/N)
Check Constraints CK_Item_Plan_IsAbnormalFLAG_Yes_Or_No : ([IsAbnormalFLAG]='N' OR [IsAbnormalFLAG]='Y')IsAbnormalFLAG[dbo].[BOOL]1NOT NULLIs the order abnormal (Y/N)
Indexes TWstat_Item_Plan_IsErrorFLAGIsErrorFLAG[dbo].[BOOL]1NOT NULLEntered In Error (Y/N)
Indexes XAK2ItemPlanDetailTypechar(1)1NOT NULLOrder Type:
L - Lab
F - Finding
X - Radiology
D - Other Diagnostic Resting
R - Referral
U - Follow Up
P - Precaution
I - Instruction
S - Supply
Indexes TWstat_Item_Plan_ItemType_PatientIDCheck Constraints CK_Item_Plan_ItemType : ([ItemType]='PL')ItemTypechar(2)2NOT NULLPL - Non-medication order
DecodedValuevarchar(255)255NOT NULLValue. Not used with orders
PerformedDTTMdatetime8NOT NULLWhen the values were recorded
Foreign Keys FK_Item_Plan_SubOrderTypeDE_SubOrder_Type_DE_ID: [dbo].[SubOrder_Type_DE].SubOrderTypeDESubOrderTypeDE[dbo].[dict_id]5NOT NULL((0))Sub Oder Type. Link to SubOrder_Type_DE.ID
FormVersionIDuniqueidentifier16NULL allowed(NULL)FormVersionID of the Structured Content form
LocalDocumentIDvarchar(30)30NULL allowedStructured Content Form Identifier. Link to CA datatables to uniquely identify the Strunctured Content form across orders and notes.