~[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 > Student List~[wc:admin_navigation_css]

Student List

Student Enrollment List as of ~[eaodate] for ~[tlist_sql; SELECT Schools.Name FROM Schools WHERE (Schools.School_Number = ~[gpv:School])] ~(Schools.Name) [/tlist_sql] Grade ~[gpv:Grade_Level]
  • This report is for the next school year not the current year
  • This report pulls its data from the "Next Year Grade" and the "Next School Indicator" fields on the Scheduling Setup screen
  • Pre-registered students need to have the grade level they will be enrolled in next year entered on that screen for this report to pull accurate enrollment numbers
  • After the end of year process is run this report will no longer be accurate


  • ~[if.~[gpv:School] = ~(curschoolid)] ~[tlist_sql; SELECT Students.DCID, Students.LastFirst FROM Students WHERE ( Students.Enroll_Status = 0 OR Students.EntryDate > '~[eaodate]' ) AND Students.Sched_NextYearGrade = ~[gpv:Sched_NextYearGrade] AND Students.Next_School = ~[gpv:Next_School] AND Students.Sched_Scheduled = 1 ORDER BY Students.LastFirst;alternatecolor] [/tlist_sql]
    Student Name
    ~(count;-) ~(Students.LastFirst)
    [else] ~[tlist_sql; SELECT Students.LastFirst FROM Students WHERE ( Students.Enroll_Status = 0 OR Students.EntryDate > TO_DATE('~[eaodate]','MM-DD-YY') ) AND Students.Sched_NextYearGrade = ~[gpv:Sched_NextYearGrade] AND Students.Next_School = ~[gpv:Next_School] AND Students.Sched_Scheduled = 1 ORDER BY Students.LastFirst;alternatecolor] [/tlist_sql]
    Student Name
    ~(count;-) ~(Students.LastFirst)
    [/if]

    ~[wc:admin_footer_css]