DDE- how to get past year student enrollment summary for multiple courses?

[PSNewbie]

Hi,

I need enrollment summary for multiple schools for past year( i.e. including past year transferred out students as well). How can I get it from DDE. I am new to DDE and do not understand the schema to understand which tables to use and how to match them. Any suggestions would be helpful. 

Thanks 

[evelyn69mohr]

Getting a past-year student enrollment summary for multiple courses in DDE is not a straightforward process due to the complex database schema. There isn't a single, simple report or query. You would likely need to join multiple tables, such as Student, Enrollment, and Course tables, filtering by academic year and including records for both currently enrolled and transferred-out students.