Immunization
Introduction
This report returns immunization records by grade for kindergarten, first grade, seventh-grade, and 12th-grade students, based on the selected term.
Students are categorized in the report as follows:
Adequately Immunized - All required doses are recorded and the student is compliant
Conditionally Admitted - The applicable Conditional Admitted fields are selected.
Exempt - Student is not incomplete or conditional and exempt for any vaccine.
An exempt student who has a medical exemption counts toward medical exemptions.
An exempt student with no medical exemptions who has a religious exemption counts toward religious exemptions.
An exempt student with no medical or religious exemptions who has a philosophical/personal exemption counts toward philosophical/personal exemptions.
An undocumented varicella disease history exemption is included in the total for philosophical/personal exemptions.
Incomplete - Student has at least one dose of the specific vaccine but does not have the required number of doses. This is determined based on the age of the student.
No Record - The student has no vaccination dose dates for all vaccines or a specific vaccine.
A student who is not incomplete and is conditional for any vaccine is conditional.
Rules Engine
The Rules Engine is an automatic process that runs nightly (or when an individual student’s immunization data is updated) and updates the compliance status visually on the District Setup > Health page for display purposes only. The only values stored by the rules evaluation process are the overall compliance status for each immunization. Note the following:
The Immunization report is not dependent on the Rules Engine for compliance calculations.
The compliance status displayed on the Student Information page is updated automatically.
The automatically calculated status shown on the Student Immunization Information page does not take into account the Idaho-specific fields used to indicate a conditional enrollment – these students will show as non-compliant, both on the Health page and in the compliance search.
The status values shown on the Student Immunization Information page does not translate directly to the report, regardless of whether it is calculated by the rules engine or manually set.
All compliance rules are calculated and aggregated as part of the report logic. This includes date of birth rules, grade level rules, exemptions, disease history, and conditional enrollment.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
Student Selection
The report selects records from the [Students] and [ReEnrollments] tables based on the following criteria:
The student must have a current or previous school enrollment at the appropriate school within the selected school year.
The student must be active on the user-defined report date.
The student’s grade level on the report date must be 0 (kindergarten), 1, or 7.
To display the count of students that have taken a vaccine, the following criteria must be met:
The Student conditionally admitted checkbox must be selected
One or more of the vaccines must be selected
At least one dose of the selected vaccine must be recorded on the Immunizations page.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Name of Person Completing Report | Enter the name of the person responsible for completing the report. |
Title of Person Completing Report | Enter the title of the person responsible for completing the report. |
E-mail of Person Completing Report | Enter the e-mail address of the person responsible for completing the report. |
Report Date | Enter the report date. |
Report Period | Choose the report period. The school term that appears in the menu is populated dynamically by the Term selected at the top of the page. |
Report Output
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # | Data Element | Description | [Table]FieldName |
1 | Report Period | The school year for which data is reported. This value is manually selected at report runtime. | N/A |
2 | Name of School | The name of the school for which the report is run. | [Schools]Name |
3 | School District # | The name of the school district. | [Prefs]Value [Prefs]Name=districtnumber |
4 | Type of School | The type of school. | [S_ID_SCH_X]PublicSchool [S_ID_SCH_X]PrivateSchool [S_ID_SCH_X]CharterSchool |
5 | Date of Report (MM/DD/YYYY) | The date for which a snapshot of data is collected for the report. This value is entered at report runtime. | N/A |
6 | Name and Title of Person Completing Report | The name and title of the person responsible for completing the report. This value is manually entered at report runtime. | N/A |
7 | E-mail Address | The e-mail address of the person responsible for completing the report. This value is manually entered at report runtime. | N/A |
8 | School Address | The address of the school. | [Schools]SchoolAddress |
9 | City State | The city and state of the school. | [Schools]SchoolCity |
10 | Zip | The zip code of the school. | [Schools]SchoolZip |
11 | County | The county in which the school is located. | [Schools]CountyName |
12 | Phone | The phone number of the school. | [Schools]SchoolPhone |
A. Total number of ADEQUATELY IMMUNIZED students | |||
13 | Total number of children with an immunization record on file at the school documenting that all school required immunizations have been received | The total number of students per grade level who completed all immunizations required by the School Immunization Law (IC 39-4801), will be reported as Adequately Immunized. | [Students]Grade_Level = 0, 1, 7, 12 [HealthStudDoseRec]CompliancyStatus= 0 (Compliant) |
B. Total number of CONDITIONALLY ADMITTED students | |||
14 | Total number of students that were Conditionally Admitted and are currently on schedule for subsequent immunizations. | The total number of students per grade level who were conditionally admitted. | [Students]Grade_Level = 0, 1, 7, 12 [HealthStudDoseRec]Dose [HealthStudDoseRec]DateAdministered [S_ID_STU_X]IMM_Conditional Note: Students must have at least one vaccine dose to be counted as conditionally admitted. |
C. Total number of students with an EXEMPTION on file at the school | |||
15 |
| The total number of students per grade level with a medical exemption for their overall immunization status. | [Students]Grade_Level = 0, 1, 7, 12 [HealthImmExempt]ImmunizationExemptionCode = MedEx |
16 | 2. Of those students with a MEDICAL exemption, how many are exempt from ALL immunizations | The number of students per grade level with a medical exemption who are exempt from all immunizations. | [Students]Grade_Level = 0, 1, 7, 12 [HealthImmExempt]ImmunizationExemptionCode = MedEx (Exemption must exist for all vaccines) |
17 | 3. Total number of students with RELIGIOUS/OTHER exemptions | The total number of students per grade level with a religious or other exemption (such as philosophical or personal exemption) for their overall immunization status. | [Students]Grade_Level = 0, 1, 7, 12 [HealthImmExempt]ImmunizationExemptionCode = RelEx |
17 | 4. Of those students with a RELIGIOUS/OTHER exemption, how many are exempt from ALL immunizations | The number of students per grade level with a religious/other exemption who are exempt from all immunizations | [Students]Grade_Level = 0, 1, 7, 12 [HealthImmExempt]ImmunizationExemptionCode = RelEx (Exemption must exist for all vaccines) |
D. Total number of INCOMPLETE students | |||
18 | Total number of students missing 1+ valid doses of a required vaccine and doesn’t have the still-needed doses scheduled or has failed to follow the Schedule of Intended Immunizations form | The total number of students per grade level with an incomplete immunization status. | [Students]Grade_Level = 0, 1, 7, 12 [HealthStudDoseRec]Dose Note: Students must have at least 1 dose but not the required number of doses and not be exempt or conditionally admitted to count towards this number. |
E. Total number of students with NO RECORD on file at the school | |||
19 | Total number of students who have no immunization record on file at the school | The total number of students per grade level with no immunization records on file. | [Students]Grade_Level = 0, 1, 7, 12 [HealthStudDoseRec]Dose Note: Students must not have any vaccine doses to be counted in this category |
F. TOTAL ENROLLMENT | |||
20 | Total number of students enrolled in each of the following grades (Sum of Sections A+B+C+D+E) | The sum total number of students per grade level for sections A, B, C, D, and E of this report. | Sum of Sections A+B+C+D+E |
G DIPHTHERIA, TETANUS, PERTUSSIS (DTaP, DTP, DT, Td) | |||
21 | Adequately Immunized | The total number of students per grade level adequately immunized with DTaP or have Age Out exemption. | [Students]Grade_Level = 0, 1, 7, 12 [HealthVaccine]VaccineName = DTaP [HealthStudDoseRec]CompliancyStatus = 0 (Compliant) |
22 | Conditionally Admitted | The total number of students per grade level conditionally admitted for DTaP. | [Students]Grade_Level = 0, 1, 7, 12 [HealthVaccine]VaccineName = DTaP [HealthStudDoseRec]Dose [S_ID_STU_X]IMM_Conditional_DTaP Note: Student must have at least one vaccine dose to be counted as conditionally admitted. |
23 | Exempt | The total number of students per grade level exempted from DTaP. | [Students]Grade_Level = 0, 1, 7, 12 [HealthVaccine]VaccineName = DTaP [HealthImmExempt]ImmunizationExemptionCode = MedEx, RelEx |
24 | Incomplete | The total number of students per grade level missing 1+ doses of DTaP. | [Students]Grade_Level = 0, 1, 7, 12 [HealthVaccine]VaccineName = DTaP [HealthStudDoseRec]Dose [HealthStudDoseRec]DateAdministered Note: Students must have at least 1 dose but not the required number of doses and not be exempt or conditionally admitted to count towards this number. |
25 | No Record | The total number of students per grade level with no immunization record. | [Students]Grade_Level = 0, 1, 7, 12 [HealthVaccine]VaccineName = DTaP [HealthStudDoseRec]Dose Note: Students must not have any vaccine doses to be counted in this category |
H. POLIO (IPV, OPV) For the compliance calculation. 1 month is 28 days with an additional four grace days. For example: 6 months is 164 days 6*28=168 - 4 grace days. | |||
26 | Adequately Immunized | The total number of students per grade level adequately immunized with Polio or have Age Out exemption. | [Students]Grade_Level = 0, 1, 7, 12 [HealthVaccine]VaccineName = Polio [HealthStudDoseRec]CompliancyStatus = 0 (Compliant) |
27 | Conditionally Admitted | The total number of students per grade level conditionally admitted for Polio. | [Students]Grade_Level = 0, 1, 7, 12 [HealthVaccine]VaccineName = Polio [HealthStudDoseRec]Dose [S_ID_STU_X]IMM_Conditional_Polio Note: Student must have at least one vaccine dose to be counted as conditionally admitted. |
28 | Exempt | The total number of students per grade level exempted from Polio. | [Students]Grade_Level = 0, 1, 7, 12 [HealthVaccine]VaccineName = Polio [HealthImmExempt]ImmunizationExemptionCode = MedEx, RelEx |
29 | Incomplete | The total number of students per grade level missing 1+ doses of Polio. | [Students]Grade_Level = 0, 1, 7, 12 [HealthVaccine]VaccineName = Polio [HealthStudDoseRec]Dose Note: Students must have at least 1 dose but not the required number of doses and not be exempt or conditionally admitted to count towards this number. |
30 | No Record | The total number of students per grade level with no immunization record. | [Students]Grade_Level = 0, 1, 7, 12 [HealthVaccine]VaccineName = Polio [HealthStudDoseRec]Dose Note: Students must not have any vaccine doses to be counted in this category |
I. MEASLES, MUMPS, RUBELLA (MMR, MMRV) | |||
31 | Adequately Immunized | The total number of students per grade level adequately immunized with MMR or have Age Out exemption. | [Students]Grade_Level = 0, 1, 7, 12 [HealthVaccine]VaccineName = MMR [HealthStudDoseRec]CompliancyStatus = 0 (Compliant) |
32 | Conditionally Admitted | The total number of students per grade level conditionally admitted for MMR. | [Students]Grade_Level = 0, 1, 7, 12 [HealthVaccine]VaccineName = MMR [HealthStudDoseRec]Dose [S_ID_STU_X]IMM_Conditional_MMR Note: Student must have at least one vaccine dose to be counted as conditionally admitted. |
33 | Exempt | The total number of students per grade level exempted from MMR. | [Students]Grade_Level = 0, 1, 7, 12 [HealthVaccine]VaccineName = MMR [HealthImmExempt]ImmunizationExemptionCode = MedEx, RelEx |
34 | Incomplete | The total number of students per grade level missing 1+ doses of MMR. | [Students]Grade_Level = 0, 1, 7, 12 [HealthVaccine]VaccineName = MMR [HealthStudDoseRec]Dose Note: Students must have at least 1 dose but not the required number of doses and not be exempt or conditionally admitted to count towards this number. |
35 | No Record | The total number of students per grade level with no immunization record. | [Students]Grade_Level = 0, 1, 7, 12 [HealthVaccine]VaccineName = MMR [HealthStudDoseRec]Dose Note: Students must not have any vaccine doses to be counted in this category |
J. HEPATITIS B | |||
36 | Adequately Immunized | The total number of students per grade level adequately immunized with Hep B or have Age Out exemption. | [Students]Grade_Level = 0, 1, 7, 12 [HealthVaccine]VaccineName = HepB [HealthStudDoseRec]CompliancyStatus = 0 (Compliant) |
37 | Conditionally Admitted | The total number of students per grade level conditionally admitted for Hep B. | [Students]Grade_Level = 0, 1, 7, 12 [HealthVaccine]VaccineName = HepB [HealthStudDoseRec]Dose [S_ID_STU_X]IMM_Conditional_HepB Note: Student must have at least one vaccine dose to be counted as conditionally admitted. |
38 | Exempt | The total number of students per grade level exempted from Hep B. | [Students]Grade_Level = 0, 1, 7, 12 [HealthVaccine]VaccineName = HepB [HealthImmExempt]ImmunizationExemptionCode = MedEx, RelEx |
39 | Incomplete | The total number of students per grade level missing 1+ doses of Hep B. | [Students]Grade_Level = 0, 1, 7, 12 [HealthVaccine]VaccineName = HepB [HealthStudDoseRec]Dose Note: Students must have at least 1 dose but not the required number of doses and not be exempt or conditionally admitted to count towards this number. |
40 | No Record | The total number of students per grade level with no immunization record. | [Students]Grade_Level = 0, 1, 7, 12, 12 [HealthVaccine]VaccineName = HepB [HealthStudDoseRec]Dose Note: Students must not have any vaccine doses to be counted in this category |
K. VARICELLA (CHICKENPOX) | |||
41 | Adequately Immunized | The total number of students adequately immunized with Varicella or have Age Out exemption. | [Students]Grade_Level = 0, 1, 7 [HealthVaccine]VaccineName = Var [HealthStudDoseRec]CompliancyStatus = 0 (Compliant) |
43 | Conditionally Admitted | The total number of students conditionally admitted for Varicella. | [Students]Grade_Level = 0, 1, 7 [HealthVaccine]VaccineName = Var [HealthStudDoseRec]Dose [S_ID_STU_X]IMM_Conditional_VAR Note: Student must have at least one vaccine dose to be counted as conditionally admitted. |
44 | Exempt (medical, religious, or other) | The total number of students with an exemption claimed for medical, religious, or other reasons. | [Students]Grade_Level = 0, 1, 7 [HealthVaccine]VaccineName = Var [HealthImmExempt]ImmunizationExemptionCode = MedEx, RelEx |
45 | Exempt (history not documented) | The total number of students with an exemption claimed for chickenpox disease history not documented by a physician. | [Students]Grade_Level = 0, 1 [HealthVaccine]VaccineName = Var [HealthImmExempt]ImmunizationExemptionCode = DH |
46 | Incomplete | The total number of students missing 1+ doses of Varicella. | [Students]Grade_Level = 0, 1, 7 [HealthVaccine]VaccineName = Var [HealthStudDoseRec]Dose Note: Students must have at least 1 dose but not the required number of doses and not be exempt or conditionally admitted to count towards this number. |
47 | No Record | The total number of students with no immunization record. | [Students]Grade_Level = 0, 1, 7 [HealthVaccine]VaccineName = Var [HealthStudDoseRec]Dose Note: Students must not have any vaccine doses to be counted in this category |
L. HEPATITIS A | |||
48 | Adequately Immunized | The total number of students adequately immunized with Hep A or have Age Out exemption. | [Students]Grade_Level = 0, 1, 7 [HealthVaccine]VaccineName = HepA [HealthStudDoseRec]CompliancyStatus = 0 (Compliant) |
49 | Conditionally Admitted | The total number of students conditionally admitted for Hep A. | [Students]Grade_Level = 0, 1, 7 [HealthVaccine]VaccineName = HepA [HealthStudDoseRec]Dose [S_ID_STU_X]IMM_Conditional_HepA Note: Student must have at least one vaccine dose to be counted as conditionally admitted. |
50 | Exempt | The total number of students exempted from Hep A. | [Students]Grade_Level = 0, 1, 7 [HealthVaccine]VaccineName = HepA [HealthImmExempt]ImmunizationExemptionCode = MedEx, RelEx |
51 | Incomplete | The total number of students missing 1+ doses of Hep A. | [Students]Grade_Level = 0, 1, 7 [HealthVaccine]VaccineName = HepA [HealthStudDoseRec]Dose Note: Students must have at least 1 dose but not the required number of doses and not be exempt or conditionally admitted to count towards this number. |
52 | No Record | The total number of students with no immunization record. | [Students]Grade_Level = 0, 1, 7 [HealthVaccine]VaccineName = HepA [HealthStudDoseRec]Dose Note: Students must not have any vaccine doses to be counted in this category |
M. TETANUS, DIPHTHERIA, PERTUSSIS BOOSTER (Tdap) | |||
53 | Adequately Immunized | The total number of seventh grade and 12th grade students is adequately immunized with Tdap or have Age Out exemption. | [Students]Grade_Level = 7, 12 [HealthVaccine]VaccineName = Tdap [HealthStudDoseRec]CompliancyStatus = 0 (Compliant) |
54 | Exempt | The total number of seventh grade and 12th grade students exempted from Tdap. | [Students]Grade_Level = 7, 12 [HealthVaccine]VaccineName = Tdap [HealthImmExempt]ImmunizationExemptionCode = MedEx, RelEx |
N. MENINGOCOCCAL (Menacra (MCV4), Menomune (MPSV4)) | |||
55 | Adequately Immunized | The total number of 7th grade and 12th grade students adequately immunized with Meningococcal or have Age Out exemption. | [Students]Grade_Level = 7, 12 [HealthVaccine]VaccineName = Men [HealthStudDoseRec]CompliancyStatus = 0 (Compliant) |
56 | Conditionally Admitted | The total number of students conditionally admitted for Men. | [Students]Grade_Level = 7, 12 [HealthVaccine]VaccineName = Men [HealthStudDoseRec]Dose [S_ID_STU_X]IMM_Conditional_Men Note: Student must have at least one vaccine dose to be counted as conditionally admitted. |
58 | Exempt | The total number of 7th and 12th grade students exempted from Meningococcal. | [Students]Grade_Level = 7, 12 [HealthVaccine]VaccineName = Men [HealthImmExempt]ImmunizationExemptionCode = MedEx, RelEx |
59 | Incomplete | The total number of 7th and 12th grade students missing the single dose of Meningococcal. | [Students]Grade_Level = 7, 12 [HealthVaccine]VaccineName = Men [HealthStudDoseRec]Dose Note: Students must have at least 1 dose but not the required number of doses and not be exempt or conditionally admitted to count towards this number. |
61 | No Record | The total number of 7th and 12th grade students with no immunization record. | [Students]Grade_Level = 7, 12 [HealthVaccine]VaccineName = Men [HealthStudDoseRec]Dose Note: Students must not have any vaccine doses to be counted in this category |
62 | Incomplete | The total number of 7th and 12th grade students missing the single dose of Tdap. Note: This row pertains to Tdap but appears under the Meningococcal section because that's how it apepars in the state specifications/layout. This is presumably a mistake and if the state corrects it, this report (in PowerSchool) will be corrected as well. | [Students]Grade_Level = 7, 12 [HealthVaccine]VaccineName = Tdap [HealthStudDoseRec]Dose Note: Students must have at least 1 dose but not the required number of doses and not be exempt or conditionally admitted to count towards this number. |
63 | No Record | The total number of 7th and 12th grade students missing all doses of Tdap. Note: This row pertains to Tdap but appears under the Meningococcal section because that's how it apepars in the state specifications/layout. This is presumably a mistake and if the state corrects it, this report (in PowerSchool) will be corrected as well. | [Students]Grade_Level = 7, 12 [HealthVaccine]VaccineName = Tdap [HealthStudDoseRec]Dose Note: Students must not have any vaccine doses to be counted in this category |