1,309
edits
Changes
→Family Representative
family_rep#
To maintain the accuracy of the family_rep setting, we rely on some sqlReports. Click the name "expand" next to expand any of these reports, then copy/paste the block of code into sqlReports import area.
*<span class="mw-customtoggle-familyIdRepAudit">'''FamilyID and Rep Audit v2'''<span> - Finding families and students with no Family ID or where they have more or less than one Family Representative
<pre class="mw-collapsible mw-collapsed" id="mw-customcollapsible-familyIdRepAudit">
</pre>
<div class="NavFramemw-collapsible mw-collapsed"><div class="NavHead">'''Youngest FamilyRep Errors''' - Finding all students in families whose family_rep does not match the "Youngest in Family" rule. Useful for selecting these students and clearing their family_rep value. Then use the report below to set the correct representative.</div><div class="NavContent" style="display:none;mw-collapsible-content>
<pre>
<ReportName>Family Rep Youngest Errors</ReportName>
