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
|
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 |