DREAM Series: The Integrity Reports

Date: 2019-06-17

Time to Read: 2 Minutes



The next collection of reports, I title the Integrity Reports, primarily because they concern missing information in the system. The three primary use cases in the old system is the Expired Insurance Report, Background Check Report, and Late Reports. Both the Expired Insurance Report and the Background Check Report concern student information, more importantly it reports a list of students whose background check information is missing in the system and a list of students who are either missing insurance information or their insurance has expired. In both reports, the user can narrow the list down to students who are enrolled in a selection of courses, placed at a collection of districts, within a span of academic terms.

Though the Background Check and Expired Insurance Reports are fairly straightforward, the Late Report is much more involved. The Late Report is responsible for showing what instrument submissions are missing (and their specific stages if a standard instrument is involved).

The user chooses a specific course and term and instrument. Based on these choices, the report determines which evaluators are responsible for submitting that instrument(and stage) based on the access rules for that instrument(and stage). It uses these access rules to contrast with the list of current submissions for that instrument in that course and that term to determine the list of evaluators who have not submitted the instrument yet.

Access rules were introduced in previous blog posts and are responsible for controlling the access to certain instruments and other system components.

For example:

The user chooses Instrument 1, HIST 101, and Fall 2010.

There exists the following access rules…

Instrument 1 - HIST 101 - Fall 2010 - Faculty - … Instrument 1 - HIST 101 - Fall 2010 - Site Supervisor - …

This tells the report that we’re expecting submissions of Instrument 1 by both Faculty and Site Supervisors. Therefore, we look at our current submissions for Instrument 1 in HIST 101 for the term Fall 2010 and we compare it to the enrollments for HIST 101 and Fall 2010 and report back the missing submissions based on this information.

In the old system, all of this, including the expected submission rules for each individual instrument was hard-coded on a very large and confusing source file. However, in the new system, this behavior is simply dependent on the access rules that are defined in the database by a user interacting with the system.

This post is about the project, DREAM

An online electronic assessment system for the purpose of collecting assessment data regarding student teachers and counselors throughout their collegiate career. The system also electronically facilitates a large number of other institutional processes in an effective manner.

Read More

DREAM Series

24 June, 2019
A series of posts detailing the multi-year development journal to develop the online electronic assessment system titled DREAM.
View All 22 Posts
Like what you read? Don't? Discuss it.


Blake Adams is a writer, software developer, technical consultant, and financial independence enthusiast living in Oxford, MS.

Latest Posts

Goal Directed Living: Vision Boards and Affirmations

22 March, 2021


Goal Directed Living: Life Lists and More

21 January, 2021


A 2020 Update

03 September, 2020


Software Developer Career Tips: Closing Thoughts

12 February, 2020


Fitness Series: Illnesses and Injuries, Make a Contingency Plan

03 February, 2020


Latest Booknotes

The Power of Habit

19 December, 2019

Read My Highlights in 9 Minutes

Rich Dad Poor Dad

14 October, 2019

Read My Highlights in 10 Minutes

Atomic Habits

19 August, 2019

Read My Highlights in 16 Minutes