Contact Info for Groups of Students.

There are multiple ways to locate contact info for students and this article will assist you in gathering the contact information for groups of students.

How to pull Student Contact Info from Data Warehouse

  1. In the Data Warehouse under SPS Reports, click “Student Contact Information”.

Uploaded Image (Thumbnail)

  1. Under Student Contact Information, click “ Student Contact Information – Whole School”.

Uploaded Image (Thumbnail)

  1. The data warehouse will then download an excel spreadsheet to your downloads with many fields such as student email address, student phone number, and mailing address:

Uploaded Image (Thumbnail)

How to Run a List Report from PowerSchool 

Step1:  Select group of students (select a grade level or a class etc).

Step2:  Select “List Students” from Group Functions button located beside the Select by Hand button.

Uploaded Image (Thumbnail)

Step3:  Create your report. 

Indicate a Report Title  

Identify the fields and column titles you wish to appear in your report.   

Uploaded Image (Thumbnail)

Click on the blue “fields” link for a list of fields (see below for commonly used fields)

Field Name must match the PowerSchool field name.

Column Title can be anything you want it to be

Step4:  Indicate sorting preferences.  Note that the report usually sorts alphabetical by student name if sort not provided. 

Step5:  Click “Submit” button at bottom right corner of page.

NOTE: Are you getting unexpected results?  Spelling the field name incorrectly will result in blank data.  Confirm you are selecting the correct field name for the data point desired. 

Common Field Names – These field names can be inserted in list reports.  The data in the parenthesis are not to be included.  They are descriptions to assist you in picking the correct field. 

LastFirst (full name concatenated) 

Last_Name 

First_Name 

Middle_Name 

Age (8 yrs, 9 months as of current date) 

DOB (date of birth) 

DOB;dateformat=mm/dd (DOB without year) 

Ma_BirthCity (place of birth) 

Gender 

Student_Number (student id) 

State_StudentNumber (SASID or state id) 

MA_ERcode (race) 

ParentGuardian 

Mother 

Father 

Home_Phone 

Mailing_Street 

Mailing_City 

Mailing_State 

Mailing_Zip 

Home_Room 

Grade_Level 

Sped_Program (Student Support, SEBS etc) 

Lep_Level (Lv1-Entering, Lv4-Expanding etc

*period_info;0(A);Room (room for expression 0 (A) Homeroom for elementary)

*period_info;0(A);Teacher_name (teacher name for expression 0(A))

Here are some fields using the contact information.  Note that this is the information for the contact – Not Necessarily the student’s information.  Please copy and paste the search into list students.

*contact_info;which-pers=1;val=lastfirst (name of First Contact)

*contact_info;which-pers=1;cat=rel;val=relationship (First Contact relationship to student)

*contact_info;which-pers=1;cat=phone;which-val=all;val=type,phone;item-delim=br (First Contact phone)

*contact_info;which-pers=1;cat=email;which-val=all;val=type,email;item-delim=br (First Contact email)

*contact_info;max-pers=all;which-pers=1;cat=addr;which-val=1val=street,unit,line2;value-delim=br (First Contact address)

Note that if you have room you can also search contact 2 by updating the searches above.

Below is Contact 2 First and Last Name

*contact_info;which-pers=2;val=lastfirst

Print Article