Immunization - All Requirements Met - Dedicated Field
Please consider adding a dedicated field for the Immunization "All Requirements Met" value.
The IMM table has three fields indicating student has met requirements (IMM.RMP, IMM.RMK, IMM.RM7). However these fields can all be left blank because this value is calculated on-demand for students comparing their immunization record to the VAC table and reported on the screen no matter what these fields contain. See screenshot attached.
We can run a report and process the records...unfortunately, running the on-demand report listing takes more than 20 minutes to complete. We are using this field with partner agencies and need to provide social and health metrics for all students and aggregate them by district geographies. Not having this value at a student level causes a serious backup in the processing of this information.
Please consider updating the IMM record to provide a column with the calculated "All Requirements Met" value.
Thanks,
