EHI Export Schema
PersonVaccination
Table listing vaccinations received by patients.
Column Name | Data Type | Constraint Type | Is Nullable |
---|---|---|---|
PersonVaccinationId | int | PK | NO |
PersonId | int | FK | YES |
VaccineId | int | FK | YES |
VaccineFreeText | varchar(100) | YES | |
VaccineDate | datetime | YES | |
EstimatedDate | bit | YES | |
Created | datetime | YES | |
CreatedBy | varchar(100) | YES | |
Modified | datetime | YES | |
ModifiedBy | varchar(100) | YES | |
Deleted | datetime | YES | |
DeletedBy | varchar(100) | YES | |
SmartVaccineId | varchar(50) | YES |