SENR ODS reconciliation - unneeded removal records generated
The SENR ODS reconciliation process is creating D records in the removals file needlessly when a student has an enrollment status change (such as grade level, school transfer) - commonly referred to as a 440 or E150 change. In these cases the enrollment date (start date) is not changing... nor are the other SENR operational key fields (School of Attendance, SSID, Start Date) - so a (D)elete record is not needed.
Having uneeded (D)elete records in the removals file causes increased workload due to:
- it requires an additional file to be posted.
- since removing records represents potential data loss, careful data administrators will want/need to validate the validity of the removal transaction (as these should be rarely needed... except in the case of start date change - but that is NOT an Aeries issue).
I have included a document with screenshots to illustrate what I am describing.
Chris Holloway
shared this idea
Hello, this issue has been resolved in the 3/23/2023 update. Here are the Revision Notes:
An unnecessary Delete record was generated when an E150 Exit Reason existed and the School, Student, and Enrollment Start Dates were the same, fixed.
