Sections F, G, and H Report Mapping
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') For Grades 07-12: 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') | 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 |