Last Updated: 9/24/2025 12:09:38 PM
Intergy Version: 22.00.00.00
Vaccine
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| VaccineSID | INTEGER | ? | MANDATORY | Uniquely Identifies a Vaccine. Uses 'GeneralSystem' sequence |
| MedcinID | INTEGER | ? | OPTIONAL | Medcin generated unique identifier. Note - may be derived by MedicinFinding table but does not have to exist in that table. |
| RecordStatus | CHARACTER(1) | Record_Status_Active | OPTIONAL | User selected record status for the vaccine. RecordStatus is defined in the LookupCode table for the lookup type 'RecordStatus'. Codes for lookup type 'RecordStatus' are not user definable. Valid codes are (A)ctive and (I)nactive. |
| CDCCode | CHARACTER(20) | OPTIONAL | ||
| ShortName | CHARACTER(50) | OPTIONAL | Short Description supplied by the Center for Disease Control | |
| LongName | CHARACTER(60) | OPTIONAL | Long Description supplied by the Center for Disease Control | |
| MedispanDrugCode | CHARACTER(6) | OPTIONAL | This should not be a FK at this time. There should not be a cascade, or restrict from drugs to this table. The developer will have to check to make sure that the drug is really in the database before using this value. This field will be used to identify a vaccine as a drug. The vaccine could then be used in the DUR. | |
| 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. |
| DefaultAdminSite | CHARACTER(20) | OPTIONAL | System defined. Location on the body where the injection was given. Field is supported by the lookup types:[VacAdminSite]. Values are defined in the LookupCode table for the above lookup types. | |
| DefaultLotNumber | CHARACTER(50) | OPTIONAL | Lot number from which the vaccination came | |
| DefaultExpirationDate | DATE | OPTIONAL | Date that the vaccine expires | |
| DefaultManufacturer | 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. | |
| DefaultProcedureCode | CHARACTER(10) | OPTIONAL | FK - From Procedure | |
| 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 | CHARACTER(100) | Set_To_Empty_String | OPTIONAL | A compound pipe delimited list of selected VaccineInfoStatementSIDs. |
| FundingSource | CHAR(10) | OPTIONAL | The Funding source of the Vaccine being administered. Defined by VacFundingSource lookup. | |
| DefaultNDC | CHAR(11) | OPTIONAL | Default NDC (National Drug Code) for the vaccine. | |
| DefaultTradeName | CHAR(60) | OPTIONAL | User-entered trade name of the vaccine | |
| DefaultNDCFormat | CHAR(5) | OPTIONAL | Default 10 digit NDC format for the vaccine. | |
| IsNotOrderable | LOGICAL | Logical_False | OPTIONAL | Indicates if a vaccine can be Ordered/Administered |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Procedure | Vaccine.DefaultProcedureCode = Procedure.ProcedureCode | SET NULL if Vaccine exists |
| Child Table | Join Phrase | When deleting Vaccine record... |
|---|---|---|
| PatientVacDose | PatientVacDose.VaccineSID = Vaccine.VaccineSID | RESTRICT if PatientVacDose exists |