Enrollment from Previous Year

smansy
Recruit

Enrollment from Previous Year

Hello,

 

I am trying to find the enrollment in the school from the school years of 2019-2020 and 2020-2021. However, even when I change the year I am viewing, I still get the enrollment from this year.

 

Please help. 

3 Replies
HeatherWeist
PowerSchool Champion
PowerSchool Champion

@smansy  I you want to see a student's history enrollment information, you need to access the Reenrollment table in DDE. 

 

If you just want to which students were enrolled in a specific school or in the district on a specific date in a previous year, you can do the following...

 

Change to that year > Search *as_of=MM/DD/YYYY 

This will give you a list of students who were actively enrolled in the school or district on that day. 


Heather Weist, M.S.E
PowerSchool Specialist, Westside Community Schools, Omaha, NE (K-12, ~6000 students)

PowerSchool Mentor/Champion



Did your issue get solved? Please remember to give Kudos and/or select Accept As Solution on the helpful posts to thank the author and to help others find the solution. Thanks!
smansy
Recruit

Thank you for the quick response, however, I am unsure on how to get to the area where I can change the year. I found the DDE tab, but there is not an area where I can change the year. 

 

Thank you again.

 

 

JyotishkaB
Community Support Expert
Community Support Expert

Hi @smansy 

 

You would have to select the Re-enrollment Tables in DDE to search/pull records for students enrolled in school during a specific date range. Please refer to the following steps to access the previous year enrollments:

 

  • Navigate to the Start Page >  System Administrator > Direct Data Export (DDE)
  • Select the ReEnrollments table from the current table 
  • Search the ReEnrollments table for all records that for example meet the following criteria while filtering using EntryDate <= 15/03/2021 and ExitDate >= 30/05/2020 etc.
  • Click "Search all XXXX records in this table." PowerSchool returns all historical enrollments at the current school for the specified date range.
  • Select the Students table and then select all the records in the student table.
  • Click Match Selection.
  • On the Match USM Selection screen, select the ReEnrollments table.
  • Click Proceed to Match Selection. PowerSchool will return all students with a historical enrollment in the specified date range.
  • Return to the Start Page and type the following search command: +/entrydate<=15/03/2021;exitdate>=30/5/2020

If you're only concerned with students enrolled on a specific date, you can use *as_of instead. Example: To find students enrolled on the last day of the 2020-2021 school year (06/11/2021) search by *as_of = 06/11/2021.

 

 

Jyotishka B.
Community Moderator



Remember to give Kudos to suggestions that help you!
If another user helps solve your issue, please select Accept As Solution on their post so others can see the solution, too!