Changes

Jump to: navigation, search

Family Management

52 bytes removed, 15:09, 22 March 2018
→‎Family Representative
To maintain the accuracy of the family_rep setting, we rely on some sqlReports. Click "expand" next to any of these reports, then copy/paste the block of code into sqlReports import area.
<div {| class="toccolours mwwikitable"|-collapsible mw! Name ! Description !! Code to copy/paste into sqlReports import box|-collapsed">|'''FamilyID and Rep Audit v2''' - |Finding families and students with no Family ID or where they have more or less than one Family Representative|<div pre class="mw-collapsiblemw-contentcollapsed"><pre>
<ReportName>Family Id and Rep Audit v2</ReportName>
<ReportTitle>Family ID and Rep Audit v2</ReportTitle>
<NoHeaderRow></NoHeaderRow>
</pre>
</div></div>|- <div class="toccolours mw-collapsible mw-collapsed">|'''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 pre class="mw-collapsiblemw-content><precollapsed">
<ReportName>Family Rep Youngest Errors</ReportName>
<ReportTitle>Family Rep Youngest Errors</ReportTitle>
<NoHeaderRow></NoHeaderRow>
</pre>
</div>
</div>
 
{| class="wikitable"
|-
! Description !! Code to copy/paste into sqlReports import box
|-
|
'''FamilyRep Youngest Selector'''
|
Finding students who should match the "Youngest in Family" rule but do not for the purpose of selecting and mass modifying their family_rep setting via Student Field Value
</pre>
|-
|
'''Youngest at Campus'''
|
The system described above selects the youngest in the family for the District. If a school needs to select one student per family for just their campus, this sqlReport can be used, assuming family_ident is properly maintained for all students.
Retrieved from "https://www.psugcal.org/index.php?title=Special:MobileDiff/224"

Navigation menu