1 / 12

Navigate Direct Database Export (DDE) Lisa Cahall PowerSchoolSolutions

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

emi-perez
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. NJ User Exchange – April, 2013 Navigate Direct Database Export (DDE)Lisa CahallPowerSchoolSolutions

  2. 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

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

  4. 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?

  5. 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

  6. 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)

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

  8. 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

  9. 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?

  10. 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

  11. 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

More Related