Note: This article covers creating an extract for Easy MAA (EasyMAA.org) and is based on instructions provided by that vendor. This article is relevant for the 2017-2018 school year.
In order to determine the discount percentage for your MAA Claiming Unit, they will need you or your IT staff to create a student database of your total student attendance for the 2nd quarter (October-December).
The file must have the following fields:
- Last Name
- First Name
- Middle Initial (if available)
- Date of Birth (YYYYMMDD)
- Gender
- School Name (Optional)
- County Code (Optional)
The following Aeries query will create the first 6 columns of the data needed. You will also need to include inactive students:
LIST STU IDN ENR LOC STU.LN STU.FN STU.MI STU.BD STU.SX LOC.NM IF ENR.YR = 2017 AND ENR.SC = STU.SC AND ENR.SN = STU.SN AND ENR.ED <= 12/31/2017 AND ( ENR.LD >= 10/01/2017 OR ENR.LD = NULL )
Export data to Excel and change the Birth Date field to YYYYMMDD. You can add a column at the end for the optional column for County Code.
You can run the following query to confirm you are extracting the right data.
LIST STU IDN ENR LOC STU.LN STU.FN STU.MI STU.BD STU.SX LOC.NM STU.SC ENR.SC STU.ID STU.CID STU.TG STU.GR ENR.ID ENR.YR ENR.SN ENR.GR ENR.ED ENR.LD IF ENR.YR = 2017 AND ENR.SC = STU.SC AND ENR.SN = STU.SN AND ENR.ED <= 12/31/2017 AND ( ENR.LD >= 10/01/2017 OR ENR.LD = NULL )
If you have any further questions regarding the extract, please contact the vendor.