NJ User Exchange – April, 2013. Navigate Direct Database Export (DDE) Lisa Cahall PowerSchoolSolutions. PowerSchool is a relational database which consists of many smaller databases or Tables connected together
PowerSchool is a relational database which consists of many smaller databases or Tables connected together
Each Table contains specific information related to that Table i.e. the Teachers table contains information about the teachersRelational Database
Think of it as a large spider web. Some tables connect directly while others do not.Relational Database
The PowerSchool Tables are the “backend” of the database.
They contain all of the information for schools, students, attendance, grades, etc.What are PowerSchool Tables?
The PowerSchool database contains over200 tables (Not all tables are visible through DDE)
Each record in a table is assigned a unique ID number
Tables relate to each other using these unique ID numbersPowerSchool Table Structure
It contains basic student information - Name, date of birth, address, phone, gender, custom student fields, etc.
This table then relates to other tables containing class schedules, grades, assignments, standards grades, attendance, etc.Example 1: Student’s Table (001)
Each table has a unique number which tells PowerSchool which table to use when it retrieves information.
Courses - Detailed course information
Teachers - Teacher information
CC - Current Class information
Schools - School information
Sections - Section information
StoredGrades - Historical Grades
Logs - Student log entriesCommonly used Tables
You can download the Data Dictionary (a directory of tables and field contents) directly from PowerSource.
Search for article # 5933.How do I know what’s in the tables?
The Students table contains a field called SchoolID
This ID relates to the ID in the Schools able Using this ID you can retrieve information from the Schools tableTable Relationship
StoredGrades  - Schools , Students , Terms 
Sections  - Schools , Courses , Teachers 
CC  - Students , Teachers , Terms , Sections , Schools . Courses 
StandardsGrades, Standards , Students 
Logs , Schools , Students , Teachers Other Table Relationships