Following are the data sources for the Sections F and G report totals.
How many students in grades K-12 were excluded on Exclusion Day?
Count of students where reg_programs.program_id = 'ORIMM'(OR Immunization Exclusion Program screen) and reg_programs.field_value = Y and reg_grade.state_code_equiv in ('KG', '01', '02', '03', '04', '05', '06','07', '08', '09', '10', '11', '12').
Takes count from all buildings within prompts dates.
|
Report Field |
Section F: Kindergarten (reg_entry_with.grade where reg_grade.state_code_equiv is KG) eSchoolPlus Table.Column |
Section G: Seventh Grade (reg_entry_with.grade where reg_grade.state_code_equiv is 07) eSchoolPlus Table.Column |
Section H: Full School Grades K-12 (including the students in Sections F and G). eSchoolPlus Table.Column |
Where in eSchoolPlus? |
|---|---|---|---|---|
|
Name of school or program |
N/A |
N/A |
N/A |
Regulatory > Report > OR Medical Card Report This value is taken from the prompts when the report is run. |
|
Grades |
reg_entry_with where building= (this value is taken from the prompts when the report is run) |
reg_entry_with where building= (this value is taken from the prompts when the report is run) |
reg_entry_with where building= (this value is taken from the prompts when the report is run) |
Registration > Entry & Reports > Student Demographic > Entry/Withdrawal |
|
Date of report |
N/A |
N/A |
N/A |
Regulatory > Report > OR Medical Card Report This date value is taken from the prompts when the report is run. |
|
Total Enrollment |
Count of students where reg_entry_with.building is the prompted building when you ran the report. |
Count of students where reg_entry_with.building is the prompted building when you ran the report. |
Count of students where reg_entry_with.building is the prompted building when you ran the report. |
Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > Entry/Withdrawal Details |
|
Students not counted |
Count of students with reg_programs.field_value = Y where program_id = ORIMM.
|
Count of students with reg_programs.field_value = Y where program_id = ORIMM.
|
Count of students with reg_programs.field_value = Y where program_id = ORIMM.
|
Registration > Entry & Reports > Student District Defined > OR Immunization Exclusion. |
|
Adjusted enrollment |
N/A |
N/A |
N/A |
Calculated Total Enrollment – Students not counted |
|
No record |
Count of students where med_general.immune_status = 'NR' |
Count of students where med_general.immune_status = 'NR' |
Count of students where med_general.immune_status = 'NR' |
Medical > All > Student > Immunizations > Student Immunizations Student Status |
|
Medical exemptions |
Count of students where med_general.immune_exempt = 'M' |
Count of students where med_general.immune_exempt = 'M' |
Count of students where med_general.immune_exempt = 'M' |
Medical > All > Student > Immunizations > Student Immunizations Student Exemption |
|
Nonmedical exemptions |
Count of students where med_series.series_exemption = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Count of students where med_series.series_exemption = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Count of students where med_series.series_exemption = 'NMEM' or 'NMHP' and med_series.series_status in ('EX') |
Medical > All > Student > Immunizations > Student Immunizations Student Exemption |
|
Nonmedical exemptions from the online module |
Count of students where med_series.series_exemption = 'NMEM' and med_series.series_status in ('EX') |
Count of students where med_series.series_exemption = 'NMEM' and med_series.series_status in ('EX') |
Count of students where med_series.series_exemption = 'NMEM' and med_series.series_status in ('EX') |
Medical > All > Student > Immunizations > Student Immunizations Student Exemption |
|
Nonmedical exemptions from a healthcare practitioner |
Count of students where med_series.series_exemption = 'NMHP' and med_series.series_status in ('EX') |
Count of students where med_series.series_exemption = 'NMHP' and med_series.series_status in ('EX') |
Count of students where med_series.series_exemption = 'NMEM' and med_series.series_status in ('EX') |
Medical > All > Student > Immunizations > Student Immunizations Student Exemption |
|
DTaP: Grades K-6: 5 doses, or 4 if the last dose is given on or after the 4th birthday: or Tdap: Grades 7-12: 1 dose Tdap |
Count of students where med_series.series_status = 'CO' or 'DS' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'DTAP' |
Count of students where med_series.series_status = 'CO' or 'DS' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'TDAP' |
For Grades K-06: Count of students where med_series.series_status = 'CO' or 'DS' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'DTAP' For Grades 07-12: Count of students where med_series.series_status = 'CO' or 'DS' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'TDAP' |
Medical > All > Student > Immunizations > Student Immunizations Vaccination Summary |
|
Polio: 4 doses, or 3 if the last dose is given on or after the 4th birthday |
Count of students where med_series.series_status = 'CO' or 'DS' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'POLIO' |
Count of students where med_series.series_status = 'CO' or 'DS' or 'NA' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'POLIO' |
For Garde K-06B Count of students where med_series.series_status = 'CO' or 'DS' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'POLIO' For Garde 07-12: Count of students where med_series.series_status = 'CO' or 'DS' or 'NA' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'POLIO' |
Medical > All > Student > Immunizations > Student Immunizations Vaccination Summary |
|
Varicella: 1 or more doses, or history of chickenpox disease |
Count of students where med_series.series_status = 'CO' or 'DS' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'VAR' |
Count of students where med_series.series_status = 'CO' or 'DS' or 'NA' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'VAR' |
For Garde K-06: Count of students where med_series.series_status = 'CO' or 'DS' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'VAR' For Garde 07:12: Count of students where med_series.series_status = 'CO' or 'DS' or 'NA' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'VAR' |
Medical > All > Student > Immunizations > Student Immunizations Vaccination Summary |
|
MMR: 1 or more dose |
Count of students where med_series.series_status = 'CO' or 'DS' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'MMR' |
Count of students where med_series.series_status = 'CO' or 'DS' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'MMR' |
Count of students where med_series.series_status = 'CO' or 'DS' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'MMR' |
Medical > All > Student > Immunizations > Student Immunizations Vaccination Summary |
|
Measles: 2 doses |
Count of students where med_series.series_status = 'CO' or 'DS' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'MEASLES' |
Count of students where med_series.series_status = 'CO' or 'DS' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'MEASLES' |
Count of students where med_series.series_status = 'CO' or 'DS' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'MEASLES' |
Medical > All > Student > Immunizations > Student Immunizations Vaccination Summary |
|
Mumps |
N/A |
N/A |
N/A |
N/A |
|
Rubella |
N/A |
N/A |
N/A |
N/A |
|
Hepatitis B: 3 doses |
Count of students where med_series.series_status = 'CO' or 'DS' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'HEPB' |
Count of students where med_series.series_status = 'CO' or 'DS' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'HEPB' |
Count of students where med_series.series_status = 'CO' or 'DS' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'HEPB' |
Medical > All > Student > Immunizations > Student Immunizations Vaccination Summary |
|
Hepatitis A: 2 doses |
Count of students where med_series.series_status = 'CO' or 'DS' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'HEPA' |
Count of students where med_series.series_status = 'CO' or 'DS' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'HEPA' |
Count of students where med_series.series_status = 'CO' or 'DS' and med_series.series_code that maps to medtb_shot.state_code_equiv = 'HEPA' |
Medical > All > Student > Immunizations > Student Immunizations Vaccination Summary |
|
All: Student has all vaccines |
Count of students where med_general.immune_status = 'CO' or 'DS' |
Count of students where med_general.immune_status = 'CO' or 'DS' |
Count of students where med_general.immune_status = 'CO' or 'DS' |
Medical > All > Student > Immunizations > Student Immunizations Student Status |
|
Students with DTap/Tdap non-medical exemption |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'DTAP', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'TDAP', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
For Grades K-06: Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'DTAP', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX')
|
Medical > All > Student > Immunizations > Student Immunizations Vaccination Summary |
|
Students with Polio non-medical exemption |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'POLIO', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'POLIO', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'POLIO', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Medical > All > Student > Immunizations > Student Immunizations Vaccination Summary |
|
Students with Varicella non-medical exemption |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'VAR', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'VAR', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'VAR', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Medical > All > Student > Immunizations > Student Immunizations Vaccination Summary |
|
Students with MMR non-medical exemption |
N/A |
N/A |
N/A |
N/A |
|
Students with Measles non-medical exemption |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'MEASLES', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'MEASLES', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'MEASLES', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Medical > All > Student > Immunizations > Student Immunizations Vaccination Summary |
|
Students with Mumps non-medical exemption |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'MUMPS', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'MUMPS', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'MUMPS', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Medical > All > Student > Immunizations > Student Immunizations Vaccination Summary |
|
Students with Rubella non-medical exemption |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'RUBELLA', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'RUBELLA', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'RUBELLA', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Medical > All > Student > Immunizations > Student Immunizations Vaccination Summary |
|
Students with Hep B non-medical exemption |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'HEPB', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'HEPB', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'HEPB', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Medical > All > Student > Immunizations > Student Immunizations Vaccination Summary |
|
Students with Hep A non-medical exemption |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'HEPA', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'HEPA', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'HEPA', med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') |
Medical > All > Student > Immunizations > Student Immunizations Vaccination Summary |
|
All: Student has all non-medical exemptions |
Count of students where med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') for all med_series.series_code that maps to medtb_shot.state_code_equiv listed above |
Count of students where med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM', or 'NMHP' and med_series.series_status in ('EX') for all med_series.series_code that maps to medtb_shot.state_code_equiv listed above |
Count of students where med_series.series_exemption that maps to medtb_exempt.state_code_equiv = 'NMEM' or 'NMHP' and med_series.series_status in ('EX') for all med_series.series_code that maps to medtb_shot.state_code_equiv listed above |
Medical > All > Student > Immunizations > Student Immunizations Vaccination Summary |