Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
  | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to the Medication_Alert table |
  | ItemChildID | [dbo].[uniqueid] | 9 | NOT NULL | | | Item Version ID of Immunization or Medication. Link to Medication.ID or Immunization.ID. |
 | ItemType | char(2) | 2 | NOT NULL | | | Item Type. Ex : ME - Medication , IM - Immunization |
  ![Foreign Keys FK_Medication_Alert_AlertTypeDE_Alert_Type_DE_ID: [dbo].[Alert_Type_DE].AlertTypeDE Foreign Keys FK_Medication_Alert_AlertTypeDE_Alert_Type_DE_ID: [dbo].[Alert_Type_DE].AlertTypeDE](../../../../Images/fk.png) | AlertTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Alert Type. Link to Alert_Type_DE.ID |
 ![Foreign Keys FK_Medication_Alert_MedicationDE_Medication_DE_ID: [dbo].[Medication_DE].MedicationDE Foreign Keys FK_Medication_Alert_MedicationDE_Medication_DE_ID: [dbo].[Medication_DE].MedicationDE](../../../../Images/fk.png) | MedicationDE | [dbo].[dict_id] | 5 | NOT NULL | | | Medication. Link to Medication_DE.ID |
![Foreign Keys FK_Medication_Alert_UserID_IDX_User_ID: [dbo].[IDX_User].UserID Foreign Keys FK_Medication_Alert_UserID_IDX_User_ID: [dbo].[IDX_User].UserID](../../../../Images/fk.png) | UserID | [dbo].[uniqueid] | 9 | NOT NULL | | | User. Link to IDX_User.ID |
  ![Foreign Keys FK_Medication_Alert_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Medication_Alert_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | | Patient. Link to Person.ID |
(2)![Foreign Keys FK_Medication_Alert_EncounterID_Encounter_ID: [dbo].[Encounter].EncounterID Foreign Keys FK_Medication_Alert_EncounterID_Encounter_ID: [dbo].[Encounter].EncounterID](../../../../Images/fk.png) | EncounterID | [dbo].[uniqueid] | 9 | NOT NULL | | | Encounter. Link to Encounter.ID |
![Check Constraints CK_Medication_Alert_IgnoreFLAG_Yes_Or_No : ([IgnoreFLAG]='N' OR [IgnoreFLAG]='Y') Check Constraints CK_Medication_Alert_IgnoreFLAG_Yes_Or_No : ([IgnoreFLAG]='N' OR [IgnoreFLAG]='Y')](../../../../Images/c-constraint.png) | IgnoreFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Ignore Alert Flag |
![Foreign Keys FK_Medication_Alert_IgnoreReasonDE_Ignore_Reason_DE_ID: [dbo].[Ignore_Reason_DE].IgnoreReasonDE Foreign Keys FK_Medication_Alert_IgnoreReasonDE_Ignore_Reason_DE_ID: [dbo].[Ignore_Reason_DE].IgnoreReasonDE](../../../../Images/fk.png) | IgnoreReasonDE | [dbo].[dict_id] | 5 | NOT NULL | | | Reason for Ignore. Link to Ignore_Reason_DE.ID |
| IgnoreReason | varchar(255) | 255 | NULL allowed | | | Ignore Reason Description |
 | AlertDTTM | datetime | 8 | NULL allowed | | | Alert Date and Time |
 ![Foreign Keys FK_Medication_Alert_ItemEntryTypeDE_Item_Entry_Type_DE_ID: [dbo].[Item_Entry_Type_DE].ItemEntryTypeDE Foreign Keys FK_Medication_Alert_ItemEntryTypeDE_Item_Entry_Type_DE_ID: [dbo].[Item_Entry_Type_DE].ItemEntryTypeDE](../../../../Images/fk.png) | ItemEntryTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Item 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].PBMOverrideReasonDE Foreign Keys FK_Medication_Alert_PBMOverrideReasonDE_PBM_Override_Reason_DE_ID: [dbo].[PBM_Override_Reason_DE].PBMOverrideReasonDE](../../../../Images/fk.png) | PBMOverrideReasonDE | [dbo].[dict_id] | 5 | NOT NULL | | | Override reason. Link to PBM_Override_Reason_DE.ID |
| FormularyID | char(10) | 10 | NULL allowed | | | Formulary ID |
 | InitialFormularyIndicator | tinyint | 1 | NULL allowed | | | Initial Formulary Indicator |
