Home of MIS2000 - We Speak Migrant


Locking Enrollments by School Year

We've used a variety of methods over the years to control which users can edit which enrollments and so forth, but bringing Michigan on over the past year presented some challenges because they already had a lot of processes that worked well for them but weren't in line with anything we'd ever done in MIS2000. One of these was the ability to lock enrollments for an entire school year from editing by anyone. I'm always a little amazed when something like this comes up because I don't think anyone across all these years in all these states has ever asked for that. And yet it seems like something lots of folks would want.

We took a couple different runs at it but finally decided on a very neat solution that integrated almost effortlessly into the architecture we already had for this, so the whole app picked it up for free. We wound up just adding a new field to their Funding Year table called Locked. Whenever they want, they can just go in and change it to Y for a year, and bang, every enrollment in that school year is locked for everyone. No more edits. And it can be turned off just as easily if the need should arise. It looks like this in the code table editor:

I think we've already implemented this for another state, but I'm not sure who, maybe Wisconsin. But it works great and it's pretty easy.

Email Subscription

Stay connected and receive email updates with new MS/EdD blog posts.

Authors List

Jeff Gaiche 168 9
Marcy Bolt 104 5
Kevin Donn 2055 88

Most Recent Posts

Welcome Indiana!
6/30/2020 8:02 AM | Kevin Donn
"... in your next release"
6/8/2020 3:42 PM | Kevin Donn
Field Level Change Logging
5/18/2020 4:07 PM | Kevin Donn
Using COEs as Student Lists
4/27/2020 4:29 PM | Kevin Donn
Autologout Completely Rewritten
4/6/2020 4:07 PM | Kevin Donn
Added Preferred ID to Student List Export
3/16/2020 3:18 PM | Kevin Donn
Copyright © 2020 Management Services for Education Data