~[wc:commonscripts] ~[wc:admin_header_css]~[text:psx.html.admin_reports.runreports.start_page] > ~[text:psx.html.admin_reports.runreports.reports] > Enrollment Summary Reports > Projected Enrollment Summary~[wc:admin_navigation_css]

Projected Enrollment Summary

Projected Next Year Enrollment Summary as of ~[eaodate]
  • This report is for the next school year not the current year
  • This report pulls it's data from the "Schedule This Student", "Next Year Grade" and the "Next School Indicator" fields on the Scheduling Setup screen
  • If a student does not have the Schedule This Student checkbox marked that student will not appear on this report!
  • Pre-registered students need to have the grade level which they will be in next year entered on that screen as their "Next Year Grade" for this report to pull accurate enrollment numbers
  • After the end of year process is run this report will no longer be accurate


  • ~[tlist_sql; SELECT Schools.Name AS School, Schools.School_Number AS School_Number, SUM ( CASE WHEN Students.Sched_NextYearGrade = -3 THEN 1 ELSE NULL END ) AS Minus_Three, SUM ( CASE WHEN Students.Sched_NextYearGrade = -2 THEN 1 ELSE NULL END ) AS Minus_Two, SUM ( CASE WHEN Students.Sched_NextYearGrade = -1 THEN 1 ELSE NULL END ) AS Minus_One, SUM ( CASE WHEN Students.Sched_NextYearGrade = 0 THEN 1 ELSE NULL END ) AS K, SUM ( CASE WHEN Students.Sched_NextYearGrade = 1 THEN 1 ELSE NULL END ) AS One, SUM ( CASE WHEN Students.Sched_NextYearGrade = 2 THEN 1 ELSE NULL END ) AS Two, SUM ( CASE WHEN Students.Sched_NextYearGrade = 3 THEN 1 ELSE NULL END ) AS Three, SUM ( CASE WHEN Students.Sched_NextYearGrade = 4 THEN 1 ELSE NULL END ) AS Four, SUM ( CASE WHEN Students.Sched_NextYearGrade = 5 THEN 1 ELSE NULL END ) AS Five, SUM ( CASE WHEN Students.Sched_NextYearGrade = 6 THEN 1 ELSE NULL END ) AS Six, SUM ( CASE WHEN Students.Sched_NextYearGrade = 7 THEN 1 ELSE NULL END ) AS Seven, SUM ( CASE WHEN Students.Sched_NextYearGrade = 8 THEN 1 ELSE NULL END ) AS Eight, SUM ( CASE WHEN Students.Sched_NextYearGrade = 9 THEN 1 ELSE NULL END ) AS Nine, SUM ( CASE WHEN Students.Sched_NextYearGrade = 10 THEN 1 ELSE NULL END ) AS Ten, SUM ( CASE WHEN Students.Sched_NextYearGrade = 11 THEN 1 ELSE NULL END ) AS Eleven, SUM ( CASE WHEN Students.Sched_NextYearGrade = 12 THEN 1 ELSE NULL END ) AS Twelve, SUM ( CASE WHEN Students.Sched_NextYearGrade = 13 THEN 1 ELSE NULL END ) AS Thirteen, SUM ( CASE WHEN Students.Sched_NextYearGrade < 99 THEN 1 ELSE NULL END ) AS Total, Schools.SortOrder FROM Students INNER JOIN Schools ON Schools.School_Number = Students.Next_School WHERE ( Students.Enroll_Status = 0 OR Students.EntryDate > TO_DATE('~[eaodate]','MM-DD-YY') ) AND Students.Sched_NextYearGrade < 99 AND Students.Sched_Scheduled = 1 GROUP BY Schools.Name, Schools.School_Number, Schools.SortOrder ORDER BY Schools.SortOrder;alternatecolor] [/tlist_sql] ~[tlist_sql; SELECT 'Students With No Next School' AS School, SUM ( CASE WHEN Students.Sched_NextYearGrade = -3 THEN 1 ELSE NULL END ) AS Minus_Three, SUM ( CASE WHEN Students.Sched_NextYearGrade = -2 THEN 1 ELSE NULL END ) AS Minus_Two, SUM ( CASE WHEN Students.Sched_NextYearGrade = -1 THEN 1 ELSE NULL END ) AS Minus_One, SUM ( CASE WHEN Students.Sched_NextYearGrade = 0 THEN 1 ELSE NULL END ) AS K, SUM ( CASE WHEN Students.Sched_NextYearGrade = 1 THEN 1 ELSE NULL END ) AS One, SUM ( CASE WHEN Students.Sched_NextYearGrade = 2 THEN 1 ELSE NULL END ) AS Two, SUM ( CASE WHEN Students.Sched_NextYearGrade = 3 THEN 1 ELSE NULL END ) AS Three, SUM ( CASE WHEN Students.Sched_NextYearGrade = 4 THEN 1 ELSE NULL END ) AS Four, SUM ( CASE WHEN Students.Sched_NextYearGrade = 5 THEN 1 ELSE NULL END ) AS Five, SUM ( CASE WHEN Students.Sched_NextYearGrade = 6 THEN 1 ELSE NULL END ) AS Six, SUM ( CASE WHEN Students.Sched_NextYearGrade = 7 THEN 1 ELSE NULL END ) AS Seven, SUM ( CASE WHEN Students.Sched_NextYearGrade = 8 THEN 1 ELSE NULL END ) AS Eight, SUM ( CASE WHEN Students.Sched_NextYearGrade = 9 THEN 1 ELSE NULL END ) AS Nine, SUM ( CASE WHEN Students.Sched_NextYearGrade = 10 THEN 1 ELSE NULL END ) AS Ten, SUM ( CASE WHEN Students.Sched_NextYearGrade = 11 THEN 1 ELSE NULL END ) AS Eleven, SUM ( CASE WHEN Students.Sched_NextYearGrade = 12 THEN 1 ELSE NULL END ) AS Twelve, SUM ( CASE WHEN Students.Sched_NextYearGrade = 13 THEN 1 ELSE NULL END ) AS Thirteen, SUM ( CASE WHEN Students.Sched_NextYearGrade < 99 THEN 1 ELSE NULL END ) AS Total FROM Students WHERE ( Students.Enroll_Status = 0 OR Students.EntryDate > TO_DATE('~[eaodate]','MM-DD-YY') ) AND Students.Sched_NextYearGrade < 99 AND Students.Next_School < 1 AND Students.Sched_Scheduled = 1] [/tlist_sql] ~[tlist_sql; SELECT 'Total' AS School, SUM ( CASE WHEN Students.Sched_NextYearGrade = -3 THEN 1 ELSE NULL END ) AS Minus_Three, SUM ( CASE WHEN Students.Sched_NextYearGrade = -2 THEN 1 ELSE NULL END ) AS Minus_Two, SUM ( CASE WHEN Students.Sched_NextYearGrade = -1 THEN 1 ELSE NULL END ) AS Minus_One, SUM ( CASE WHEN Students.Sched_NextYearGrade = 0 THEN 1 ELSE NULL END ) AS K, SUM ( CASE WHEN Students.Sched_NextYearGrade = 1 THEN 1 ELSE NULL END ) AS One, SUM ( CASE WHEN Students.Sched_NextYearGrade = 2 THEN 1 ELSE NULL END ) AS Two, SUM ( CASE WHEN Students.Sched_NextYearGrade = 3 THEN 1 ELSE NULL END ) AS Three, SUM ( CASE WHEN Students.Sched_NextYearGrade = 4 THEN 1 ELSE NULL END ) AS Four, SUM ( CASE WHEN Students.Sched_NextYearGrade = 5 THEN 1 ELSE NULL END ) AS Five, SUM ( CASE WHEN Students.Sched_NextYearGrade = 6 THEN 1 ELSE NULL END ) AS Six, SUM ( CASE WHEN Students.Sched_NextYearGrade = 7 THEN 1 ELSE NULL END ) AS Seven, SUM ( CASE WHEN Students.Sched_NextYearGrade = 8 THEN 1 ELSE NULL END ) AS Eight, SUM ( CASE WHEN Students.Sched_NextYearGrade = 9 THEN 1 ELSE NULL END ) AS Nine, SUM ( CASE WHEN Students.Sched_NextYearGrade = 10 THEN 1 ELSE NULL END ) AS Ten, SUM ( CASE WHEN Students.Sched_NextYearGrade = 11 THEN 1 ELSE NULL END ) AS Eleven, SUM ( CASE WHEN Students.Sched_NextYearGrade = 12 THEN 1 ELSE NULL END ) AS Twelve, SUM ( CASE WHEN Students.Sched_NextYearGrade = 13 THEN 1 ELSE NULL END ) AS Thirteen, SUM ( CASE WHEN Students.Sched_NextYearGrade < 99 THEN 1 ELSE NULL END ) AS Total FROM Students WHERE ( Students.Enroll_Status = 0 OR Students.EntryDate > TO_DATE('~[eaodate]','MM-DD-YY') ) AND Students.Sched_NextYearGrade < 99] [/tlist_sql]
    School Pre-Preschool Preschool Pre-K K 1 2 3 4 5 6 7 8 9 10 11 12 13 Total
    ~(School) ~(Minus_Three) ~(Minus_Two) ~(Minus_one) ~(K) ~(One) ~(Two) ~(Three) ~(Four) ~(Five) ~(Six) ~(Seven) ~(Eight) ~(Nine) ~(Ten) ~(Eleven) ~(Twelve) ~(Thirteen) ~(Total)
    ~(School) ~(Minus_Three) ~(Minus_Two) ~(Minus_one) ~(K) ~(One) ~(Two) ~(Three) ~(Four) ~(Five) ~(Six) ~(Seven) ~(Eight) ~(Nine) ~(Ten) ~(Eleven) ~(Twelve) ~(Thirteen) ~(Total)
    ~(School) ~(Minus_Three) ~(Minus_Two) ~(Minus_one) ~(K) ~(One) ~(Two) ~(Three) ~(Four) ~(Five) ~(Six) ~(Seven) ~(Eight) ~(Nine) ~(Ten) ~(Eleven) ~(Twelve) ~(Thirteen) ~(Total)

    ~[wc:admin_footer_css]