Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
 (5) | ID | [dbo].[uniqueid] | 9 | NOT NULL | Key to the dbo.Item_Medication table |
(4) | ActivityHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | Activity Header. Link to dbo.Order_Activity_Header.ID |
 (7)![Foreign Keys FK_Item_Medication_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Item_Medication_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | Patient. Link to Patient_Member.ID |
 | OrderItemEXT | varchar(20) | 20 | NOT NULL | External Order Number |
(5) | CurrentID | numeric(16,0) | 9 | NOT NULL | This points to the ID of the current version level entry of the medication in the dbo.medication table |
![Foreign Keys FK_Item_Medication_QODE_QO_DE_ID: [dbo].[QO_DE].QODE Foreign Keys FK_Item_Medication_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. |
| QODET | varchar(255) | 255 | NOT NULL | Resultable Item entryname. QO_DE.Entryname. |
(3)![Foreign Keys FK_Item_Medication_QOMod1DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod1DE Foreign Keys FK_Item_Medication_QOMod1DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod1DE](../../../../Images/fk.png) | QOMod1DE | [dbo].[dict_id] | 5 | NOT NULL | Ordable Item Modifier. Link to QO_Mod_DE.ID |
(3)![Foreign Keys FK_Item_Medication_QOMod2DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod2DE Foreign Keys FK_Item_Medication_QOMod2DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod2DE](../../../../Images/fk.png) | QOMod2DE | [dbo].[dict_id] | 5 | NOT NULL | Ordable Item Modifier. Link to QO_Mod_DE.ID |
(3)![Foreign Keys FK_Item_Medication_QOMod3DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod3DE Foreign Keys FK_Item_Medication_QOMod3DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod3DE](../../../../Images/fk.png) | QOMod3DE | [dbo].[dict_id] | 5 | NOT NULL | Ordable Item Modifier. Link to QO_Mod_DE.ID |
| QOModDET | varchar(255) | 255 | NOT NULL | Ordable Item Modifier entryname. Link to QO_Mod_DE.Entryname |
![Foreign Keys FK_Item_Medication_QOClassificationDE_QO_Classification_DE_ID: [dbo].[QO_Classification_DE].QOClassificationDE Foreign Keys FK_Item_Medication_QOClassificationDE_QO_Classification_DE_ID: [dbo].[QO_Classification_DE].QOClassificationDE](../../../../Images/fk.png) | QOClassificationDE | [dbo].[dict_id] | 5 | NOT NULL | Not used for medications, will default to 0 |
| QOClassificationDET | varchar(255) | 255 | NOT NULL | Not used, will default to blank |
(2) | DocFolderID | numeric(16,0) | 9 | NOT NULL | Not used, will default to 0 |
 | EntryName | varchar(255) | 255 | NOT NULL | entryname of the medication |
(3) | CreateDTTM | datetime | 8 | NOT NULL | date medication was added to the patient's chart |
(2) | LastUpdateDTTM | datetime | 8 | NOT NULL | date medication was last updated |
 ![Check Constraints CK_Item_Medication_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y') Check Constraints CK_Item_Medication_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')](../../../../Images/c-constraint.png) | HasSecurityFLAG | [dbo].[BOOL] | 1 | NOT NULL | Security? Y/N |
![Check Constraints CK_Item_Medication_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y') Check Constraints CK_Item_Medication_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')](../../../../Images/c-constraint.png) | HasAnnotationFLAG | [dbo].[BOOL] | 1 | NOT NULL | Annotated? Y/N |
 ![Check Constraints CK_Item_Medication_IsAbnormalFLAG_Yes_Or_No : ([IsAbnormalFLAG]='N' OR [IsAbnormalFLAG]='Y') Check Constraints CK_Item_Medication_IsAbnormalFLAG_Yes_Or_No : ([IsAbnormalFLAG]='N' OR [IsAbnormalFLAG]='Y')](../../../../Images/c-constraint.png) | IsAbnormalFLAG | [dbo].[BOOL] | 1 | NOT NULL | Abnormal? Y/N |
(2) | IsErrorFLAG | [dbo].[BOOL] | 1 | NOT NULL | Entered in Error? Y/N |
 | DetailType | char(1) | 1 | NOT NULL | Detail Type - M |
 ![Check Constraints CK_Item_Medication_ItemType : ([ItemType]='ME') Check Constraints CK_Item_Medication_ItemType : ([ItemType]='ME')](../../../../Images/c-constraint.png) | ItemType | char(2) | 2 | NOT NULL | ME - Medication |
| DecodedValue | varchar(255) | 255 | NOT NULL | Depending on wha the sig is this will sometimes contain dosage info, or it will be 0 |
(2) | PerformedDTTM | datetime | 8 | NOT NULL | Date Immunization was performed. |
 | CommunitySourceID | varchar(255) | 255 | NULL allowed | OID of the Source EHR |
 | CommunitySourceName | varchar(255) | 255 | NULL allowed | Name of the Source EHR |
 | CommunityItemID | varchar(100) | 100 | NULL allowed | internal Medication item ID in the Source EHR |