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 |