Last Updated: 9/24/2025 12:09:38 PM
Intergy Version: 22.00.00.00
PatientVacDose
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PatientVacDoseSID | INTEGER | ? | MANDATORY | Uniquely identifies the dose of a vaccine for a patient. From the 'Immunization' sequence |
| PracticeID | INTEGER | ? | MANDATORY | FK - Patient and Staff |
| PatientID | INTEGER | ? | MANDATORY | FK - Patient receiving vaccine |
| StaffID | INTEGER | ? | OPTIONAL | FK - Staff administering vaccine |
| EncounterSID | INTEGER | ? | MANDATORY | FK - Encounter |
| VaccineSID | INTEGER | ? | MANDATORY | FK - Vaccine |
| DoseNumber | INTEGER | ? | OPTIONAL | Dose number of a vaccination. |
| DoseStatus | CHARACTER(3) | Alpha_-_O | MANDATORY | Validated by the PatientVacDoseStatus lookuptype. 'O'rdered , 'A'dministered , 'C'ontraindicated, 'V'oided , 'Ref'used , 'Rep'orted. |
| AdminSite | CHARACTER(20) | OPTIONAL | Location on the body where the injection was given. Based on lookup type: VacAdminSite | |
| LotNumber | CHARACTER(50) | OPTIONAL | Lot number from which the vaccination came | |
| ExpirationDate | DATE | OPTIONAL | Date that the vaccine expires | |
| Manufacturer | CHARACTER(50) | OPTIONAL | System defined. The manufacturer of the vaccine. Field is supported by the lookup types:[VacManufacturers]. Values are defined in the LookupCode table for the above lookup types. | |
| Comment | CHARACTER(250) | OPTIONAL | Free Text Comment associated with the vaccine | |
| StatusTimeStamp | CHARACTER(14) | OPTIONAL | Date/Time stamp used to keep track of when the user indicated that this status was changed. This is user settable. | |
| 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. |
| ChargeDiagnosisCode | CHARACTER(10) | OPTIONAL | FK - From Diagnosis. The Diagnosis Code when ordering vaccine. This is used to post charges when administering. | |
| ChargeProcedureCode | CHARACTER(10) | OPTIONAL | FK - From Procedure The Procedure Code when ordering vaccine. This is used to post charges when administering. | |
| RegistryStatus | CHAR(2) | Alpha_-_U | OPTIONAL | Indicates the status of the vaccine dose with regard to the state immunization registry. Valid values are defined by lookup type ImmuRegistryStatus. |
| OrderedBy | CHAR(250) | OPTIONAL | User entered free-text description of the ordering provider/facility for a patient reported immunization. | |
| AdminRoute | CHAR(12) | Set_To_Empty_String | OPTIONAL | Selected Administered Route for the immunization. Defined by LookupType ImmuRoute |
| AdminAmount | DECIMAL(10,2) | OPTIONAL | Defines amount of vaccine administered | |
| AdminUnits | CHAR(12) | Set_To_Empty_String | OPTIONAL | Amount units of vaccine administered. Defined by lookupType ImmuUnits |
| VaccineInfoStatementList | CHAR(100) | Set_To_Empty_String | OPTIONAL | Compound list of selected VaccineInfoStatementSIDs delimited by the pipe symbol. |
| VFCEligibilityCode | CHAR(12) | OPTIONAL | Indicates VFC (Vaccines For Children) eligibility for this vaccine. Eligible values are defined for lookup type VFCCode. | |
| VFCEffectiveDate | DATE | OPTIONAL | Date VFC Eligibility Code is effective. | |
| InformationSource | CHAR(2) | Set_To_Empty_String | OPTIONAL | Immunization information source for patient vaccine. Define by the LookupType ImmuInfoSource. |
| FundingSource | CHAR(10) | OPTIONAL | The Funding source of the Vaccine being administered. Defined by VacFundingSource lookup. | |
| NDC | CHAR(11) | OPTIONAL | NDC (National Drug Code) for the vaccine. | |
| RefusalReasonCode | CHAR(10) | OPTIONAL | Defined by the LookupType ImmRefusalReason. | |
| TradeName | CHAR(60) | OPTIONAL | User-entered trade name of the vaccine. | |
| StatusDateTimeUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the StatusTimeStamp. This field contains the Date, Time and timezone offset. | |
| CreateDateTimeUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the CreateStamp. This field contains the Date, Time and timezone offset. | |
| VISGivenDate | DATE | OPTIONAL | The field will hold the Vaccine Info Sheet Given date when a vaccine is administered to a patient | |
| VISGivenTo | CHAR(105) | OPTIONAL | The field will hold the VIS Given To Name when a vaccine is administered to a patient | |
| TimeStampUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the TimeStamp. This field contains the Date, Time and timezone offset. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Procedure | PatientVacDose.ChargeProcedureCode = Procedure.ProcedureCode | SET NULL if PatientVacDose exists |
| Diagnosis | PatientVacDose.ChargeDiagnosisCode = Diagnosis.DiagnosisCode | SET NULL if PatientVacDose exists |
| Staff | PatientVacDose.PracticeID = Staff.PracticeID and PatientVacDose.StaffID = Staff.StaffID |
RESTRICT if PatientVacDose exists |
| Encounter | PatientVacDose.EncounterSID = Encounter.EncounterSID | RESTRICT if PatientVacDose exists |
| Vaccine | PatientVacDose.VaccineSID = Vaccine.VaccineSID | RESTRICT if PatientVacDose exists |
| Patient | PatientVacDose.PracticeID = Patient.PracticeID and PatientVacDose.PatientID = Patient.PatientID |
RESTRICT if PatientVacDose exists |
| Child Table | Join Phrase | When deleting PatientVacDose record... |
|---|---|---|
| PatientVacDoseReaction | PatientVacDoseReaction.PatientVacDoseSID = PatientVacDose.PatientVacDoseSID | CASCADE if PatientVacDoseReaction exists |
| PatientVacDoseAction | PatientVacDoseAction.PatientVacDoseSID = PatientVacDose.PatientVacDoseSID | CASCADE if PatientVacDoseAction exists |