Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (2) | ID | [dbo].[uniqueid] | 9 | NOT NULL | | Key to the Item_Plan table |
(4) | ActivityHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | | Activity Header. Link to Order_Activity_Header.ID. |
 (10)![Foreign Keys FK_Item_Plan_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Item_Plan_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | Patient. Link to Person.ID |
(2) | OrderItemEXT | varchar(20) | 20 | NOT NULL | | External Order Number. |
(4) | CurrentID | numeric(16,0) | 9 | NOT NULL | | Current Detail row. Link to Plan_Item.ID. |
![Foreign Keys FK_Item_Plan_QODE_QO_DE_ID: [dbo].[QO_DE].QODE Foreign Keys FK_Item_Plan_QODE_QO_DE_ID: [dbo].[QO_DE].QODE](../../../../Images/fk.png) | QODE | [dbo].[dict_id] | 5 | NOT NULL | | Resultable Item. Link to QO_DE.ID. Not used with orders. |
| QODET | varchar(255) | 255 | NOT NULL | | Resultable item text. No longer used. |
(3)![Foreign Keys FK_Item_Plan_QOMod1DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod1DE Foreign Keys FK_Item_Plan_QOMod1DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod1DE](../../../../Images/fk.png) | QOMod1DE | [dbo].[dict_id] | 5 | NOT NULL | | First orderable item modifier. Link to QO_Mod_DE.ID. |
(3)![Foreign Keys FK_Item_Plan_QOMod2DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod2DE Foreign Keys FK_Item_Plan_QOMod2DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod2DE](../../../../Images/fk.png) | QOMod2DE | [dbo].[dict_id] | 5 | NOT NULL | | Second orderable item modifier. Link to QO_Mod_DE.ID. |
(3)![Foreign Keys FK_Item_Plan_QOMod3DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod3DE Foreign Keys FK_Item_Plan_QOMod3DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod3DE](../../../../Images/fk.png) | QOMod3DE | [dbo].[dict_id] | 5 | NOT NULL | | Third orderable item modifier. Link to QO_Mod_DE.ID. |
 | QOModDET | varchar(255) | 255 | NOT NULL | | Orderable Item modifier text. no longer used. |
(4)![Foreign Keys FK_Item_Plan_QOClassificationDE_QO_Classification_DE_ID: [dbo].[QO_Classification_DE].QOClassificationDE Foreign Keys FK_Item_Plan_QOClassificationDE_QO_Classification_DE_ID: [dbo].[QO_Classification_DE].QOClassificationDE](../../../../Images/fk.png) | QOClassificationDE | [dbo].[dict_id] | 5 | NOT NULL | | Orderable Item. Link to QO_Classification_DE.ID. |
 | QOClassificationDET | varchar(255) | 255 | NOT NULL | | Orderable Item Text. Link to QO_Classification_DE.Entryname. |
| DocFolderID | numeric(16,0) | 9 | NOT NULL | | Document Folder Identifier. No Longer Used. |
| EntryName | varchar(255) | 255 | NOT NULL | | Orderbale Item name. Link to QO_Classification_DE.Entryname. |
(2) | CreateDTTM | datetime | 8 | NOT NULL | | Date/Time that the entry was added |
(4) | LastUpdateDTTM | datetime | 8 | NOT NULL | | Last updated date and time |
![Check Constraints CK_Item_Plan_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y') Check Constraints CK_Item_Plan_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')](../../../../Images/c-constraint.png) | HasSecurityFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Security indicator (Y/N) |
![Check Constraints CK_Item_Plan_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y') Check Constraints CK_Item_Plan_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')](../../../../Images/c-constraint.png) | HasAnnotationFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Annotation indicator (Y/N) |
![Check Constraints CK_Item_Plan_IsAbnormalFLAG_Yes_Or_No : ([IsAbnormalFLAG]='N' OR [IsAbnormalFLAG]='Y') Check Constraints CK_Item_Plan_IsAbnormalFLAG_Yes_Or_No : ([IsAbnormalFLAG]='N' OR [IsAbnormalFLAG]='Y')](../../../../Images/c-constraint.png) | IsAbnormalFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Is the order abnormal (Y/N) |
 | IsErrorFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Entered In Error (Y/N) |
 | DetailType | char(1) | 1 | NOT NULL | | Order Type: L - Lab F - Finding X - Radiology D - Other Diagnostic Resting R - Referral U - Follow Up P - Precaution I - Instruction S - Supply |
 ![Check Constraints CK_Item_Plan_ItemType : ([ItemType]='PL') Check Constraints CK_Item_Plan_ItemType : ([ItemType]='PL')](../../../../Images/c-constraint.png) | ItemType | char(2) | 2 | NOT NULL | | PL - Non-medication order |
| DecodedValue | varchar(255) | 255 | NOT NULL | | Value. Not used with orders |
| PerformedDTTM | datetime | 8 | NOT NULL | | When the values were recorded |
![Foreign Keys FK_Item_Plan_SubOrderTypeDE_SubOrder_Type_DE_ID: [dbo].[SubOrder_Type_DE].SubOrderTypeDE Foreign Keys FK_Item_Plan_SubOrderTypeDE_SubOrder_Type_DE_ID: [dbo].[SubOrder_Type_DE].SubOrderTypeDE](../../../../Images/fk.png) | SubOrderTypeDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Sub Oder Type. Link to SubOrder_Type_DE.ID |
| FormVersionID | uniqueidentifier | 16 | NULL allowed | (NULL) | FormVersionID of the Structured Content form |
| LocalDocumentID | varchar(30) | 30 | NULL allowed | | Structured Content Form Identifier. Link to CA datatables to uniquely identify the Strunctured Content form across orders and notes. |