The General Tidy-up category of Common Tasks includes two sets for scripts for checking data quality.
The Find Active Records of Students That Have Left School script find active tuition enrolments, ensemble enrolments, or loans belonging to students not in the student file. For schools, this is helpful for finding active records for students who have left the school. For conservatoriums, this is helpful for finding active records for students who have been deleted from Music Monitor (usually because they were an erroneous duplicate). Schools will usually wish to terminate all records found by these scripts (be careful not to terminate loans if the instrument has not been returned). Conservatoriums will usually wish to investigate further, and either re-assign records found to a valid student record/s or delete them.
The Find Blank Records scripts find problematic records in their respective file. These are usually records with insufficient data to be of consequence (such as a loan record with no student or instrument assigned). Usually, found records are best deleted.
