Monday, April 10, 2017

Family Contact Info, Civic and Early Closure

For the family rep, this report lists his/her siblings, school they attend, homeroom, civic address, the parents' contact information and the early closure information for the family rep and sibling.

Sorted by last name in each homeroom - Here
Sorted by last name - Here

For each family, you need one family rep - set on the modify info page. As well, students that are siblings should be linked on the Family page in PowerSchool (Steps: Here).

Startpage --> System Reports --> SQL Reports --> Linking Family Reports --> Family Contact Info and Civic Address





Code:

Sorted by last name in each homeroom - Here
Sorted by last name - Here

Family Contact Info and Civic Address


For the family rep, this report lists his/her siblings, school they attend, homeroom, civic address and the parents' contact information.

Sorted by last name in each homeroom - Here
Sorted by last name - Here

For each family, you need one family rep - set on the modify info page. As well, students that are siblings should be linked on the Family page in PowerSchool (Steps: Here).

Startpage --> System Reports --> SQL Reports --> Linking Family Reports --> Family Contact Info and Civic Address




Code:

Sorted by last name in each homeroom - Here
Sorted by last name - Here

Number of Family Reps by Homeroom

This report counts the number of family reps in each homeroom. This is ideal for knowing how many paper copies of newsletters, announcements, etc need to be printed or phone calls to be made on unexpected school closures to reach all families. (Here) For each family, you need one family rep - set on the modify info page. As well, students that are siblings should be linked on the Family page in PowerSchool (Steps: Here).


Startpage --> System Reports --> SQL Reports --> Linking Family Reports --> Number of Family Reps by Homeroom





Code:

Here

Family Member Report (SQL)

This report lists the family reps in your building and his/her linked siblings (Here). For each family, you need one family rep - set on the modify info page. As well, students that are siblings should be linked on the Family page in PowerSchool (Steps: Here).

Startpage --> System Reports --> SQL Reports --> Linking Family Reports --> Family Member Report






Code:


Here