1,309
edits
Changes
→Family Representative
<UseRowGroups></UseRowGroups>
<UseRowGroupsOptions></UseRowGroupsOptions>
<DisplayRowGroupsCol></DisplayRowGroupsCol>
<UseRowGroupsCounts></UseRowGroupsCounts>
<sqlChartsReport></sqlChartsReport>
<InitialsqlChart></InitialsqlChart>
<InitialChartName></InitialChartName>
<RowGroupsDesc></RowGroupsDesc>
<sqlExportsReport></sqlExportsReport>
<FLSMapField></FLSMapField>
<ExcFrmList></ExcFrmList>
<ExecGrp></ExecGrp>
<ValueLi3>0</ValueLi3>
<NoHeaderRow></NoHeaderRow>
</pre>
|-
|
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 class="mw-collapsible mw-collapsed">
<ReportName>Family Rep Youngest Selector PSUG</ReportName>
<ReportTitle>Family Rep Youngest Selector PSUG</ReportTitle>
<AfterTitle></AfterTitle>
<ReportGroup>Family</ReportGroup>
<ReportDescription><textarea name="PF-RptDescr-00601219168">Reports students who should be family rep but are not for mass modifying. Make students the current selection and use student field value group function to set their family_rep field to 1.
</textarea></ReportDescription>
<SQLQuery><textarea name="UF-00600519168">SELECT
s.dcid,
s.family_ident as family_id,
s.lastfirst as lastfirst,
s.grade_level as grade,
sc.family_rep
FROM
students s
LEFT OUTER JOIN studentcorefields sc ON s.dcid = sc.studentsdcid
WHERE
s.id IN (SELECT min(id) keep (dense_rank first order by grade_level) FROM students WHERE enroll_status=0 GROUP BY family_ident)
AND nvl(sc.family_rep,0) != 1
AND s.family_ident IS NOT NULL
ORDER BY s.lastfirst</textarea></SQLQuery>
<ReportHeader><th class="DCID">DCID</th><th>Family ID</th><th>Student</th><th>Grade</th><th>FamilyRep</th></ReportHeader>
<CreateStudentSelection>0</CreateStudentSelection>
<StudentSelectionQuery></StudentSelectionQuery>
<CreateStudentSelectionB>1</CreateStudentSelectionB>
<IncludeRowNumber>0</IncludeRowNumber>
<OpeninNewWindow>0</OpeninNewWindow>
<HideCopyButton></HideCopyButton>
<HideCSVButton></HideCSVButton>
<HideTabButton></HideTabButton>
<HidePDFButton></HidePDFButton>
<ShowSearchBox></ShowSearchBox>
<ShowResultsInfo></ShowResultsInfo>
<ParameterName1></ParameterName1>
<ParameterVal1></ParameterVal1>
<ParameterCal1></ParameterCal1>
<ParameterOpt1></ParameterOpt1>
<ParameterName2></ParameterName2>
<ParameterVal2></ParameterVal2>
<ParameterCal2></ParameterCal2>
<ParameterOpt2></ParameterOpt2>
<ParameterName3></ParameterName3>
<ParameterVal3></ParameterVal3>
<ParameterCal3></ParameterCal3>
<ParameterOpt3></ParameterOpt3>
<ParameterName4></ParameterName4>
<ParameterVal4></ParameterVal4>
<ParameterCal4></ParameterCal4>
<ParameterOpt4></ParameterOpt4>
<ParameterName5></ParameterName5>
<ParameterVal5></ParameterVal5>
<ParameterCal5></ParameterCal5>
<ParameterOpt5></ParameterOpt5>
<PdfOrientation></PdfOrientation>
<NoCSVQuotes></NoCSVQuotes>
<NoRowSel></NoRowSel>
<ShowSHC></ShowSHC>
<UseColRe></UseColRe>
<UseFixHdr></UseFixHdr>
<HidePrint></HidePrint>
<ReportNotes></ReportNotes>
<UseColFilt></UseColFilt>
<UseRowGroups></UseRowGroups>
<UseRowGroupsOptions></UseRowGroupsOptions>
<DisplayRowGroupsCol></DisplayRowGroupsCol>
<UseRowGroupsCounts></UseRowGroupsCounts>
<sqlChartsReport></sqlChartsReport>
<InitialsqlChart></InitialsqlChart>
<InitialChartName></InitialChartName>
<RowGroupsDesc></RowGroupsDesc>
<sqlExportsReport></sqlExportsReport>
<FLSMapField></FLSMapField>
<ExcFrmList></ExcFrmList>
<ExecGrp></ExecGrp>
<ValueLi3>0</ValueLi3>
<NoHeaderRow></NoHeaderRow>
</pre>
|-
|
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.
|
<pre class="mw-collapsible mw-collapsed">
<ReportName>Youngest at Campus</ReportName>
<ReportTitle>Youngest at Campus</ReportTitle>
<AfterTitle></AfterTitle>
<ReportGroup>Family</ReportGroup>
<ReportDescription><textarea name="PF-RptDescr-00601215828">Selects the youngest student per family (based on family_ident) at the current school. If at District Level, selects the youngest in the District.</textarea></ReportDescription>
<SQLQuery><textarea name="UF-00600515828">SELECT
s.dcid,
s.lastfirst,
s.grade_level,
s.family_ident
FROM
students s
WHERE
s.id IN (
(SELECT min(id) keep (dense_rank first order by grade_level)
FROM students
WHERE enroll_status=0
~[if.is.a.school]AND schoolid = ~(curschoolid)[/if.is.a.school]
GROUP BY family_ident)
)
ORDER BY
s.lastfirst</textarea></SQLQuery>
<ReportHeader><th class="DCID">DCID</th><th>Student</th><th>Grade</th><th>Family ID</th></ReportHeader>
<CreateStudentSelection>0</CreateStudentSelection>
<StudentSelectionQuery></StudentSelectionQuery>
<CreateStudentSelectionB>1</CreateStudentSelectionB>
<IncludeRowNumber>0</IncludeRowNumber>
<OpeninNewWindow>0</OpeninNewWindow>
<HideCopyButton></HideCopyButton>
<HideCSVButton></HideCSVButton>
<HideTabButton></HideTabButton>
<HidePDFButton></HidePDFButton>
<ShowSearchBox></ShowSearchBox>
<ShowResultsInfo>1</ShowResultsInfo>
<ParameterName1></ParameterName1>
<ParameterVal1></ParameterVal1>
<ParameterCal1></ParameterCal1>
<ParameterOpt1></ParameterOpt1>
<ParameterName2></ParameterName2>
<ParameterVal2></ParameterVal2>
<ParameterCal2></ParameterCal2>
<ParameterOpt2></ParameterOpt2>
<ParameterName3></ParameterName3>
<ParameterVal3></ParameterVal3>
<ParameterCal3></ParameterCal3>
<ParameterOpt3></ParameterOpt3>
<ParameterName4></ParameterName4>
<ParameterVal4></ParameterVal4>
<ParameterCal4></ParameterCal4>
<ParameterOpt4></ParameterOpt4>
<ParameterName5></ParameterName5>
<ParameterVal5></ParameterVal5>
<ParameterCal5></ParameterCal5>
<ParameterOpt5></ParameterOpt5>
<PdfOrientation></PdfOrientation>
<NoCSVQuotes></NoCSVQuotes>
<NoRowSel></NoRowSel>
<ShowSHC></ShowSHC>
<UseColRe></UseColRe>
<UseFixHdr></UseFixHdr>
<HidePrint></HidePrint>
<ReportNotes></ReportNotes>
<UseColFilt></UseColFilt>
<UseRowGroups></UseRowGroups>
<UseRowGroupsOptions>Opt1</UseRowGroupsOptions>
<DisplayRowGroupsCol></DisplayRowGroupsCol>
<UseRowGroupsCounts></UseRowGroupsCounts>
