Tables [dbo].[Item_Medication]
Item Level table for Medications.
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Primary Key PK_Item_Medication_ID: IDIndexes NIX_Item_Medication_CreateDTTM_INC_ID, Nix_Item_Medication_CurrentID_ID, nix_Item_Medication_ID_ActivityHeaderID_CurrentID_Includes, nix_Item_Medication_ID_ActivityHeaderID_CurrentID_Include, Nix_Item_Medication_PatientID_CurrentID_ID(5)ID[dbo].[uniqueid]9NOT NULLKey to the dbo.Item_Medication table
Indexes xak2_itemmedication_acthdr, Nix_Item_Medication_CurrentID_ID, nix_Item_Medication_ID_ActivityHeaderID_CurrentID_Includes, nix_Item_Medication_ID_ActivityHeaderID_CurrentID_Include(4)ActivityHeaderID[dbo].[uniqueid]9NOT NULLActivity Header. Link to dbo.Order_Activity_Header.ID
Cluster Key XAK1ItemMed: PatientIDIndexes Nix_Item_Medication_PatientID_CurrentID_ID, TWstat_Item_Medication_CreateDTTM_PatientID, TWstat_Item_Medication_CurrentID_PatientID, TWstat_Item_Medication_DocFolderID_PatientID, TWstat_Item_Medication_EntryName_PatientID, TWstat_Item_Medication_ItemType_PatientID, TWstat_Item_Medication_PerformedDTTM_PatientID(7)Foreign Keys FK_Item_Medication_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID
Indexes nix_Item_Medication_ID_ActivityHeaderID_CurrentID_IncludesOrderItemEXTvarchar(20)20NOT NULLExternal Order Number
Indexes Nix_Item_Medication_CurrentID_ID, nix_Item_Medication_ID_ActivityHeaderID_CurrentID_Includes, nix_Item_Medication_ID_ActivityHeaderID_CurrentID_Include, Nix_Item_Medication_PatientID_CurrentID_ID, TWstat_Item_Medication_CurrentID_PatientID(5)CurrentIDnumeric(16,0)9NOT NULLThis 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].QODEQODE[dbo].[dict_id]5NOT NULLResultable Item. Link to QO_DE.ID.
QODETvarchar(255)255NOT NULLResultable Item entryname. QO_DE.Entryname.
Indexes nix_Item_Medication_ID_ActivityHeaderID_CurrentID_Includes, nix_Item_Medication_ID_ActivityHeaderID_CurrentID_Include, TWstat_Item_Medication_QOMod1DE(3)Foreign Keys FK_Item_Medication_QOMod1DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod1DEQOMod1DE[dbo].[dict_id]5NOT NULLOrdable Item Modifier. Link to QO_Mod_DE.ID
Indexes nix_Item_Medication_ID_ActivityHeaderID_CurrentID_Includes, nix_Item_Medication_ID_ActivityHeaderID_CurrentID_Include, TWstat_Item_Medication_QOMod2DE(3)Foreign Keys FK_Item_Medication_QOMod2DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod2DEQOMod2DE[dbo].[dict_id]5NOT NULLOrdable Item Modifier. Link to QO_Mod_DE.ID
Indexes nix_Item_Medication_ID_ActivityHeaderID_CurrentID_Includes, nix_Item_Medication_ID_ActivityHeaderID_CurrentID_Include, TWstat_Item_Medication_QOMod3DE(3)Foreign Keys FK_Item_Medication_QOMod3DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod3DEQOMod3DE[dbo].[dict_id]5NOT NULLOrdable Item Modifier. Link to QO_Mod_DE.ID
QOModDETvarchar(255)255NOT NULLOrdable Item Modifier entryname. Link to QO_Mod_DE.Entryname
Foreign Keys FK_Item_Medication_QOClassificationDE_QO_Classification_DE_ID: [dbo].[QO_Classification_DE].QOClassificationDEQOClassificationDE[dbo].[dict_id]5NOT NULLNot used for medications, will default to 0
QOClassificationDETvarchar(255)255NOT NULLNot used, will default to blank
Indexes nix_Item_Medication_ID_ActivityHeaderID_CurrentID_Includes, TWstat_Item_Medication_DocFolderID_PatientID(2)DocFolderIDnumeric(16,0)9NOT NULLNot used, will default to 0
Indexes TWstat_Item_Medication_EntryName_PatientIDEntryNamevarchar(255)255NOT NULLentryname of the medication
Indexes NIX_Item_Medication_CreateDTTM_INC_ID, nix_Item_Medication_ID_ActivityHeaderID_CurrentID_Includes, TWstat_Item_Medication_CreateDTTM_PatientID(3)CreateDTTMdatetime8NOT NULLdate medication was added to the patient's chart
Indexes nix_Item_Medication_ID_ActivityHeaderID_CurrentID_Includes, Portal_Item_Medication(2)LastUpdateDTTMdatetime8NOT NULLdate medication was last updated
Indexes nix_Item_Medication_ID_ActivityHeaderID_CurrentID_IncludesCheck Constraints CK_Item_Medication_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')HasSecurityFLAG[dbo].[BOOL]1NOT NULLSecurity? Y/N
Check Constraints CK_Item_Medication_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')HasAnnotationFLAG[dbo].[BOOL]1NOT NULLAnnotated? Y/N
Indexes nix_Item_Medication_ID_ActivityHeaderID_CurrentID_IncludesCheck Constraints CK_Item_Medication_IsAbnormalFLAG_Yes_Or_No : ([IsAbnormalFLAG]='N' OR [IsAbnormalFLAG]='Y')IsAbnormalFLAG[dbo].[BOOL]1NOT NULLAbnormal? Y/N
Indexes nix_Item_Medication_ID_ActivityHeaderID_CurrentID_Includes, TWstat_Item_Medication_IsErrorFLAG(2)IsErrorFLAG[dbo].[BOOL]1NOT NULLEntered in Error? Y/N
Indexes nix_Item_Medication_ID_ActivityHeaderID_CurrentID_IncludesDetailTypechar(1)1NOT NULLDetail Type - M
Indexes TWstat_Item_Medication_ItemType_PatientIDCheck Constraints CK_Item_Medication_ItemType : ([ItemType]='ME')ItemTypechar(2)2NOT NULLME - Medication
DecodedValuevarchar(255)255NOT NULLDepending on wha the sig is this will sometimes contain dosage info, or it will be 0
Indexes nix_Item_Medication_ID_ActivityHeaderID_CurrentID_Includes, TWstat_Item_Medication_PerformedDTTM_PatientID(2)PerformedDTTMdatetime8NOT NULLDate Immunization was performed.
Indexes nix_Item_Medication_ID_ActivityHeaderID_CurrentID_IncludesCommunitySourceIDvarchar(255)255NULL allowedOID of the Source EHR
Indexes nix_Item_Medication_ID_ActivityHeaderID_CurrentID_IncludesCommunitySourceNamevarchar(255)255NULL allowedName of the Source EHR
Indexes nix_Item_Medication_ID_ActivityHeaderID_CurrentID_IncludesCommunityItemIDvarchar(100)100NULL allowedinternal Medication item ID in the Source EHR