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)
2018-10-25 Now includes version control to update only if newer and not specifically customized by you.
2018-11-28 PGMS - DEL tagged AUT rows were considered in error - FIXED
PGMS also updated to allow hiding the NSLP status and SpEd columns conveniently
Video walk through coming soon!