Determining Whom to Report in MCIR

Current year entry date and code are in the Student table. Previous year entry data is in the Reenrollments table. To make it possible for you guys to search entirely in Student, I find the kids in the Reenrollment table and match the records to the Student table to and put an X in the immunizaton_dpt field in Student.

To get the kids, you first search for entry codes that are not 'internal':

First, find the kids new to the district in the current school year:
entrycode#91;entrycode#PR;entrycode#RT;entrydate<1/1/2012

In the next screen, knock out the original search term and type in (WITH the plus and the typo):
+immunizaton_dpt=X

That will add the kids who have an 'external' entry code and an entry date after 1/1/2011. (ITD flags these records in PowerSchool in August each year)

If you are an elementary (except AAO), you would next add on the kindergarten kids:
+grade_level=0

If you are a middle school, you would add on the 6th graders:
+grade_level=6

If you are Ann Arbor Open, you would use the following to pick up both Ks and 6s:
+grade_level IN 0,6

The resulting kids should be the ones you want. There is a handy, dandy Export Template that will dump out the names in the exact format that MCIR requires. In the group functions, choose 'Export Using Template', then 'Students', and finally 'MCIR Roster Upload.' Save the file as yourschoolname.txt and proceed to the MCIR website.

On the MCIR website, go to the Build Roster screen and choose 'Load External File'. See second link below for detailed steps to upload the list.

There are helpful notes available from MCIR regarding quickly cleaning out and then uploading new students. See the following items under Resource Library in the Schools/Childcares section:

• How to Modify Your Roster Quickly
• How to Load External Data (Build a Roster Using an Import File)