SY24-25 ADM Escape hatch¶

Due to some errors folks are having pushing data through their SIS, AOE is offering the following solutions for you to upload the data we need to run the ADM calculation.

General Sumission Guidelines¶

1. Files should be uploaded to the folder EFT folder /SLDS VR/SU0XXX/To AOE/ADM
2. Files should be in csv format. If you upload an excel file, I won't be able to find it.
3. Files need to be named exactly as described below, or I won't be able to find it.
4. I will import the file, and then after processing it in the ADM calc, I will output the results used in a file in your /SLDS VR/SU0XXX/From AOE/ADM/SY25 folder where you normally see your ADM output. The goal here is you should be able to confirm that I'm able to import and use your data as expected.
5. Any student information submitted in this way must have a valid record in Ed-Fi already for me to attach this data to. This won't create students in the ADM calculation, it will only adjust their data used in the calculation.

Issue #1 - Unable to upload ADMTDIST for a student¶

Some are unable to set ADMTDIST properly for thier students. These issues would show up in the EFT ADM file SUXXX-ADMTDIST-MISSING.csv.

To resolve this, we will collect and use the information submitted thorugh this file to "fill in the blank" where there is a missing ADMTDIST.

Filename: Missing-ADMTDIST.csv¶

Template file

Issue #2 - Unable to upload Partial ADM for a student¶

The legacy EdFusion file 6_PS_ADM had columns HS_ACTIVADM and ADMHOURS that capture partial ADM enrollment hours.

There is a space in Ed-Fi to submit/capture this data, however I'm not seeing any being submitted by anyone.

I will use any valid value here in the ADM calculation instead of the values calculated by their enrollment dates. If both fields are specified, I will use the HS_ACTIVADM.

Filename: Partial-ADM.csv¶

Template file