PSRW_HealthImmunization (ver6.2.0)
This view contains a student's health immunization data.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Administered_Dose_Count | 6.2.0 | Number | Calculated data from HealthStudDoseRec. DateAdministered indicates how many doses have been administered for any vaccine. |
Compliance_Status | 6.2.0 | Number | [From HealthStudImmRec] ComplianceStatus indicates if student for a vaccine is in compliance. |
Exemption_Code | 6.2.0 | String30 | [From HealthImmExempt] ImmunizationExemptionCode indicates the code of an exemption. |
Exemption_Reason | 6.2.0 | String50 | [From HealthImmExempt] ImmunizationExemptionName indicates the reason of the exemption. |
Exemption_State_Code | 6.2.0 | String30 | [From HealthImmExempt] StateReportCode as state specific code value for the exemption. |
Exemption_State_Reason | 6.2.0 | String50 | [From HealthImmExempt] StateReportName as a state specific name of exemption. |
Exemption_Status | 6.2.0 | Number | [From HealthImmExempt] Indicates if the immunization exemption is expired. |
ID | 6.2.0 | Number | [From HealthStudImmRec] Unique ID for record. |
Immunization_Comment | 6.2.0 | String512 | [From HealthStudImmRec] Text that stores comment for each immunization. |
StudentID | 6.2.0 | Number | [From HealthStudImmRec] StudentID. |
Vaccine_Code | 6.2.0 | String30 | [From HealthVaccine] VaccineCode used for the code that vaccine is assigned. |
Vaccine_Compliance_Mode | 6.2.0 | Integer | [From HealthVaccine] IsRulesReady. |
Vaccine_Description | 6.2.0 | String512 | [From HealthVaccine] VaccineDesc to store detailed description of the vaccine. |
Vaccine_Dose_Count | 6.2.0 | Number | [From HealthVaccine] NumberOfDoses used for storing the number of doses that vaccination must be performed. |
Vaccine_ID | 6.2.0 | Number | [From HealthVaccine] VaccineID. |
Vaccine_MandatoryOptional | 6.2.0 | Integer | [From HealthVaccine] IsMandatory that indicates if a vaccine is mandatory or optional. |
Vaccine_Name | 6.2.0 | String50 | [From HealthVaccine] Name of the vaccine for immunization. |
Vaccine_Sort_Order | 6.2.0 | Number | [From HealthVaccine] DisplayOrder used for displaying vaccines in an order. |
Vaccine_State_Code | 6.2.0 | String30 | [From HealthVaccine] StateReportCode stores State code of the vaccine. |
Vaccine_State_Name | 6.2.0 | String50 | [From HealthVaccine] StateReportName stores State name of the vaccine. |