Description: This table stores the DUR alerts presented to the provider, and the provider's response to those alerts.

Field	Datatype	Default	Null Option	Comment
DURAlertSID	INTEGER	?	MANDATORY	System generated unique id using the DURAlert sequence.
PracticeID	INTEGER	?	MANDATORY	FK - from Staff table
StaffID	INTEGER	?	OPTIONAL	FK - from Staff table
EncounterSID	INTEGER	?	OPTIONAL	FK - from Encounter table
PatientID	INTEGER	?	MANDATORY	FK - from Patient table
ResponseUser	INTEGER	?	MANDATORY	User ID of the user who got the alert.
ResponseType	CHAR(1)		MANDATORY	Provider's response to the alert. Possible values - (A)ccept alert, (C)ancel prescription, and (H)old.
ResponseTimeStamp	CHAR(14)		MANDATORY	Date/Time on which user responded to the alert
ResponseNotes	CHAR(5000)		OPTIONAL	Notes that provider may enter while accepting the alert
TimeStamp	CHARACTER(14)		OPTIONAL	System generated date/time stamp record was last written.
LastUser	INTEGER	?	OPTIONAL	User ID of user that last wrote the record.
CreateStamp	CHARACTER(14)		OPTIONAL	System generated date/time stamp record was created.
CreateUser	INTEGER	?	OPTIONAL	User ID of user that created the record.

Parent Tables

Parent Table Join Phrase When deleting parent record...

Encounter DURAlert.EncounterSID = Encounter.EncounterSID RESTRICT if DURAlert exists

Patient DURAlert.PracticeID = Patient.PracticeID and
DURAlert.PatientID = Patient.PatientID RESTRICT if DURAlert exists

Staff DURAlert.PracticeID = Staff.PracticeID and
DURAlert.StaffID = Staff.StaffID RESTRICT if DURAlert exists

Parent Table	Join Phrase	When deleting parent record...
Encounter	DURAlert.EncounterSID = Encounter.EncounterSID	RESTRICT if DURAlert exists
Patient	DURAlert.PracticeID = Patient.PracticeID and DURAlert.PatientID = Patient.PatientID	RESTRICT if DURAlert exists
Staff	DURAlert.PracticeID = Staff.PracticeID and DURAlert.StaffID = Staff.StaffID	RESTRICT if DURAlert exists

Child Tables

Child Table	Join Phrase	When deleting DURAlert record...