PowerSchool Reports for Siblings
Overview
On a somewhat regular basis, students in PowerSchool should be audited to link siblings who are not currently linked. The following is a list of reports that will help this identification process. Each report shows different information and all can be filtered.
PowerSchool Sibling and Family Reports
1. Siblings List - Family on One Row
Select Home Address and Family Per Row from the drop downs. These students are linked.
Note that the address on this report is the student's address and not the contact's address.
2. Siblings List With One Row Per Student
Select Home Address and One Student Per Row. Note that the address on this report is the student's address and not the contact's address.
3. Students - Contacts Address List
Sort by address.
Note: this is the contact's address and not the student address.
4. Family Members
This report shows siblings district wide. No address information.
4.
Students Same Mailing Address - Possible Siblings
sqlReports > Siblings and Family > Students Same Mailing Address-Possible Siblings
Shows siblings across district OR filter by school.
Level Data Reports to Find Siblings and Students Living in the Same Household
Level Data has two reports that are helpful for finding siblings. These reports are accessed from the Start page at the bottom of the navigation bar. Click RealTime Reports to get to the reports below. Each report has a list of filters on the left.
Family Lists by Home Phone
This report can be used to find siblings using the contact phone number. The last column of the report shows a phone match. This allows you to sort by that column instead of scrolling the list looking for names. Then you can look at the address to confirm they live at the same address. Remember that you will find matches for students who are not living in the same household if the parent/guardian in that household is an emergency contact for another student. This is going to show you duplicate contact addresses.
Family Lists by Street Address
This is similar
to the Family Lists by Phone Number except the last column indicates
street matches and not phone matches. It also has an address column that
you can use. Use the List Students group function to show the Family ID which is an indication that the students are already linked.
Build a Student List to Show the Family ID
With either of the two Level Data reports above, you can use Make a Current Selection to show if a family link exists for those that are siblings. Once they are the current selection, you can use the Create a List group function to show a column for Family ID which will tell you if they are already
linked. The name of this field is "Family_Ident." You can see the Family
ID in the Family column. When there is no number in that column, it
means the students are not linked.
Note: this process is not for identifying students' FRL status. Click here for the article that describes that process.
Related Articles
PowerSchool Procedures for HomeSchool Students
BSD Procedure: Family supplies evidence of having enrolled in homeschooling with the state (Cognito receipt, Sent email, USPS proof of mailing). Evidence is shown to Administrative Assistant at the student's school they are leaving. Administrative ...Print Labels in Powerschool
To print mailing labels in PowerSchool, the first step is always going to be to select the students. This can be done using the Start page or you can use a report to select the students by running the report and then clicking the Make Current ...PowerSchool Helpful Reports GO
Counts of Contact Details This report is great for showing information missing from student contacts. It gives a count of some of the information in the new student contacts area for each student at the current school. Counts for all columns include ...BTC Grade Reports
There are two Crystal Reports to run for BTC grades. They are located in J:\DATA\crystal-viewer\BTC\Grades. Report 1: BTC_Grade_bySchool-LetterGrade-PS.rpt Report 2: BTC_Grade_bySchool-PS.rpt Open each in Crystal Reports. Go to the Report menu and ...Next Year Planning Reports
The following reports are listed in the Next Year Planning category in SQL Reports. 1. Demographic Counts by NEXT School BSD K-12 A/P Criteria: Active and Pre-registered Next School is not (EEC, BTC, SC, IRA, Grads, ...