![Check Constraints CK_Medication_Alert_ChangeMedicationFLAG_Yes_Or_No : ([ChangeMedicationFLAG]='N' OR [ChangeMedicationFLAG]='Y') Check Constraints CK_Medication_Alert_ChangeMedicationFLAG_Yes_Or_No : ([ChangeMedicationFLAG]='N' OR [ChangeMedicationFLAG]='Y')](../../../../Images/c-constraint.png) | ChangeMedicationFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Medication Change Flag |
| ReplacementFormularyIndicator | tinyint | 1 | NULL allowed | | | Replacement Formulary Indicator |
| FormularyAltMode | tinyint | 1 | NULL allowed | | | Formulary Alternate Mode |
![Foreign Keys FK_Medication_Alert_MedicationAllergyDE_Medication_Allergy_DE_ID: [dbo].[Medication_Allergy_DE].MedicationAllergyDE Foreign Keys FK_Medication_Alert_MedicationAllergyDE_Medication_Allergy_DE_ID: [dbo].[Medication_Allergy_DE].MedicationAllergyDE](../../../../Images/fk.png) | MedicationAllergyDE | [dbo].[dict_id] | 5 | NOT NULL | | | Alert Received for and Alergy. Link to Medication_Allergy_DE.ID |
 ![Foreign Keys FK_Medication_Alert_ExistingMedicationDE_Medication_DE_ID: [dbo].[Medication_DE].ExistingMedicationDE Foreign Keys FK_Medication_Alert_ExistingMedicationDE_Medication_DE_ID: [dbo].[Medication_DE].ExistingMedicationDE](../../../../Images/fk.png) | ExistingMedicationDE | [dbo].[dict_id] | 5 | NOT NULL | | | Alert Received because of an existing Medication. Link to Medication_DE.ID |
![Foreign Keys FK_Medication_Alert_ProblemDE_Problem_DE_ID: [dbo].[Problem_DE].ProblemDE Foreign Keys FK_Medication_Alert_ProblemDE_Problem_DE_ID: [dbo].[Problem_DE].ProblemDE](../../../../Images/fk.png) | ProblemDE | [dbo].[dict_id] | 5 | NOT NULL | | | Alert Received for Problem. Link to Problem_DE.ID |
| AlertText | varchar(max) | max | NULL allowed | | | Alerted Text |
| PrescriptionNumber | varchar(20) | 20 | NULL allowed | | | Prescription Number of the medication. |
| DDI | int | 4 | NULL allowed | | | DDI of the Medication / Immunization |
| IsListedIndicator | char(1) | 1 | NULL allowed | | | Is Listed Indicator |
 | SiteDE | [dbo].[dict_id] | 5 | NOT NULL | | | Site. Link to Site_DE.ID |
| TherapClassCode | smallint | 2 | NULL allowed | | | Therapy Class Code |
| TherapSubClassCode | smallint | 2 | NULL allowed | | | Therapy Sub Class Code |
| RelCostCode | smallint | 2 | NULL allowed | | | Relative Cost Code |
| TotalScore | int | 4 | NULL allowed | | | Total Score |
| DatetimeRecCreate | datetime | 8 | NULL allowed | | | Date and Time record first created |
| InitialFormularyStatus | smallint | 2 | NULL allowed | | | Initial Formulary Status |
| FormularyStatus | smallint | 2 | NULL allowed | | | Formulary Status |
| InitialRelCostCode | smallint | 2 | NULL allowed | | | Initial Cost Code |
| InitialTotalScore | int | 4 | NULL allowed | | | Initial Total Score |
 | Script_Msg_ID | int | 4 | NOT NULL | | ((0)) | Script Message. Link to Script_Message.Script_msg_ID |
| FAShown | char(1) | 1 | NOT NULL | | ('N') | FA Shown |
| WarningDisplay | char(1) | 1 | NULL allowed | | | Warring Displayed |
![Check Constraints CK_Medication_Alert_Viewed_Yes_Or_No : ([Viewed]='N' OR [Viewed]='Y') Check Constraints CK_Medication_Alert_Viewed_Yes_Or_No : ([Viewed]='N' OR [Viewed]='Y')](../../../../Images/c-constraint.png) | Viewed | [dbo].[BOOL] | 1 | NULL allowed | | ('N') | Warning was viewed by User |
![Foreign Keys FK_Medication_Alert_MedicationAlertAuditId: [dbo].[Medication_Alert_Audit].MedicationAlertAuditId Foreign Keys FK_Medication_Alert_MedicationAlertAuditId: [dbo].[Medication_Alert_Audit].MedicationAlertAuditId](../../../../Images/fk.png) | MedicationAlertAuditId | [dbo].[uniqueid] | 9 | NULL allowed | | | Identifier from Medication_Alert_Audit. Link to Medication_Alert_Audit.ID |