Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
DURAlert
Table Definition Parent Tables Child Tables
Table Definition| 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 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 Table | Join Phrase | When deleting DURAlert record... |
|---|