Last Updated: 9/24/2025 12:09:38 PM

Intergy Version: 22.00.00.00

VaccineReaction

Table Definition Parent Tables Child Tables

Table Definition

Description: This table holds the possible reactions that a patient can have to a vaccine. This table is not user definable. Reactions are classed for filtering and display purposes. The MedcinID will help us get reaction information into the Encounter Note.

Field	Datatype	Default	Null Option	Comment
VaccineReactionSID	INTEGER	?	MANDATORY	Uniquely Identifies a Vaccine. Uses 'GeneralSystem' sequence
ReactionClass	CHARACTER(10)		MANDATORY	Class of the reaction. Based on a new lookuptype 'VaccineReaction'
Description	CHARACTER(60)		MANDATORY	The description of the vaccine
MedcinID	INTEGER	?	OPTIONAL	Medcin generated unique identifier. Note - may be derived by MedicinFinding table but does not have to exist in that table.
Order	INTEGER	0	MANDATORY	Order of the reaction within the reaction class
RecordStatus	CHARACTER(1)	Record_Status_Active	MANDATORY	Codes for lookup type 'RecordStatus' are not user definable. Valid codes are (A)ctive and (I)nactive.
VAERReportable	LOGICAL	Logical_False	MANDATORY	Indicates that this reaction is an extra special reaction. This will allow this reaction to stand out from other reactions. (VAER stands for 'Vaccine Adverse Reaction)
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...

Child Tables

Child Table	Join Phrase	When deleting VaccineReaction record...
PatientVacDoseReaction	PatientVacDoseReaction.VaccineReactionSID = VaccineReaction.VaccineReactionSID	RESTRICT if PatientVacDoseReaction exists