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!