Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PatientVacDoseAction
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 |
| ActionCount | INTEGER | 0 | MANDATORY | System defined action count. |
| PracticeID | INTEGER | ? | MANDATORY | FK |
| StaffID | INTEGER | ? | OPTIONAL | FK |
| EncounterSID | INTEGER | ? | MANDATORY | System generated unique id using Encounter sequence. |
| ActionType | CHARACTER(6) | OPTIONAL | 'O'rdered , 'A'dministered , 'C'ontraindicated , 'V'oided, 'Ref'used , 'Rep'orted , 'E'dited | |
| DoseNumber | INTEGER | ? | OPTIONAL | Dose number of a vaccination. |
| 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 | |
| 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. |
| ActionTimeStamp | CHARACTER(14) | OPTIONAL | Date/Time stamp used to keep track of when the user indicated that this action was performed. This is user settable. | |
| 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. | |
| 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 |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Staff | PatientVacDoseAction.PracticeID = Staff.PracticeID and PatientVacDoseAction.StaffID = Staff.StaffID |
RESTRICT if PatientVacDoseAction exists |
| Encounter | PatientVacDoseAction.EncounterSID = Encounter.EncounterSID | RESTRICT if PatientVacDoseAction exists |
| PatientVacDose | PatientVacDoseAction.PatientVacDoseSID = PatientVacDose.PatientVacDoseSID | CASCADE if PatientVacDoseAction exists |
| Child Table | Join Phrase | When deleting PatientVacDoseAction record... |
|---|