Section A Report Mapping
Following are explanations of the data sources for the Section A report totals with grades in ('KG', '01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12').
Report Field | eSchoolPlus Table.Column | Where in eSchoolPlus? |
|---|---|---|
| Name of school or program | N/A | This value is taken from the prompts when the report is run. |
| Date of report | N/A | 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. | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > Entry/Withdrawal Details |
| Children 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 |
| Adjusted Enrollment | N/A | Calculated Total Enrollment – Children not counted. |
Number complete or up-to-date | med_general.immune_status = 'EX' and medtb_exempt.state_code_equiv NOT IN ('M','N','R','NMEM','NMHP','T') | Medical > All > Student > Immunizations Student Status |
Number nonmedical exemptions | med_general.immune_exempt = 'NMEM', or 'NMHP'. | Medical > All > Student > Immunizations Student Status |
Number permanent medical exemptions | med_general.immune_exempt = 'M' | Medical > All > Student > Immunizations Student Status |
Number temporary medical exemptions | med_general.immune_exempt = 'N' | Medical > All > Student > Immunizations Student Status |
Number incomplete/insufficient | med_general.immune_exempt = 'OV' or 'IS' | Medical > All > Student > Immunizations Student Status |
Number no record | med_general.immune_status = 'NR' | Medical > All > Student > Immunizations Student Status |