PSRW_HealthImmunizationDoses (ver7.0.1)
This view contains a student's health immunization doses data.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Certificate_Type_C ode | 7.0.1 | String | [From HealthImmSource] ImmunizationSourceCode indicates the code for the certified source of the vaccine. |
Certificate_Type_Name | 7.0.1 | String | [From HealthImmSource] ImmunizationSourceName indicates the name of the certified source of the vaccine. |
Certificate_Type_State_Code | 7.0.1 | String | [From HealthImmSource] StateReportCode indicates the state certificate code for the certified source of the vaccine. |
Certificate_Type_State_Name | 7.0.1 | String | [From HealthImmSource] StateReportName indicates the state certificate name for the source of the vaccine. |
Compliancy_Statement | 7.0.1 | String | [From HealthStudDoseRec] DoseCompliancyStatement indicates the system- generated message regarding compliancy of the specific dose number. |
Compliancy_Status | 7.0.1 | String | [From HealthStudDoseRec] CompliancyStatus indicates the system-generated message regarding compliancy of the specific dose number with possible values: Compliant, Not Compliant, Null. |
Dose_Date_Administered | 7.0.1 | Date | [From HealthStudDoseRec] DateAdministered indicates when the dose was administered. |
Dose_Date_Recorded | 7.0.1 | Date | [From HealthStudDoseRec] WhenModified or WhenCreated indicates when the dose was recorded or last edited in the system. |
Dose_Number | 7.0.1 | Number | [From HealthStudDoseRec] Dose sequence number. |
Is_Default_Certificate_Type | 7.0.1 | String | [From HealthImmSource] IsDefaultSource used to flag the certificate as the default certificate for a vaccine dose. |
ID | 7.0.1 | Number | [From HealthStudDoseRec] ID indicates the unique internal identifier for the dose of a specific vaccine for a student. |
Imm_Source_ID | 7.0.1 | Number | [From HealthStudDoseRec] HealthImmSourceID indicates the unique internal identifier for the immunization source. |
StudentID | 7.0.1 | Number | [From HealthStudDoseRec] StudentID indicates the unique internal identifier for the student. |
Student_Imm_Record_ID | 7.0.1 | Number | [From HealthStudDoseRec] HealthStudImmRecID indicates the unique internal identifier for the student immunization record of a specific vaccine. |
Vaccine_ID | 7.0.1 | Number | [From HealthStudDoseRec] HealthVaccineID indicates unique internal identifier for the vaccine. |
Vaccine_Name | 7.0.1 | String | [From HealthVaccine] VaccineName indicates the name of the vaccine for immunization. |
Vaccine_Sort_Order | 7.0.1 | Number | [From HealthVaccine] DislayOrder used for displaying vaccines in an order. |
Vaccine_Dose_Count | 7.0.1 | Number | [From HealthVaccine] NumberOfDoses used for storing the number of doses that vaccination must be performed. |