How to Identify 8th Grade Students Who Have Been in the District Since Kindergarten?

[powerade]

Hi everyone,

I'm trying to generate a report that identifies current 8th grade students who have been enrolled in our district since Kindergarten — but it's fine if they were out of the district for one year only and later returned.

Has anyone built a report like this before — or is there a more efficient way to approach this within PowerSchool or SQL Reports? 

[kcrable]

You should be able to run a quick student export - select grade 8 from the Start Page -Quick Export - Make sure Entry date is in the field selection box -

EntryDate
Building
ExitDate
^(*contact_info;cat=rel;val=relationship;)
^(*contact_info;cat=addr;which-val=1;val=street,line2,unit, city, stateprovince, postalcode;)

[JeffG9]

^^ This will not return what OP is asking for at all. 

[Scott_Hansen]

Are you wanting to include students who may have started in kindergarten, left for a year or two, then returned?  Or are you looking for consecutive enrollment?

[Scott_Hansen]

I think this might work for you.  It compares the students table with the reenrollments table - grabbing all current 8th graders with at least 7 reenrollment records.

SELECT distinct
     S.student_number,
     s.lastfirst,

     count(r.GRADE_LEVEL)

FROM STUDENTS s
INNER JOIN REENROLLMENTS r on r.STUDENTID = s.id
WHERE
     S.ENROLL_STATUS = 0  AND
     S.GRADE_LEVEL = 8
GROUP BY
     S.student_number, s.lastfirst
HAVING
     count(r.GRADE_LEVEL) > 7

[LoriF6]

If you have Summer School in Powerschool this may not work because summer school enrollment creates extra records in the re-enrollment table.

I have an SQL report where I try and find the year a student entered 9th grade. I use a subquery to find the 1st entry in the table that is for 9th grade. You can use a similar approach in your query.  

LEFT OUTER JOIN
(Select StudentID, Min(EntryDate) as SchEnter
From REENROLLMENTS where grade_level=9
Group by StudentID) RX on s.id=rx.STUDENTID

Then in the Select statement I have:

Case when rx.schEnter is not null then to_Char(rx.SchEnter,'MM/DD/YYYY')
when rx.schEnter is null and s.grade_level=9 then to_char(s.EntryDate,'MM/DD/YYYY')
else 'Enter after 9'
end as EnterNine

This shows me the entry date into the ninth grade for each student. If the student entered after the ninth grade it will print, Enter after 9.