Nj user exchange april 2013
This presentation is the property of its rightful owner.
Sponsored Links
1 / 12

Navigate Direct Database Export (DDE) Lisa Cahall PowerSchoolSolutions PowerPoint PPT Presentation


  • 71 Views
  • Uploaded on
  • Presentation posted in: General

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

Download Presentation

Navigate Direct Database Export (DDE) Lisa Cahall PowerSchoolSolutions

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Nj user exchange april 2013

NJ User Exchange – April, 2013

Navigate Direct Database Export (DDE)Lisa CahallPowerSchoolSolutions


Relational database

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 teachers

Relational Database


Relational database1

Think of it as a large spider web. Some tables connect directly while others do not.

Relational Database


What are powerschool tables

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?


Powerschool table structure

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 numbers

PowerSchool Table Structure


Example 1 student s table 001

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)


Navigate direct database export dde lisa cahall powerschoolsolutions

Each table has a unique number which tells PowerSchool which table to use when it retrieves information.


Commonly used tables

Students - Student demographic information

Courses - Detailed course information

Teachers - Teacher information

CC - Current Class information

Schools - School information

Sections - Section information

StoredGrades - Historical Grades

Logs - Student log entries

Commonly used Tables


How do i know what s in the tables

You can download the Data Dictionary (a directory of tables and field contents) directly from PowerSource.

https://powersource.pearsonschoolsystems.com

Search for article # 5933.

How do I know what’s in the tables?


Table relationship

Students [1] and Schools [39]

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 table

Table Relationship


Other table relationships

StoredGrades [31] - Schools [39], Students [1], Terms [13]

Sections [3] - Schools [39], Courses [2], Teachers [5]

CC [4] - Students [1], Teachers [5], Terms [13], Sections [3], Schools [39]. Courses [2]

StandardsGrades[99], Standards [53], Students [1]

Logs [8], Schools [39], Students [1], Teachers [5]

Other Table Relationships


  • Login