The attached ZIP file has 4 SQL views that your database administrator could run fairly quickly to add them to your Aeries Experience if you wish.


Program and Authorization Status (PGMS) - One flat row for their program involvement and authorizations.

Contacts On One Line (Pivoted) (CONP) - Yes it does just that when you query it.

Gradebook Analysis (GBKA) - Many rich details about how students are performing in a gradebook in aggregate

Attendance Percentage by Period (APBP)


Video walk throughs coming soon!