Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PatientVacDoseReaction
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PatientVacDoseReactionSID | INTEGER | ? | MANDATORY | Uniquely identifies the dose of a vaccine for a patient. From the 'Immunization' sequence |
| PatientVacDoseSID | INTEGER | ? | MANDATORY | FK - From PatientVacDose |
| VaccineReactionSID | INTEGER | ? | MANDATORY | FK - From VaccineReaction |
| Description | CHARACTER(60) | OPTIONAL | If the reaction type is 'other' then the reaction may have a free form description. | |
| EncounterSID | INTEGER | ? | MANDATORY | FK - From Encounter |
| PracticeID | INTEGER | ? | OPTIONAL | FK - From Staff |
| StaffID | INTEGER | ? | OPTIONAL | FK - From Staff |
| OnsetDate | DATE | OPTIONAL | Represents when the patient reported that the reaction began. | |
| Comment | CHARACTER(250) | OPTIONAL | Free Text Comment associated with the vaccine | |
| VoidUserID | INTEGER | ? | OPTIONAL | User who voided the instance of this reaction. |
| VoidDate | DATE | OPTIONAL | The date the reaction was voided | |
| ReactionStatus | CHARACTER(1) | Record_Status_Active | MANDATORY | Status of the reaction ('V' oid, or 'A'ctive) |
| 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... |
|---|---|---|
| Staff | PatientVacDoseReaction.PracticeID = Staff.PracticeID and PatientVacDoseReaction.StaffID = Staff.StaffID |
SET NULL if PatientVacDoseReaction exists |
| Encounter | PatientVacDoseReaction.EncounterSID = Encounter.EncounterSID | RESTRICT if PatientVacDoseReaction exists |
| VaccineReaction | PatientVacDoseReaction.VaccineReactionSID = VaccineReaction.VaccineReactionSID | RESTRICT if PatientVacDoseReaction exists |
| PatientVacDose | PatientVacDoseReaction.PatientVacDoseSID = PatientVacDose.PatientVacDoseSID | CASCADE if PatientVacDoseReaction exists |
| Child Table | Join Phrase | When deleting PatientVacDoseReaction record... |
|---|