Section E Mapping
Following are explanations of the data sources for the Section E report totals with grade Pre-K only.
When running the report for Section E, ensure to add the corresponding Pre-Kindergarten grade in the Pre School/Day Care/Head Start Grades prompt of the PR Medical Card page.
Report Field | eSchoolPlus Table.Column | Where in eSchoolPlus? |
---|---|---|
Name of school or program | N/A | Regulatory > Report > OR Medical Card Report This value is taken from the prompts when the report is run. |
Date of report | N/A | Regulatory > Report > OR Medical Card Report This date value is taken from the prompts when the report is run. |
1. How many children younger than kindergarten were | Count of students with reg_programs.field_value = Y where program_id = ORIMM and grade is (taken from "Pre School/Day Care/Head Start Grades" Prompt). | Registration > Entry & Reports > Student Demographic > Programs > OR Immunizations |
2. What is your total enrollment? | Count of students where reg_entry_with.building is the prompted building when you ran the report. Note: Takes count from all buildings within prompts dates. | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > Entry/Withdrawal Details |
3. How many children are not counted? | Count of students enrolled in Program 'ORIMM' within the prompted start date to end date range. | Registration > Entry & Reports > Student Demographic > Programs > OR Immunizations |
4. How many children are 18 months or younger? | Count of students in the prompted building where age is less than or equal to 1 year and 6 months as of the prompted End Date. Based on reg.birthdate | Calculated |
5. What is your adjusted enrollment? | N/A | Calculated Total Enrollment – Children not counted. |
6. How many children have no record? | Count of students where med_general.immune_status = 'NR'. | Medical > All > Student > Immunizations Student Status |
7. How many children have a medical exemption? | Count of students where med_general.immune_exempt = 'M'. | Medical > All > Student > Immunizations Student Status |
8. How many children have a nonmedical exemption? | Count of students where med_general.immune_exempt = 'NMHP'. | Medical > All > Student > Immunizations Student Status |
9. How many nonmedical exemptions are from the online module? | Count of students where med_general.immune_exempt = 'NMEM'. | Medical > All > Student > Immunizations Student Status |
9. How many nonmedical exemptions are from a health care practitioner? | Count of students where med_general.immune_exempt = 'NMHP'. | Medical > All > Student > Immunizations Student Status |
Number of children with vaccines DTaP (4 or more doses) | Count of students where med_series.series_status = 'CO' or 'DS' for series_code that maps to medtb_shot.state_code_equiv = 'DTAP'. | Medical > All > Student > Immunizations Student Status |
Number of children with vaccines Polio (3 or more doses) | Count of students where med_series.series_status = 'CO' or 'DS' for series_code that maps to medtb_shot.state_code_equiv = 'POLIO'. | Medical > All > Student > Immunizations Student Status |
Number of children with vaccines Varicella (1 or more dose or | Count of students where med_series.series_status = 'CO' or 'DS' for series_code that maps to medtb_shot.state_code_equiv = 'VAR'. | Medical > All > Student > Immunizations Student Status |
Number of children with vaccines MMR (1 or more dose) | Count of students where med_series.series_status = 'CO' or 'DS' for series_code that maps to medtb_shot.state_code_equiv = 'MMR'. | Medical > All > Student > Immunizations Student Status |
Number of children with vaccines Hepatitis B (3 or more doses) | Count of students where med_series.series_status = 'CO' or 'DS' for series_code that maps to medtb_shot.state_code_equiv = 'HEPB'. | Medical > All > Student > Immunizations Student Status |
Number of children with vaccines Hepatis A (1 or more dose) | Count of students where med_series.series_status = 'CO' or 'DS' for series_code that maps to medtb_shot.state_code_equiv = 'HEPA'. | Medical > All > Student > Immunizations Student Status |
Number of children with vaccines Hib (Complete for Hib, or the child | Count of students where med_series.series_status = 'CO' or 'DS' for series_code that maps to medtb_shot.state_code_equiv = 'HIB' or Child is 5 years old or older. | Medical > All > Student > Immunizations Student Status |
Number of children with vaccines All (Child has all the above doses) | Count of students where med_series.series_exemption maps to med_series.series_status in ('CO') for all med_series.series_code that maps to medtb_shot.state_code_equiv listed above. | Medical > All > Student > Immunizations Student Status |
DTaP nonmedical exemptions | 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 Status |
Polio nonmedical exemptions | 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 Status |
Varicella nonmedical exemptions | 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 Status |
MMR nonmedical exemptions | Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'MMR', 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 Status |
Hepatitis B nonmedical exemptions | 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 Status |
Hepatitis A nonmedical exemptions | 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 Status |
Hib nonmedical exemptions | Count of students where med_series.series_code that maps to medtb_shot.state_code_equiv = 'HIB', 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 Status |
All (Child has a nonmedical exemption for all vaccines) | 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 Status |