Report Mapping and Calculations

Number of Students Enrolled

Adjusted Enrollment from Section H

Percent of students with no immunization or exemption record

(Count of students with reg_programs.field_value = Y where program_id = ORIMM. Registration > Entry & Reports > Student District Defined > OR Immunization Exclusion divided by Adjusted Enrollment) x 100

Percent of students with a medical exemption to one or more vaccine

(Count of students where med_general.immune_exempt = 'M' divided by Adjusted Enrollment) x 100

DTaP/Tdap – Percent Vaccinated

[(Count of students where med_series.series_status = 'CO' or 'DS' for series_code that maps to medtb_shot.state_code_equiv = 'DTAP') + (Count of students where med_series.series_status = 'CO' or 'DS' for series_code that maps to medtb_shot.state_code_equiv = 'TDAP') divided by Adjusted Enrollment] x 100

DTaP/Tdap – Percent missing one or more doses due to nonmedical exemption

(For med_series.series_code that maps to medtb_shot.state_code_equiv = 'DTAP', find count of students where med_series.series_exemption = 'NMEM' or 'NMHP' divided by Adjusted Enrollment) x 100

Polio – Percent Vaccinated

(Count of students where med_series.series_status = 'CO' or 'DS' for series_code that maps to medtb_shot.state_code_equiv = 'POLIO' divided by Adjusted Enrollment) x 100

Polio – Percent missing one or more doses due to nonmedical exemption

(For med_series.series_code that maps to medtb_shot.state_code_equiv = 'POLIO', find count of students where med_series.series_exemption = 'NMEM' or 'NMHP' divided by Adjusted Enrollment) x 100

Varicella – Percent Vaccinated

(Count of students where med_series.series_status = 'CO' or 'DS' for series_code that maps to medtb_shot.state_code_equiv = 'VAR'
divided by Adjusted Enrollment) x 100

Varicella – Percent missing one or more doses due to nonmedical exemption

(For med_series.series_code that maps to medtb_shot.state_code_equiv = 'VAR', find count of students where med_series.series_exemption = 'NMEM' or 'NMHP' divided by Adjusted Enrollment) x 100

Measles – Percent Vaccinated

(Count of students where med_series.series_status = 'CO' or 'DS' for series_code that maps to medtb_shot.state_code_equiv = 'MEASLES'
divided by Adjusted Enrollment) x 100

Measles – Percent missing one or more doses due to nonmedical exemption

(For med_series.series_code that maps to medtb_shot.state_code_equiv = 'MEASLES', find count of students where med_series.series_exemption = 'NMEM' or 'NMHP' divided by Adjusted Enrollment) x 100

Mumps – Percent Vaccinated

(Count of students where med_series.series_status = 'CO' or 'DS' for series_code that maps to medtb_shot.state_code_equiv = 'MUMPS'
divided by Adjusted Enrollment) x 100

Mumps – Percent missing one or more doses due to nonmedical exemption

(For med_series.series_code that maps to medtb_shot.state_code_equiv = 'MUMPS', find count of students where med_series.series_exemption = 'NMEM' or 'NMHP' divided by Adjusted Enrollment) x 100

Rubella – Percent Vaccinated

(Count of students where med_series.series_status = 'CO' or 'DS' for series_code that maps to medtb_shot.state_code_equiv = 'RUBELLA'
divided by Adjusted Enrollment) x 100

Rubella – Percent missing one or more doses due to nonmedical exemption

(For med_series.series_code that maps to medtb_shot.state_code_equiv = 'RUBELLA', find count of students where med_series.series_exemption = 'NMEM' or 'NMHP' divided by Adjusted Enrollment) x 100

Hep B – Percent Vaccinated

(Count of students where med_series.series_status = 'CO' or 'DS' for series_code that maps to medtb_shot.state_code_equiv = 'HEPB'
divided by Adjusted Enrollment) x 100

Hep B – Percent missing one or more doses due to nonmedical exemption

(For med_series.series_code that maps to medtb_shot.state_code_equiv = 'HEPB', find count of students where med_series.series_exemption = 'NMEM' or 'NMHP' divided by Adjusted Enrollment) x 100

Hep A – Percent Vaccinated

(Count of students where med_series.series_status = 'CO' or 'DS' for series_code that maps to medtb_shot.state_code_equiv = 'HEPA'
divided by Adjusted Enrollment) x 100

Hep A – Percent missing one or more doses due to nonmedical exemption

(For med_series.series_code that maps to medtb_shot.state_code_equiv = 'HEPA', find count of students where med_series.series_exemption = 'NMEM' or 'NMHP' divided by Adjusted Enrollment) x 100

All Vaccines – Percent Vaccinated

(Count of students where med_general.immune_status = 'CO' divided by Adjusted Enrollment) x 100

All Vaccines – Percent missing one or more doses due to nonmedical exemption

(Count of students where med_series.series_exemption = 'NMEM' or 'NMHP' for all state_code_equivs listed above divided by Adjusted Enrollment) x 100

Students enrolled for whom immunizations are not required (tracked by another district or attend fewer than 5 days per year)

Count of students with reg_programs.field_value = Y where program_id = ORIMM. Registration > Entry & Reports > Student District Defined > OR Immunization Exclusion.