PowerSchool Data Map

• 2023-09-21
• 2 minute read

A PowerSchool data map is a useful tool for administrators and developers who need to understand the data structure of the system, as well as for teachers and staff who need to access and manipulate student data within the system. It can help ensure data accuracy and consistency across the system, and can also aid in the development of custom reports and data analysis tools.

Students Table

Field Name	Description	Data Type	Example Value
Student Number	The unique identifier for the student in the system.	Integer	100001
Last Name	The student's last name.	String	Smith
First Name	The student's first name.	String	John
Grade Level	The student's current grade level.	Integer	11
Homeroom Teacher	The name of the teacher assigned to the student's homeroom class.	String	Ms. Johnson
Enrollment Date	The date the student was enrolled in the school.	Date	2022-09-01
Gender	The student's gender.	String	Male
Birthdate	The student's date of birth.	Date	2005-06-15

 

Guardians Table

Field Name	Data Type	Description
First Name	Text	First name of the guardian
Last Name	Text	Last name of the guardian
Relationship	Text	Relationship of the guardian to the student
Email	Text	Email address of the guardian
Home Phone	Text	Home phone number of the guardian
Work Phone	Text	Work phone number of the guardian
Cell Phone	Text	Cell phone number of the guardian
Address	Text	Mailing address of the guardian
City	Text	City of the guardian's mailing address
State	Text	State of the guardian's mailing address
Zip Code	Text	Zip code of the guardian's mailing address
Primary	Boolean	Indicates if the guardian is the primary contact for the student
Authorization	Boolean	Indicates if the guardian has authorization to pick up the student from school