This is a useful predefined query used to prepare for EOY or end of year. Inactive Records requiring archive are students who have a recent inactive reason that requires the district to report the transaction, but it appears no archive has been created. By recent we mean within the given academic year starting…