Tables [dbo].[Medication_Alert]
DUR alerts displayed for prescriptions
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Medication_Alert_ID: IDCluster Key CIX_Medication_Alert_ItemChildID_ItemType: PatientID\ItemChildID\ItemType\AlertTypeDE\IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Medication_Alert table
Cluster Key CIX_Medication_Alert_ItemChildID_ItemType: PatientID\ItemChildID\ItemType\AlertTypeDE\IDIndexes nix_Medication_Alert_ItemChildID_AlertTypeDEItemChildID[dbo].[uniqueid]9NOT NULLItem Version ID of Immunization or Medication. Link to Medication.ID or Immunization.ID.
Cluster Key CIX_Medication_Alert_ItemChildID_ItemType: PatientID\ItemChildID\ItemType\AlertTypeDE\IDItemTypechar(2)2NOT NULLItem Type. Ex : ME - Medication , IM - Immunization
Cluster Key CIX_Medication_Alert_ItemChildID_ItemType: PatientID\ItemChildID\ItemType\AlertTypeDE\IDIndexes nix_Medication_Alert_ItemChildID_AlertTypeDEForeign Keys FK_Medication_Alert_AlertTypeDE_Alert_Type_DE_ID: [dbo].[Alert_Type_DE].AlertTypeDEAlertTypeDE[dbo].[dict_id]5NOT NULLAlert Type. Link to Alert_Type_DE.ID
Indexes NIX_Medication_Alert_ScriptMsgID_INC_ItemEntryTypeDEForeign Keys FK_Medication_Alert_MedicationDE_Medication_DE_ID: [dbo].[Medication_DE].MedicationDEMedicationDE[dbo].[dict_id]5NOT NULLMedication. Link to Medication_DE.ID
Foreign Keys FK_Medication_Alert_UserID_IDX_User_ID: [dbo].[IDX_User].UserIDUserID[dbo].[uniqueid]9NOT NULLUser. Link to IDX_User.ID
Cluster Key CIX_Medication_Alert_ItemChildID_ItemType: PatientID\ItemChildID\ItemType\AlertTypeDE\IDIndexes TWstat_Medication_Alert_PatientIDForeign Keys FK_Medication_Alert_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID
Indexes NIX_Medication_Alert_EncounterID, TWstat_Medication_Alert_EncounterID(2)Foreign Keys FK_Medication_Alert_EncounterID_Encounter_ID: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
Check Constraints CK_Medication_Alert_IgnoreFLAG_Yes_Or_No : ([IgnoreFLAG]='N' OR [IgnoreFLAG]='Y')IgnoreFLAG[dbo].[BOOL]1NOT NULLIgnore Alert Flag
Foreign Keys FK_Medication_Alert_IgnoreReasonDE_Ignore_Reason_DE_ID: [dbo].[Ignore_Reason_DE].IgnoreReasonDEIgnoreReasonDE[dbo].[dict_id]5NOT NULLReason for Ignore. Link to Ignore_Reason_DE.ID
IgnoreReasonvarchar(255)255NULL allowedIgnore Reason Description
Indexes NIX_Medication_Alert_ScriptMsgID_INC_ItemEntryTypeDEAlertDTTMdatetime8NULL allowedAlert Date and Time
Indexes NIX_Medication_Alert_ScriptMsgID_INC_ItemEntryTypeDEForeign Keys FK_Medication_Alert_ItemEntryTypeDE_Item_Entry_Type_DE_ID: [dbo].[Item_Entry_Type_DE].ItemEntryTypeDEItemEntryTypeDE[dbo].[dict_id]5NOT NULLItem Entry Type. Link to Item_Entry_Type_DE.ID
Foreign Keys FK_Medication_Alert_PBMOverrideReasonDE_PBM_Override_Reason_DE_ID: [dbo].[PBM_Override_Reason_DE].PBMOverrideReasonDEPBMOverrideReasonDE[dbo].[dict_id]5NOT NULLOverride reason. Link to PBM_Override_Reason_DE.ID
FormularyIDchar(10)10NULL allowedFormulary ID
Indexes nix_Medication_Alert_ItemChildID_AlertTypeDEInitialFormularyIndicatortinyint1NULL allowedInitial Formulary Indicator
Check Constraints CK_Medication_Alert_ChangeMedicationFLAG_Yes_Or_No : ([ChangeMedicationFLAG]='N' OR [ChangeMedicationFLAG]='Y')ChangeMedicationFLAG[dbo].[BOOL]1NOT NULLMedication Change Flag
ReplacementFormularyIndicatortinyint1NULL allowedReplacement Formulary Indicator
FormularyAltModetinyint1NULL allowedFormulary Alternate Mode
Foreign Keys FK_Medication_Alert_MedicationAllergyDE_Medication_Allergy_DE_ID: [dbo].[Medication_Allergy_DE].MedicationAllergyDEMedicationAllergyDE[dbo].[dict_id]5NOT NULLAlert Received for and Alergy. Link to Medication_Allergy_DE.ID
Indexes nix_Medication_Alert_ItemChildID_AlertTypeDEForeign Keys FK_Medication_Alert_ExistingMedicationDE_Medication_DE_ID: [dbo].[Medication_DE].ExistingMedicationDEExistingMedicationDE[dbo].[dict_id]5NOT NULLAlert Received because of an existing Medication. Link to Medication_DE.ID
Foreign Keys FK_Medication_Alert_ProblemDE_Problem_DE_ID: [dbo].[Problem_DE].ProblemDEProblemDE[dbo].[dict_id]5NOT NULLAlert Received for Problem. Link to Problem_DE.ID
AlertTextvarchar(max)maxNULL allowedAlerted Text
PrescriptionNumbervarchar(20)20NULL allowedPrescription Number of the medication.
DDIint4NULL allowedDDI of the Medication / Immunization
IsListedIndicatorchar(1)1NULL allowedIs Listed Indicator
Indexes NIX_Medication_Alert_ScriptMsgID_INC_ItemEntryTypeDESiteDE[dbo].[dict_id]5NOT NULLSite. Link to Site_DE.ID
TherapClassCodesmallint2NULL allowedTherapy Class Code
TherapSubClassCodesmallint2NULL allowedTherapy Sub Class Code
RelCostCodesmallint2NULL allowedRelative Cost Code
TotalScoreint4NULL allowedTotal Score
DatetimeRecCreatedatetime8NULL allowedDate and Time record first created
InitialFormularyStatussmallint2NULL allowedInitial Formulary Status
FormularyStatussmallint2NULL allowedFormulary Status
InitialRelCostCodesmallint2NULL allowedInitial Cost Code
InitialTotalScoreint4NULL allowedInitial Total Score
Indexes NIX_Medication_Alert_ScriptMsgID_INC_ItemEntryTypeDEScript_Msg_IDint4NOT NULL((0))Script Message. Link to Script_Message.Script_msg_ID
FAShownchar(1)1NOT NULL('N')FA Shown
WarningDisplaychar(1)1NULL allowedWarring Displayed
Check Constraints CK_Medication_Alert_Viewed_Yes_Or_No : ([Viewed]='N' OR [Viewed]='Y')Viewed[dbo].[BOOL]1NULL allowed('N')Warning was viewed by User
Foreign Keys FK_Medication_Alert_MedicationAlertAuditId: [dbo].[Medication_Alert_Audit].MedicationAlertAuditIdMedicationAlertAuditId[dbo].[uniqueid]9NULL allowedIdentifier from Medication_Alert_Audit. Link to Medication_Alert_Audit.ID